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

(35% Sale Ends Jan. 26)

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 (35% Discount)

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

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 (35% Discount)