How to copy a formula down a row in Excel 

When we talk about copying a formula down a row in Excel, it means replicating a formula from one cell to multiple cells in a column while adjusting the cell references automatically. This is done using the fill handle or other copy-and-paste techniques. The importance of copying a formula down a row in Excel lies in its ability to automate calculations and save time. Instead of manually entering the same formula in each cell. 

Our dataset represents a bill of a grocery store with product names in one row, prices in another row, and quantities in another row, you want to create a row that calculates the total cost for each product by multiplying the quantity and price. You have a formula in the first cell of the row and want to copy it across the entire row. There are three methods explained below to copy the formula. 

Method 1: Copy a Formula down a row using the Fill option 

Step 1 – Select the range of cells 

• Select the range of cells where you want to copy the formula  

Step 2 – Click on the Fill option 

• After selecting the range of cells, click on the Fill option in the Cells group of the Home tab and a drop-down menu will appear 

Step 3 – Click on the Right option 

• From the dropdown menu, click on the Right option to get the required result  

Method 2: Copy a Formula down a row using the Shortcut Keys  

Step 1 – Select the range of cells 

• Select the range of cells where you want to copy the formula  

Step 2 – Press the CTRL+R keys  

• After selecting the range of cells, press the CTRL+R keys to get the required result 

Method 3: Copy a Formula down a row by dragging  

Step 1 – Click on the Cell 

• Click on the cell containing the formula to be copied  

Step 2 – Place the Cursor on the Right Corner of the Cell 

• After selecting the cell, place the cursor on the bottom right corner of the cell and a plus symbol will appear 

Step 3 – Drag the Cell 

• After the plus symbol appears, drag the cell till the required cell in that row