How to Create a Drop-Down List in Excel in 3 Easy Steps

How to Create a Drop-Down List in Excel in 3 Easy Steps

If you’re new to Excel, you may find it hard to implement a drop-down list in Excel simply because there’s no one-click button for that.

In fact, some long-time users may still forget how to do it as the button involved isn’t that obvious.

In this article, I will show you how to easily create a drop-down list in three easy steps.

Step 1: Select a Cell

The first step is simple — select the cell that you want to turn into a drop-down list.

For example, let’s say we have this spreadsheet below and we want to turn cell C2 into a drop-down list.

All you have to do is click on it and proceed to the next step.

Select Cell for Dropdown

Step 2: Data Validation

The next step is to visit the Data tab. Simply click its name on the menu bar.

On the Data tab, find the button for Data Validation. You can find it on the Data Tools group, with the icon that has a check and a cancel icon.

Data Validation Button for Dropdown

Step 3: Create the Drop-Down

Once you have clicked on the button, a Data Validation window will appear where you can create the drop-down list.

To proceed, set the validation criteria by choosing List on the type of validation as you can see from the image below.

Allow List for Dropdown

After selecting List, the next step is specifying the source for the drop-down. Now, there are two ways to do this:

  1. You can enter directly the options for the list with each one separated by a comma.
  2. If you have the options somewhere on the spreadsheet, you can select those cells instead of entering them one by one on the form.

For this example, let’s assume that you don’t have any of the options anywhere on the spreadsheet. This means you must enter the options on the form as shown below.

Specify Sources for Dropdown

Once you press OK, you will immediately see the results.

Create the Drop-Down

That’s all you have to do to create a drop-down. Of course, you can do a lot more customizations like changing the input message and error alert. But these three steps are what you need to do to create a drop-down in Excel.

If you need any help or if you have any questions related to Excel, feel free to leave a comment below or send me a direct message via the contact page.

About Ryan

As the Principal Solutions Architect at Mr. SharePoint, I help companies of all sizes better leverage the Modern Workplace and Digital Process Automation investments.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Tweet
Share
Share
Pin