Microsoft Office Tutorials and References
In Depth Information
Using the F4 Key to Simplify Dollar Sign Entry
Figure 8.11.
Figure 8.11. After you press F4 once, the reference changes to an absolute
After you press F4 once, the reference changes to an absolute
reference, with two dollar signs.
reference, with two dollar signs.
33. Press the F4 key again. The reference changes to A$6 to freeze the
reference to row 6, as shown in Figure 8.12 . This still isn t right be-
cause freezing the reference to row 6 will not help.
Figure 8.12.
Figure 8.12. Press F4 again to switch to a mixed reference with the row num-
Press F4 again to switch to a mixed reference with the row num-
ber locked.
ber locked.
44. Press F4 one more time. Excel locks just the column, changing the ref-
erence to =$A6, as shown in Figure 8.13 . This is the version of the ref-
erence you want. As you copy the formula across, the formula al-
Search JabSto ::




Custom Search