Create SMART Drop Down Lists in Excel (with Data Validation)

Create SMART Drop Down Lists in Excel (with Data Validation)

 

 

Quickly learn how to make a drop down list in Excel or add other data validation checks. By the end of the this tutorial you will learn: 

1. How to create dynamic drop-down lists that grow as new categories are added 
2. How to restrict cell input to dates that fall between two values or dates that are greater than today's date 
3. How to restrict cell input to values that have specific length (or are greater or less than set total characters) 
4. How to restrict numbers input to fall between predefined values 
5. How to copy and paste data validation to other cells.

Related Topics:

• Excel: Find Multiple Matches and Dependent Drop Down List (Unsorted Tabular Data Set) 
• Excel: Extract unique items for dynamic data validation drop down list 
• Excel Dependent Drop Down List with Tabular Data without Named Ranges 
• Realistic Case : Dependent Drop-Down Lists in Excel with Multiple Words and Spaces in 1st List