-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I lock certain cells in a worksheet
- Thread starter hhjrs0
- Start date
dave3009
Well-known Member
- Joined
- Jun 23, 2006
- Messages
- 7,142
- Office Version
- 365
- 2021
- Platform
- Windows
- Mobile
- Web
Hi There
First set which cells are to be locked by pressing Ctrl+F1 on the cell in question, select Protection tab the uncheck locked.
Once you have all the cells you want unlocked protect the sheet by going to Tools>>Protect>>Protect Sheet you can enter an optional password.
HTH
Dave
First set which cells are to be locked by pressing Ctrl+F1 on the cell in question, select Protection tab the uncheck locked.
Once you have all the cells you want unlocked protect the sheet by going to Tools>>Protect>>Protect Sheet you can enter an optional password.
HTH
Dave
Upvote
0
shajueasow
Well-known Member
- Joined
- Oct 7, 2004
- Messages
- 1,926
Welcome to the board.
Select the cells you want to allow changes and through Format>Cells>Protection Tab uncheck the "Locked" option. After this password protect your sheet (Tools>Protection>Protect Sheet)
HTH
Select the cells you want to allow changes and through Format>Cells>Protection Tab uncheck the "Locked" option. After this password protect your sheet (Tools>Protection>Protect Sheet)
HTH
Upvote
0
Similar threads
- Question
- Question
