Fix the cells in the formula
How do you fix the cells with $ sign? Is there any shortcut instead of inserting $ by hand?
1 answers ( 0 marked as helpful)
Ned Krastev
Instructor
Hi Anura,
Good to hear from you
The shortcut for fixing cell references is F4. When you press F4 multiple times you will be able to change the type of reference you're adding.
Best,
Ned