If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.
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
7)Name a range
8)Check the list of Names
Add Data Validation Drop-Down List To Cell List on Worksheet or Different Workshee
Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.