Make Quick Lists for Drop Down Menus - Save A LOT of Time

Add to Favorites
Author: | Edits: don

Quickly make data validation drop down lists (menus) in Excel.

This method is simple, only a few steps, and easy to implement for any set of data that you have.

You will learn to make a list from any set of data and then display it inside of a drop down menu list using data validation.

Additional Resources

Create a Drop Down List in Excel (msft)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.