Filter		Advanced Filter		Pivot Table		Group and Outline		Data Validation		Name Manager
Goal Seek		Freeze Panes		Split Screen		Conditional Formatting		Text to Columns

Data validation is a extremely useful feature in Data collection templates.
It helps validate the Data entered and prevents invalid data update to excel cells


We can also provide Input Error message or Alert message
(1) Input Message
(2) Error Alert
(3) Error Alert could be of three types - Stop , Warning , Information

In Data validation , you can also crate a category and Sub Category Tip : We can use Named Ranges to define a category and refer it using indirect function

Data validation feature may not work when the workbook is shared, password protected or linked in Share point

As an alternative, you can Over-ride a Data validation we can update Data through VBA Macros

  [Alt] + D + L