Excel Forum
Similar Content
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Make a Drop Down List Menu in a Cell in Excel
Tutorial: I'll show you how to make a drop down list menu in a cell in Excel. This allows you to ha...
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 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet


See how to:
1)Add drop down by typing values in
2)Add drop down by selecting range on worksheet
3)Add drop down by naming range on different worksheet
4)Add a warning message
5)Check to see if data is valid
6)VLOOKUP function
7)Name a range
8)Check the list of Names
Add Data Validation Drop-Down List To Cell List on Worksheet or Different Worksheet





Got a Question? Ask it Here in the Forum.