Create a drop-down list in Excel in 3 minutes!

A new version of this article has been published here:

I don’t think that more than 10 % of all Excel users know how to create a drop-down menu. But it’s really easy and it looks impressive!

1. Create a list of the items that you want to appear in the drop-down menu.

2. Name the list.

Select the range and press Ctrl+Shift+F3 to open the name manager. If the list has a headline (it should!), choose Top row.

3. Create the drop-down menu.

Now you can create a drop-down menu anywhere you want in the workbook. Select a cell and press Alt+D+L (press down the Alt key and keep it down. Press the D key, release it and press the L key) to open the Data Validation window. Choose List in the first field.

In the source field, simply press F3 to retrieve your list names and choose the one you want for this drop-down.


Note: If you want to create many drop-down menus in one workbook, it might be a good idea to have all the lists in one tab.

Here’s a video I made that shows you how easy it is (in Norwegian):


5 thoughts on “Create a drop-down list in Excel in 3 minutes!

  1. Pingback: Sum and conditional sum in Excel « Excel is easy!

  2. Pingback: Create a dynamic drop-down in Excel in 5 minutes! « Excel is easy!

  3. Pingback: Yellow pop-up box when selecting cell in Excel « Excel is easy!

  4. Pingback: Quora

  5. Pingback: Highlight Entire Row In Excel Based On One Cell « Excel is easy!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s