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.