Resolved: Fixing the columns so quickly
Hi,
how did you fix the columns so quickly, meaning changing from B:B to $B:$B? Is there a short cut to doing this?
Thank you.
1 answers ( 1 marked as helpful)
Hi!
Absolutely - the F4 key is the shortcut to fix both references (if pressed once) and then to fix column or row references only if pressed multiple times.
Best,
Ned