How do i lock down the values when using VLOOKUP Function?



0
How do i lock down the values when using VLOOKUP Function?

2 Answer(s)


0

Go to the respective cell. Inside the cell lets say there is "A2" that you want to lock. Place the cursor inbetween A and 2 and press F4. It should lock A2 then.

0

Select the Shell (row or columns) you want to Free or lock. ctrl+c (copy the line)right click there on the same columns --> Paste Specials --> Paste velue only.