On the Excel Ribbon, click the Review tab.Go to the worksheet that you’re going to protect.The next time you press Ctrl+1, the Custom Lists heading is on the Format Cells dialog box. It seems to appear if you open the Format Cells dialog box, go to the Protection tab, and then close the dialog box. Note: In the screenshot above, you can see that the dialog box name shows as “Custom Lists”, even though it’s the Format Cells dialog box. On the Protection tab, remove the check mark from Locked.On the keyboard, press Ctrl + 1 to open the Format Cells dialog box.On the worksheet that you’re going to protect, select the cells that users will be able to change - cells A2:C6 in this example.To allow changes to some cells, you have to change the protection setting for those cells. The rest of the cells should be protected, so the formulas cannot be changed or deleted.īy default, all the cells on the worksheet will be locked, if you protect the worksheet. In the screenshot below, the selected cells - A2:C6 - should be unprotected, so users can enter data. However, you want the users to be able to enter the date, item name and quantity for an order.
You can follow this tutorial to learn how to do that, and maybe you’ll even see the weird dialog box heading that I show below.įor example, on a data entry sheet, you might have some cells with formulas, that you don’t want users to mess up. Follow the above steps carefully and you should have no problem.It’s easy to protect a worksheet in Excel, but it’s not so obvious how you leave some of the cells unprotected, to allow changes on a protected worksheet. On the Home tab, in the Editing group, click the arrow next to the Clear button, and then do one of the following: To clear all contents, formats, and comments that are contained in the selected cells, click Clear All. You can also give some users access with or without a password. Select all the cells you need (Press Ctrl + A to select all the cells). You can either protect or unprotect cells in an Excel sheet at once, or select a specific range. Knowing how to protect your page is very essential to protect it from accidental changes. These were all the different ways you can lock or unlock cells in Excel. Now select the permission for each user under “Group or user names” And select the Allow option.
You can type the person's username as it is stored in your domain. Enter the usernames in the box Enter the names of the objects to be selected. When creating the domain, click on the “Option” Permissions" Or not.Ģ.
You can also grant access to domains without having to enter a password each time:ġ. Now, even though your sheet is protected, some of the protected cells will have an extra level of protection and will only be unlocked with a password. Type the password again in the window confirmation, and it's over your work. Type a password in a window “Paper Protection” for the entire sheet and choose the actions you want to allow. You can follow the steps again to create more domains.ĩ. Type the password again in the “dialog box” confirm password" and click “ Agree".Ĩ. Write Password in the password field and tap Agree.ħ. It already has the range of cells selected by default.Ħ. In the Refers to cell field, type the range of cells. In the address field, enter a name for your group. A dialog appears “new domain” With the address field, refers to the cells, the password field is the range.ĥ. You need to unlock the sheet first to access the option.ģ. In the tab “ audit”, click the option “Allow users to modify domains”. Select cells or ranges that you want to open in a password-protected sheet.Ģ. With this method, you can unlock individual cells on your sheet with a password:ġ. Sometimes you may want to modify specific cells in a protected Excel sheet. How to open specific cells in a protected sheet? in the tab “ ProtectionIn the Format Cells dialog, deselect the option Closedand click Agree". Then press Ctrl + 1 or right click and choose Format Cells. Select all cells in the sheet by Ctrl + A. You can also unlock the sheet using the Format Cells dialog.Ĥ.