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. 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. 
REMOVE ENABLE EDITING IN EXCEL VPN HOW TO
How to allow only certain people to edit certain cells or ranges in Excel.
0 kommentar(er)
