for Vloop up function how to lock value in table_array parameter using keyboard shortcut?


0
What is the keyboard short cut to lock the table_array parameter in the Vlookup function.
e.g. table_array parameter is range B2:E15, how do i make it $B$2:$E$15 using the keyboard shortcut?

2 Answer(s)


0

f4.

place your cursor inbetwwen the "B' and "2" and press F4. it will lock it.

0

Place your cursor in betwwen the "B' and "2", "E" and "15" and hit F4