Excel Tips: A Faster Way to Use the Fill Handle

Lesson 2: A Faster Way to Use the Fill Handle

/en/excel-tips/add-the-current-date-to-a-cell/content/

A faster way to use the fill handle

If you're copying cell content to adjacent cells, you can click and drag the fill handle. The fill handle is the small square in the lower-right corner of the selected cell.

However, with larger spreadsheets, this can be awkward because you'll have to hold down your mouse button and wait for Excel to scroll to the bottom of your sheet. Luckily, there's a shortcut. If you double-click the fill handle, it will instantly copy the cell content downward.

Watch the video below to see this shortcut in action.


Steps

  1. Open your Excel spreadsheet and locate the cell with the formula that you want to copy.
  2. Click on the cell with the formula to select it.
  3. Move your mouse pointer to the bottom right corner of the selected cell. You should see a small black square, which is the fill handle.
  4. Double-click the fill handle. This will automatically copy the formula down to the end of your data, matching the rows in adjacent columns.
  5. Scroll down to the bottom of your data to check if the formula has been copied correctly.

This shortcut can definitely help to speed up the process and help you work more efficiently. In the next lesson, we’ll show you two ways to use the Format Painter tool.

/en/excel-tips/two-ways-to-use-the-format-painter/content/