If you have used a password, it will ask you to reconfirm the password. You can allow other options as well such as formatting or inserting rows/columns. By default, the first two boxes are checked that allows a user to select locked and unlocked cells. Enter a password (if you want to password protect the sheet).Make sure that you’ve checked the box ‘Protect worksheet and contents of locked cells’ (it’s checked by default).In the Changes group, click on Protect Sheet.Here are the steps to lock all the cells in a worksheet. Now, since we already know that all the cells are locked by default, all we need to do is to protect the entire worksheet. This essentially means that you want to lock the entire worksheet. Lock all the Cells in a Worksheet in Excel How to hide formula from the locked cell. ![]()
0 Comments
Leave a Reply. |