![]() ![]() Once you enter the password, you can freely edit that range of cells. When you try to edit a cell that was password protected, you must have the correct password in order to edit that cell. Re-enter the password on the next window and hit OK.Once the worksheet is locked, only those that have a password to edit specific ranges will be able to edit anything, unless, of course they have the password that was used to lock this sheet. In the window that opens, type a password that will be used to lock the entire worksheet.Make sure that you are still viewing the worksheet where you added the password protected ranges and then go to the Review tab and click Protect Sheet. In order to make this work, we need to protect the worksheet. When you are done, hit OK on the window that lists the ranges, the one shown in Step 9. Repeat Steps 7 to 9 as much as you need to add as many password protected ranges as you need.Now, we have two password protected ranges. ![]() Finish filling out the Title and the Password like we did above and then hit OK and re-enter the password. Now, your new range has been selected and is ready to go. Then, hit Enter or click the little box on the right side of the tiny window again. To do that, click the little box to the right of the input box for the Refers to cells: section. The difference now is that you will need to select the new range that you want to be password protected.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |