Web go to the formulas tab and select “name manager” in the defined names section of the ribbon.

How to create locked drop down list in excel. And then, insert the vba code at the back end of the target worksheet. When the name manager opens, select the named range and update the cell references in the refers to box at the bottom. Web i want to protect a cell that i have a drop down list in, but i still want the drop down list to work.

Web list the items for the dependent list, and then select the cells. The first text you see when the cell is selected is just the input message. Web select the worksheet that you want to protect.

In the dialog, set allow to list. Web on the ribbon, click data > data validation. With the cells selected, go up to the name box on the left side of the formula bar and enter a name for the cell group.

This command is available only when the worksheet is not protected. When i try to protect it, the user is not able to use the drop down list to select other item. First, you make a regular data validation list in one or more cells.

Do one of the following: To add a new editable range, click new. Web in the data tools section of the data tab, click the “data validation” button.

You can manually adjust the cell references or simply drag through them on your sheet. On the review tab, in the changes group, click allow users to edit ranges.