Microsoft Office Tutorials and References
In Depth Information
Enter Formulas Using the Mouse Method
33. To accept cell B2 as the correct reference in the formula, press
either an operator key (for example, * or +), a parenthesis, or the
Enter key. In this case, type *.
44. Note that the dashed cell pointer disappears, and the focus is now
back to the original cell, C2.
Tip
Even if you are mouse-centric, you should try this method for half a
day. When you get the feel for navigating by using the arrow keys, you
can enter formulas much faster by using this method.
55. Press the right-arrow key three times. The flashing cell border
moves to D2, E2, and then F2. With each keypress, the temporary for-
mula in the formula bar shows an incorrect formula (+B2*D2, +B2*E2,
and +B2*F2). Figure 8.20 shows what the screen looks like after you
press the right-arrow key three times.
After step 4, the focus moves to the original cell. Thus, you
only have to press the right-arrow key three times instead of four times to
Figure 8.20.
Figure 8.20. After step 4, the focus moves to the original cell. Thus, you
only have to press the right-arrow key three times instead of four times to
arrive at cell F2.
arrive at cell F2.
66. Press the up-arrow key to move the flashing cell border to the cor-
rect location, cell F1. The temporary formula in the formula bar now
shows +B2*F1.
77. Press the F4 key to add dollar signs to the F1 reference.
88. Press Ctrl+Enter to accept the formula and keep the cell pointer in
cell C2.
Search JabSto ::




Custom Search