Learn how to make drop down list (and much more ) with Data Validation in Excel!!

Data validation is a fantastic tool for when you need to put some rules around what people are entering in your spreadsheet.
The most popular feature is the in cell drop down list.
But that's not all!!!!!

Data validation can enforce number limits (and age field can't be over 120 ), force date entry, limit text length, etc. )

You can also use data validation to display help when a user enters a cell.

and last but not least,
it's just a really fun feature to play with!

#Exceltips #Excel #Data #personaldevelopment