![]() The difference now is that you will need to select the new range that you want to be password protected. Hit New to add another range if you want.Now, you will see the password protected range of cells and the title for that range in a list.In the next window, you will have to re-enter the password you used in the previous window and then hit OK.In the window that opens, enter a title for the range, this is what you will see when you manage ranges that can be edited make sure the cells that you want to be edited by the user are entered correctly, this should have happened already if you selected the desired cells before you got here then, enter a password that the user must have in order to edit this range of cells.A window will open in that window, click New. ![]() Go to the Review tab and click Allow Users to Edit Ranges.Select the cell or range of cells that you want only a certain person to be able to edit.Steps to Allow Only Certain People to Edit Specific Cells in Excel ![]() This allows you to have more robust Excel files and to reduce the chance that someone messes-up something in the worksheet. This is a security feature that you can setup so that a user has to have a specific password in order to edit parts of a worksheet. How to allow only certain people to edit certain cells or ranges in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2023
Categories |