Microsoft Office Tutorials and References
In Depth Information
Using the F4 Key to Simplify Dollar Sign Entry
lar sign before the column letter. Pressing F4 one more time returns the ref-
erence to a relative reference. You might find it easier to choose the right
reference by looking at the various reference options offered by the F4 key.
The following sequence shows how the F4 key works while you are entering a
formula. This particular example was included because it requires two dif-
ferent types of mixed references.
The important concept is that you start pressing F4 after typing a cell ref-
erence but before you type a mathematical operator.
11. Type =A6
Figure 8.10. This is a relative reference: A6 without any dollar signs.
This is a relative reference: A6 without any dollar signs.
22. Before typing the asterisk to indicate multiplication, press the F4
key. On the first press of F4, the reference changes to =$A$6, as
shown in Figure 8.11 .