How to Create Drop Down Lists in Microsoft Excel

Taylor Karl
How to Create Drop Down Lists in Microsoft Excel 2200 0

We are back with another "How To" blog for those of you looking for some quick and easy tips for Microsoft Excel. Let's jump in and learn how to create a drop down selection list!


First, you will want to select the cell that will house the drop-down selection list:

Example shown below:

Next, you will journey over to the Data Tab: This tab is located in between the "Formulas" and "Review" Tabs at the top of the Excel sheet.

Select Data Validation in the Data Tools Section: This section can be found in between "Sort & Filter" and "Forecast" Sections.

Once you click Data Validation, a pop-up box will appear: Example shown below

In the Allow Drop Down you will select "Lists": Example shown in the picture below

Click in the Source box and then proceed to type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list and then click OK: You can also click your mouse on the cells and drag your mouse if you want multiple selections as shown below.

Now your drop-down lists have been placed in the cells you selected:



There you have it! Your drop-down selections are now in the cell or column you prefer.

For more Excel tips head to our Blog or you can venture to our Webinar Page to see what amazing events we have slated for the future!

Top 20 Office Tips eBook

Submit your email below to download our free 49-page eBook, Top 20 Office Productivity Tips