We help IT Professionals succeed at work.

How to lock all cells except selected cells?

cssc1
cssc1 asked
on
I have attached a MS Excel workbook which includes the following sheets:
1.  Sheet 1
2. Sheet 3
3. WORKSHEET

The areas on sheet 1 are the cells I am trying to keep from being locked. I can't seem to figure this out. Also, I somehow added a password I am trying to remove "cssc123456". I do not want to use a password when protecrting all ther sheets except the blue cells on sheet 3.
Sound-Testing.xlsx
Sound.bmp
Comment
Watch Question

Commented:
From your tag, I assume you are using Excel 2010.  Under this assumption:

To remove password:
1. Go to the Review ribon and click on 'Protect sheet'
2. Remove password
3. click ok.

To only lock certain cells:
1. Select the whole sheet (Ctrl+A)
2. Right click
3.Format Cells
4. Protection
5. unclick 'Locked'
6. OK
7. Highlight the cells you want to protect.
8. Repeat 1-4
9. Click 'Locked'
10. Click OK
11. Protect sheet (under Review ribon)
Most Valuable Expert 2013

Commented:
Hello cssc1, doesn't seem to be password protected.....go to view tab and the use "Unprotect" button

All cells are locked by default so if you Protect the worksheet that locks everything. Select the range you want to allow to be edited then right click > Format > Protection > untick "locked"

Now go back to View tab and use Protect > hit OK button without filling in password.

Now you can alter only those cells you unlocked....

regards, barry

Commented:
I misread your question.  I thought you only wanted to protect the blue cells.  The following steps would be more approperiate:

To only lock certain cells:
1. Select the cells you want to be able to edit
2. Right click
3.Format Cells
4. Protection
5. unclick 'Locked'
6. OK
7. Protect sheet (under Review ribon)
Most Valuable Expert 2013

Commented:
Sorry badrhino, didn't see your reply.....

barry

Commented:
No prob.