3305 Main Street Ste 019 Vancouver, WA 98663

Using the Fill Handle to Copy Formulas

Using the Fill Handle

  • 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.
xl_fillhandle
The Excel fill handle.