Most Respected Sir,
I am unable to lock a single specific cell in excel. Please help me.
With much regards
BARENYASANYAL14@GMAIL.COM
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Locking a single specific cell in excel
0
Answers
0
Helo Barenyasanyal14,
This is really quite easy.
On the worksheet, in the top left corner where the column letters (left of "A") and row numbers (above "1") meet, click the arrow. This will select all cells on the worksheet. Then in the ribbon click on "Format" and then "Format Cells". In the window that opens click on the "Protection" tab. Now uncheck the "Locked" option and click "OK" Now on the worksheet select the cell you want to lock. Right click and choose "Format Cells". Go to the "Protection" tab, select "Locked" and click "OK". The last step is to password protect the sheet; when you do, only that one cell will be locked.
If this solves things for you please mark my answer as Selected.
Cheers :-)