Last answered:

21 Apr 2022

Posted on:

20 Apr 2022

0

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

21 Apr 2022

0

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

Submit an answer