FREE PROJECT RECIPES
Build Projects, Learn Skills, Get Hired
Learn how you can build Big Data Projects
How to Lock Down a cell ?
In VLookUp Example when we use that formula in a cell and when we drag formula to other cells, we need to lock down the copied cell...how to perform that lock
Oct 20 2013 11:48 AM
Suppose you want to lock down D4. Place the curosor between "D" and "4" and press F4 key. 2 $ signs will appear and it will look like $d$4 - this will lock down the cell.
Oct 21 2013 03:25 PM
This will lock down both the row and column.
In some scenarios you might have to lock down only the row or only the column. In that case, keep pressing F4 until the $ sign changes places.
Oct 21 2013 03:26 PM
Click on this
icon to add code snippet.
(Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)
+Add more files
Hadoop Online Training
Apache Spark Training
Data Science in Python Training
Data Science in R Language Training
Salesforce Certification Training
NoSQL Database Training
Hadoop Admin Training
in vlookup, how do you lock the formula?
How do i lock down the values when using VLOOKUP Function?
How to use VLOOKUP?
Can we use VLOOKUP for geting data from two different excel?
for Vloop up function how to lock value in table_array parameter using keyboard shortcut?
You have not activated your email address. We have emailed you an activation code - please enter it below