Did you know you could use the F4 function key to toggle the $'s in a cell reference. For example, if you have a cell reference of B5 and select F4 once, you get $F$4.
Twice: F$4
Three: $F4
Four: F4
Hope this helps!
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hello i am new here and i just wanted to say holy crap, the simplest things amuse me in excel, and by golly that did it!! Thanks a bunch :D
Please sign in to leave a comment.