Naranzul Amartugs
Last answered:

21 Apr 2022

 Posted on:

20 Apr 2022
0

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
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

related questions

Panagiotis Blatsas
0
12
Index and Match exercise tried the exact formula yet all results are N/A?
Sali Sali
1
6
Hi. Are you using some key combination to put the $ sign in your formula?
Donald Trenholm
0
4
error with formula
Asmaa Abdulhamid
0
4
how to show the value in parentheses while it is assigned with a minus in the row formula
Alejandro Hasselmeyer
2
4
Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error
Muthumani .A.P
0
4
"Distribution" cells
Emmanuel Edu
1
4
No error for last formula
Manish Rochwani
0
4
percent variance formula showing error