3305 Main Street Ste 019 Vancouver, WA 98663

Copy Formulas Using the Fill Handle

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.