Drop down list in excel how to#

Now using the Data Validation tool create the drop-down list. One way to name the range is, select the range of values and provide the name in the Name Box field. And make sure to check the My table has headers option. Select any of the table formats from the options. So, select the entire list and click Format as Table from the Home tab. To make the list automatically editable, first of all, we need to format the list as a table. If you want the list to be updated automatically, then this section will be helpful for you.

Drop down list in excel how to#

So far, we have seen how to edit the drop-down list manually after every change. Make Drop-Down List Automatically Editable Read More: How to Make a Drop Down List in Excel (Independent and Dependent) 4. Click OK and you will find the updated drop-down list. Using the Data Validation tool open the Data Validation dialogue box and add or delete the element from the Source field there. Let’s see through examples.įor the question, “Going to watch this weekend?” we have set Yes and No in the drop-down list.

How to Edit Cell with Single Click in Excel (3 Easy Methods).

Enable Editing in Excel Protected View (5 Methods).

How to Edit Footer in Excel (3 Quick Methods).

Edit a Line Graph in Excel (Including All Criteria).

How to Edit Pie Chart in Excel (All Possible Modifications).

Read More: How to Edit Named Range in Excel Now you will find only the Thriller genres. Here we have updated the range, now the range is B10:B14 (earlier it was B4:B14). You will find the Name Manager dialogue box. To modify the range, explore the Defined Names from the Formulas tab and click Name Manager. Now to edit the list, we need to modify the Genre range which we have created earlier. Now if we change the question like the earlier one (“Your Favourite Genre?” to “Your Favourite Thriller Genre?”) You will find all the genres inside the drop-down list. Notice that, here we have provided Genre range in the Source field. But this time we will use the Name Range in the Source field. Here we have set Genre as the name of the range. And click OK (don’t forget to check the range before clicking). Provide the name of the range in the Name field. Select the Define Name from there.Ī New Name dialogue box will be presented to you. Select the cells you want into the range, and then from the Formulas tab, you will find the Defined Names option. Before starting editing let’s create the list based on name range. We can edit the drop-down list based on the name range. Read More: How to Remove Drop-Down List in Excel 2. Now the drop-down list will only have the types of Thriller genres. So, we have changed the range to B10:B14. Here the types of Thriller genres were stored within B10 to B14.

Now at the Source field change the cell reference. To edit, click the Data Validation option in Data Tools from the Data tab. Since we only need to consider Thriller genres. Now the drop-down list which has all the genres as its options may seem a redundant one. The first question was “Your Favourite Genre?”, which we have modified to “Your Favourite Thriller Genre?” Edit Through Data Validation Featureįor our earlier set of questions, we have set the drop-down lists.

Read More: How to Edit Drop Down List in Excel Macro (4 Easy Methods) 1. We will find Yes and No in the drop-down options. Now, for the second answer, on that cell build a drop-down list inserting Yes and No at the Source field. Here we have found the genre list at the drop-down box. Here we have inserted the list using its cell reference ( B4:B14) in the source field. And the range of data at the Source field.

The Data Validation dialogue box will pop up. Select the answer cell for the first one and then from the Data tab select the Data Tools option, you will find the Data Validation tool there. We will create two drop-down lists for the two questions. The answers to these questions will be from drop-down lists. Here, for example, we have introduced a couple of questions. For a reminder here we are creating the list. Before editing, we need to create the list.