Last answered:

24 Jan 2022

Posted on:

22 Jan 2022

0

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)
Instructor
Posted on:

24 Jan 2022

1

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

Submit an answer