cssc1
asked on
How to lock all cells except selected cells?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)
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)
Sorry badrhino, didn't see your reply.....
barry
barry
No prob.
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