Resolved: Fixing the columns so quickly

in Introduction to Excel / Use Sumif to Complete the Database Sheet

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)

Ned Krastev

Instructor

Posted on:

24 Jan 2022

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

Helpful answer

Resolved: Fixing the columns so quickly

Submit an answer

related questions