Resolved: Fixing the columns so quickly
how did you fix the columns so quickly, meaning changing from B:B to $B:$B? Is there a short cut to doing this?
1 answers ( 1 marked as helpful)
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.
Submit an answer
Resolved: How did you select all the table rows and columns in one click?