Microsoft Office Tutorials and References

In Depth Information

**Double-Click the Fill Handle to Copy a Formula**

Figure 8.24.

Figure 8.24.
You can copy a formula by clicking and dragging the fill handle.

You can copy a formula by clicking and dragging the fill handle.

44. When you release the mouse button, the original cell is copied to all

the cells in the selected range.

This method is fine for copying a formula to a few cells. However, if you

have thousands or hundreds of thousands of cells, it is annoying to drag to

the last row. In Excel 2003 and earlier, you would invariably end up fly-

ing past the last row. Note that Excel 2013 automatically slows down and

briefly pauses at the last row. However, it is far easier to copy a formula

by double-clicking the fill handle.

Double-Click the Fill Handle to Copy a Formula

Double-Click the Fill Handle to Copy a Formula

In most data sets, double-clicking the fill handle is the fastest way to copy

the formula. Although you will love this method, you need to understand a

few shortcomings that can hamper the method when an adjacent column has

blank cells among the data.

Figure 8.25
shows a table that has hundreds of rows of data. Suppose you

want to copy the formula from cell C2 down to all the rows of data in column

B.