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.

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

Follow this topic