Microsoft Office Tutorials and References
In Depth Information
Double-Click the Fill Handle to Copy a Formula
ure 8.24 . Drag the mouse down to the last row of data, which in this
case is cell C14.
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.
Search JabSto ::




Custom Search