Excel Forum
Similar Content
Unique Drop Down Lists that Automatically Update with New Values
Tutorial: How to make a data validation drop down list that will always update with a unique list o...
Make Quick Lists for Drop Down Menus - Save A LOT of Time
Tutorial: Quickly make data validation drop down lists (menus) in Excel. This method is simple, onl...
Automatically Updating Dependent Drop Down List Menus in Excel
Tutorial: Step-by-step instruction on how to make automatically updating dependent data validation ...
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



Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down


See how to use Data Validation Drop-Down List to show a list of values in cells not just one value in one cell, but many values in many cells. See the IF, ROWS, INDIRECT functions in a formula and Data Validation Drop-Down List.





Got a Question? Ask it Here in the Forum.