Microsoft Office Tutorials and References
In Depth Information
Double-Click the Fill Handle to Copy a Formula
Figure 8.25.
Figure 8.25. Dragging the fill handle is frustrating in a table that has hun-
Dragging the fill handle is frustrating in a table that has hun-
dreds of rows. The double-click method will end that frustration.
dreds of rows. The double-click method will end that frustration.
In this particular case, cell B2 is nonblank, and column B contains a value
in every row down to the end of the data. This is the perfect condition for us-
ing the technique of double-clicking the fill handle. Follow these steps:
11. Enter the formula in cell B2.
22. Press Ctrl+Enter to accept the formula and keep the cell pointer in
cell B2.
33. Double-click the fill handle.
The active cell is copied down to the last row of your data, as shown in Fig-
ure 8.26 .
Search JabSto ::




Custom Search