Excel Forum
Similar Content
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...
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...
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 ...



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.