How to fill down in Excel

You can watch a video tutorial here.

Excel has several handy features for simplifying worksheet operations. One such feature is the ability to ‘fill down’ or copy formulas or text to other cells in a column.

Option 1 – Use the Fill handle 

• Select the source cell 
• Position the pointer over the lower right corner of the cell and it will change to a plus sign (+) which is called a fill handle
• Holding the fill handle, drag the box down the column, across the range that is to be filled

Option 2 – Use the menu option

Step 1 – Select the cells

• Select the source cell along with the other cells to be filled
• Go to Home > Fill 
• Select Down

Step 2 – Check the result

• The formula is copied to the other cells in the selected range