Microsoft Office Tutorials and References
In Depth Information
Copying a Formula by Dragging the Fill Handle
Figure 8.23.
Figure 8.23. Pressing Ctrl+Enter tells Excel to enter the formula in the act-
Pressing Ctrl+Enter tells Excel to enter the formula in the act-
ive cell and to copy it to the rest of the selection.
ive cell and to copy it to the rest of the selection.
Copying a Formula by Dragging the Fill Handle
If you want to enter a formula in one cell and then copy it to the other cells
in a range, you can use the fill handle, which is the square dot in the lower-
right corner of the cell pointer. There are two ways to use the fill handle:
Drag the fill handle.
Double-click the fill handle.
The dragging method works fine when you have less than one screen full of
data:
11. Enter the formula in cell B2.
22. Press Ctrl+Enter to accept the formula and keep the cell pointer in
cell B2.
33. Click the fill handle. You know that you are above the fill handle
when the mouse pointer changes to a thick plus sign, as shown in Fig-
Search JabSto ::




Custom Search