How to Fill Down in Microsoft Excel

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

1. 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.
2. Double-click the fill handle to copy the formula down, aligning with the range of adjacent columns.
3. Scroll down to confirm the formula has been copied correctly to all rows in the column.