- #How to lock individual cells in excel 2016 how to#
- #How to lock individual cells in excel 2016 password#
The passwords below are to unlock the ranges and the sheet protection for this worksheet. button in the lower left corner of the window (you can see this button in Step 9 above). You can get to the Protect Sheet window from the Allow Users to Edit Ranges window by clicking the Protect Sheet. This is standard behavior for protected worksheets.
#How to lock individual cells in excel 2016 password#
Make sure to use different passwords for each range so that a user cannot unlock and edit a range that they are not supposed to be able to access.Īny ranges or cells that are not allowed to be edited by specific users will not be editable by anyone unless they have the password used to unlock or "unprotect" the worksheet.
Unprotect Specific Ranges: Review tab > Allow Users to Edit Ranges > select the desired range from the list > hit Delete > hit OK. Unprotect the Worksheet: Review tab > Unprotect Sheet > then enter the correct password and hit OK. To remove password protection from the sheet or a specific range you must first remove the worksheet protection and then remove that specific range's protection. 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.
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 lock individual cells in excel 2016 how to#
How to allow only certain people to edit certain cells or ranges in Excel.
0 kommentar(er)
