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

=A6 (see
Figure 8.10
)
.

Figure 8.10.

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
.