Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
absolute reference shortcut
- Thread starter smil3y
- Start date
Lilliabeth
Technical User
the F4 key
Lilliabeth
-Why use a big word when a diminutive one will do?-
Lilliabeth
-Why use a big word when a diminutive one will do?-
Yes, Lilliabeth is right.
Doing F4 actually rotates references like this:
initial ref A2
press once becomes $A$2 ( absolute column and row )
press again ... A$2 ( relative column/absolute row )
press again ... $A2 ( absolute column/relative row )
press again ... A2
and so on.
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
Doing F4 actually rotates references like this:
initial ref A2
press once becomes $A$2 ( absolute column and row )
press again ... A$2 ( relative column/absolute row )
press again ... $A2 ( absolute column/relative row )
press again ... A2
and so on.
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
- Status
Similar threads
- Locked
- Question