Excel $ Reference Toggle

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!

1 comment

Please sign in to leave a comment.