plantmop.blogg.se

Create a drop down menu in excel 2016 how to#

When you add them before the first cell or after the last cell, those items will not appear in the drop-down list. If you also need to show the new items in the drop-down list, you can insert cells within the range and then input the items into those new cells. When the source changes, the drop-down list will also change. Sometimes, you need to add items into the source range.Therefore, you need to pay attention if you will delete the source range. If you directly delete the cell range or the defined name in the workbook, the small arrow for the drop-down list will be invalid.And there are several different conditions. When you need to change the source range, the drop-down list will also be affected. Now you have also created a drop-down list for the cell. Next, input the name into the text box of “Source”.And then repeat the first 5 steps in the previous part.If the range is in another worksheet, make sure that the scope is “Workbook” or the worksheet where you need to create the drop-down list.In the “New Name” window, input a designated name into the first text box.After that, click the option “Define Name” in the new menu.Select the range in the target worksheet.And before you use the name, you should create one in this workbook.

Instead of refer to a cell range in the workbook, you can also input a defined name into the “Source” text box. Therefore, the drop-down list has been created.

After that, click the button “OK” in the “Data Validation” window.

On the other have, if the range is in another worksheet, you can also click the tab of that worksheet and then select the list. If the list is in the same worksheet, you can now directly select this range.

In this step, you need to input the range reference into the text box.

After that, choose “List” in the “Allow” text box.

Next click the button “Data Validation” in the toolbar.

And then click the tab “Data” in the ribbon.

Click the target cell where you need to create a drop-down list.

And the cell range should be in one column or in one row. If the options are in a range in the current workbook, you can also use the cell range in the source. And below we will talk about the usage in detail. Except for inputting the options into the “Source” text box directly, you can also refer to a range in Excel worksheet.

You can also refer to our previous article How to Create Multiple Choice Questions in an Excel Form to learn about the method. Many of you have already known how to create a drop-down list in Excel cells. Here we will talk about the details of the drop-down list. Sometimes, you may want to create a drop-down list from a range of cells instead of inputting the values manually.

Create a drop down menu in excel 2016 how to#