Just Press Cntrl+A and now all of the cells in the Activesheet will be
selected then Do Right ClickFormat CellsProtectionUncheck the Locked
Check box and give ok.

Now hold Cntrl and take your mouse and click the cells which needs to be
Locked. After selection do Right ClickFormat CellsProtectioncheck the
Locked Check box and give ok.

Now press Alt+T+P+P and give your desired password twice and give ok.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Joe User" wrote:

Apparently, by default, all cells in a worksheet are locked (Format Cells
Protection). Consequently, when I set worksheet protection (Tools
Protection Protect Sheet Password), all cells are protected.

I want to protect just 4 cells. So I think I want the default for all cells
to be unlocked. Then I would lock the 4 cells and set worksheet protection.

Of course, I could manually select every cell in the worksheet (A1:IV65536)
and change the Protection format to unlock. But besides being a "pain", it
appears to increase the worksheet size "unnecessarily".

Is there a better way to change the default cell protection to unlocked?

.