Forum Discussion
Protect a Worksheet
Hi Everyone,
I'm currently working on an excel workbook that will be used as judging material. I have 3 questions regarding the protection of the worksheets:
1. How can I protect multiple worksheets in the same workbook?
2. How can I lock certain cells in a worksheet?
3. Is there a way to hide the activity done in one worksheet from other users?
I'd really appreciate the help.
I'm currently working on an excel workbook that will be used as judging material. I have 3 questions regarding the protection of the worksheets:
1. How can I protect multiple worksheets in the same workbook?
2. How can I lock certain cells in a worksheet?
3. Is there a way to hide the activity done in one worksheet from other users?
I'd really appreciate the help.
2 Replies
- You'll have to protect each of the sheets individually by clicking Protect Sheet on the Review tab of the ribbon. It is not possible to protect multiple sheets in one go.
- By default, all cells on a worksheet are locked, but this only becomes effective when you protect the sheet. So before protecting the sheet, you should select all cells that users should be able to edit and unlock them: press Ctrl+1 to activate the Format Cells dialog, activate the Protection tab, clear the Locked check box and click OK.
- Best give each user their own copy of the workbook, then combine the sheets when they have been filled in.
Thank you for your response 🙂
