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?

Moataz Ahmed

Resolved: Criteria Typing in the Formula

Manish Rochwani

percent variance formula showing error

Panagiotis Blatsas

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

Donald Trenholm

Resolved: error message "There's a problem with this formula"

No error for last formula

Asmaa Abdulhamid

how to show the value in parentheses while it is assigned with a minus in the row formula

Nguhemen Tingir

Resolved: Formula not working

Alejandro Hasselmeyer

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