Microsoft Office Tutorials and References
In Depth Information
Using the F4 Key to Simplify Dollar Sign Entry
ways points back to column A. As you copy the formula down, the row
number in this reference is allowed to change to point to other rows.
Figure 8.13.
Figure 8.13. Press F4 again to switch to a mixed reference with the column
Press F4 again to switch to a mixed reference with the column
letter locked.
letter locked.
55. To continue the formula, type an asterisk to indicate multiplication
and then click cell C5 with the mouse. At the point shown in Figure
8.14 , you would press F4 twice to change C5 to a reference that locks
only the row (that is, C$5).
Figure 8.14.
Figure 8.14. After clicking C5 with the mouse, press F4 twice to change this
After clicking C5 with the mouse, press F4 twice to change this
reference.
reference.
Search JabSto ::




Custom Search