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

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password