Password protect cells in excel 2013 password#
If they supply the correct password (this is the one that you specified in steps 17 and 19), then they can edit anything they want in columns E and J. As someone is using a worksheet protected in this manner, when they try to modify a cell in columns E or J, they are asked for a password. The advantage to this approach is that you have two levels of passwords-one for the range (columns E and J) and one for the worksheet as a whole. Enter the password you used in step 23 a second time.
This should not be the same password you used in step 17 and step 19 it should be different.
This new tool, which allows you to password-protect ranges of cells, requires a variation on the steps presented earlier in this tip. You can then protect that information and simply reference it within the current worksheet.Ī third approach is to use a tool introduced with the release of Excel 2010. For instance, you might rethink how your data is put together and, perhaps, move the contents of columns E and J to another worksheet or even to another workbook. There are non-traditional ways you can use, as well. If they don't, then the next time the workbook is open, the worksheet remains unprotected and anyone can change the contents of columns E and J.Īs I said, the above represents the traditional way to approach the problem. If someone does make changes in this way, they will need to reapply the protection (steps 12 through 17) prior to saving the workbook. If someone knows the password you used in step 15, however, they can unprotect the worksheet (the proper control is on the Review tab of the ribbon) and make any changes they want. The result of going through all these steps is that the cells in columns E and J cannot be changed. Enter the password you used in step 15 a second time.Use the check boxes to fine tune how you want protection applied.
Make sure the top check box (Protect Worksheet and Contents of Locked Cells) is selected.Select column J and repeat steps 7 through 10.This protects the cells that are currently selected. Make sure the Locked check box is selected.Again make sure the Protection tab is displayed.Excel again displays the Format Cells dialog box. Click OK to close the Format Cells dialog box.(You may need to click it a few times to get it actually cleared.) This removes protection from all the cells in the worksheet. Make sure the Locked check box is cleared.The Protection tab of the Format Cells dialog box. Excel displays the Format Cells dialog box. Select all the cells in your worksheet.The traditional way to approach this challenge is to follow these steps: The workbook has only a single worksheet, and she needs to protect columns E and J so they cannot be changed, unless the user knows a particular password. Mary Lou wonders if there is a way she can password protect certain columns in a shared workbook.
0 kommentar(er)
