Microsoft Office Tutorials and References
In Depth Information
Using F4 on a Rectangular Range
Figure 8.16.
Figure 8.16. Using F4 at this point never produces the desired result of
Using F4 at this point never produces the desired result of
B$2:B29.
B$2:B29.
At this point in the figure, you might be tempted to press the F4 key. This does
not work. If you select B2:B29 with the mouse or arrow keys, pressing F4 now
converts the reference to the fully absolute range $B$2:$B$29. Continuing to
press F4 toggles to B$2:B$29, then $B2:$B29, and then B2:B29. Excel does not
even attempt to go through the other 12 possible combinations of dollar signs
Search JabSto ::




Custom Search