#Create a drop down list in excel how to#

We are currently focusing on a simple drop down list of names. Note: There are different types of data validation that can be done in Excel. In the following window, choose List for the вЂAllow:вЂ™ Step 4.2 вЂ“ Choose Allow List Step 4.1 вЂ“ Data Validation set up for a single cell Then select Data Validation from the Data ribbon. LetвЂ™s select the cell where we want to apply data validation or drop down list. We will implement first in a single cell. Step 3.3 вЂ“ Edit the Name Step 4: Implement Data validation For example, L_EMP as this is a list of Employee Names. I usually provide all my lists names that start with L.

In the next window that opens, specify the name we want to give. In the following window, click on New, as we are creating a new Name. Or select from the Formulas ribbon as shown below. Select the list of values and then press Ctrl+F3 to open Name Manager. Once you hit OK, you will see that the table is created. Please make sure that you check the box вЂMy Table has headersвЂ™. Select all four cells with data and press Ctrl+T Step 2 вЂ“ Convert to table Then, we have entered names of three employees. Step 1 вЂ“ Enter list of valuesДЇirst value (Employee Name) refers to the header or field name. In a blank new sheet, letвЂ™s type the following information.

#Create a drop down list in excel how to#

How to build a drop down list? Step 1: Enter list of values Now, we know what a drop down list is, letвЂ™s see how we can build this. If the user enters a value not in the list, it will not allow.В If the user enters an invalid value, there will be an error message. User can choose Mike from the list instead of typing the value. John, Mike and Kate are the allowed values When click on the downward arrow button, we see John, Mike, and Kate. In the image above, you can see the message for the user instructing what data is expected in that cell.

Optionally, you can provide an error message when the user does not enter a valid value.

It limits what values can be entered in a cell.

It allows the user to choose from a list instead of typing the value.

It informs the user what values are allowed.

Optionally, you can provide message to guide the user on data entry.

What are drop down lists?ДЄ drop down list is a way to implement data validation and improve data entry in Excel. If you would like to be notified of these videos, please subscribe to our YouTube channel. Video (How to create drop down list in Excel) In this tutorial, we are going to see how we can create a simple drop down list in Excel. Modified on: Tue, 9 Jun, 2020 at 12:07 PM Solution home Excel Features How to How to create a drop down list in Excel?