Fix the cells in the formula

in Introduction to Excel / Excel's Lookup Functions: VLOOKUP & HLOOKUP made easy

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

Posted on:

21 Apr 2022

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

related questions

Panagiotis Blatsas

Index and Match exercise tried the exact formula yet all results are N/A?

Sali Sali

Hi. Are you using some key combination to put the $ sign in your formula?

Alejandro Hasselmeyer

Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error

Manish Rochwani

percent variance formula showing error

Muthumani .A.P

"Distribution" cells

Emmanuel Edu

No error for last formula

Panagiotis Blatsas

In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?

Nguhemen Tingir

Resolved: Formula not working