Notice that once locked, most of the options on Excel are no longer available. If you’ve entered a password, you might be asked to reconfirm the password.Click OK once you’ve selected all the options you want.Here, you can allow options to specify what other users can do. By default: Select locked cells and Select unlocked cells are checked.You can enter a password so that changes can only be made with a password.In the Protect Sheet dialogue box: click the Protect worksheet and contents of locked cells box (it should be checked by default). ![]() In the Changes group, click Protect Sheet. ![]() What we’re actually doing here is protecting the entire worksheet, ince all cells are locked by default Since all cells are locked by default, what we’re actually doing here is protecting the entire worksheet. You can only prevent changes from being made by locking and protecting the cells.įollow the instructions below to lock the entire worksheet. Moreover, all cells in Excel are locked by default. You can even freeze the entire table! And the method is pretty much the same no matter what you choose to do.
0 Comments
Leave a Reply. |