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


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course