Excel Tips
Showing posts with label
Excel
.
Show all posts
Showing posts with label
Excel
.
Show all posts
Monday, April 20, 2009
Toggle Between Relative and Absolute References
Use the function key
F4
to toggle a reference between relative and absolute references while editing a formula. Repeatedly pressing F4 will cycle through the 4 different options in this order:
A1, $A$1, A$1, $A1
.
Read more »
Older Posts
Home
Subscribe to:
Posts ( Atom )