Quick summary
The Fill Down feature in Microsoft Excel lets you copy a formula from one cell to an entire column in seconds. Using the fill handle — the small square at the bottom-right of a selected cell — you can double-click to instantly propagate formulas without manual entry.
Steps
- Click on the cell containing the formula you want to copy — the fill handle is the small square at the bottom-right corner of the selected cell.
- Double-click the fill handle to copy the formula down, aligning with the range of adjacent columns.
- Scroll down to confirm the formula has been copied correctly to all rows in the column.
