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