- You can quickly copy formulas down by double-clicking the fill handle. The formula will automatically fill down to the first gap in the adjacent data.
- You can also copy formulas into adjacent cells by dragging the fill handle. Select the cell that contains the formula, and then drag the fill handle over the range you want to fill.
The Excel fill handle.