Locking one single cell in Excel

Asus Eee pc 1005ha blue netbook
February 18, 2010 at 23:06:50
Specs: Windows XP, 2096
Hello everyone,

I've been trying to lock ONE SINGLE cell in the Excel sheet.
I say: ONE SIGLE CELL , thats all

I have already checked the guide on the Microsoft page but it doesn't make sense - they give the same instruction to lock the majority of cells onthe sheet and the same to unlock the majority of cells.

So, could you give me an ultimate instruction that would work?

Thanks a lot in advance for any support!


See More: Locking one single cell in Excel

Report •

February 19, 2010 at 04:15:05

Select the whole worksheet, (use the square between the row and column labels at top left). Right-click, select Format Cells.. and then the Protection Tab. Clear the 'Locked' check box, click OK.

Select the one cell to be locked.
Right-click etc. and check the 'Locked' check box. click OK.

Now apply password protection to the whole worksheet:
Tools - Protection - Protect Sheet.
You can accept the default or you can clear the 'Select locked cells' check box.
Even if the user can select your locked cell, they will not be able to change it.
Add password and follow remaining steps.

You didn't say what version of Excel you are using.
The above is for Excel 2003, but a similar approach should work for Excel 2007. There isn't a Menu with 'Tools', so if you have Excel 2007, you will have to find the worksheet protection dialog box from the Ribbon. I don't have Excel 2007 on this PC, so I can't walk you through it.


Report •

February 19, 2010 at 11:19:11
Thanks a lot, Humar.

Hope that this time it will work...


Report •

February 19, 2010 at 11:27:19
Works great , thank you again , Humar!


Report •

Related Solutions

Ask Question