I need to protect a single cell in excel sheet from modification, Other cell i need to edit, Pls if Any one is there to clarify my doubt regarding this reply soon
Found on the internet and it seems to work:
The default setting for each cell is for them to start locked. So, you
first need to highlight ALL cells in the sheet, right click, choose
format, go to the Protection tab and take the tick out of the Locked
box.
Now no cells are locked.
Now you need to select the one cell you want locking. Right click,
choose format cells, Protection tab and then put a tick into the Locked
box.
Locking the cells does not take place until you have locked the sheet.
So go to Tools, Protection and Protect Sheet. Add a password of your
choosing, and put a tick into every option available to you, EXCEPT the
very top option. "Select locked cells" should NOT have a tick in it.
OK that to confirm, and hey presto, that cell can no longer be
selected, edited or erased unless you unprotect the sheet by entering
the password you chose.
Yes it was helpful
You have first to protect the whole workseet with a password and then unprotect all except the single cell.
801 views
Usually answered in minutes!
×