Hi. Are you using some key combination to put the $ sign in your formula?
I can see you are putting them all at once and was wondering if you are editing the video or use some key combination?
3 answers ( 0 marked as helpful)
Same doubt, even searched in Google for that ..
Press F4 once to fix the column and row, press F4 twice to fix the row only and press F4 three times to fix the column only.
Fn+F4 for Mac users and it'll change it as you type the formula.