Data Validation: Summary

You can Autofill the Data Validation--including the Input Message and Error Alert--to the rest of the cells in Column A.

 

8. Try it: Autofill the Data Validation

Select Cell A2. 
Use the Autofill handle to copy and paste the Data Validation from A2:A12

 

Do This, Too: Save Your Work

Go to File->Save.

File Name: Your Name Time Sheet

 

 

You done good.

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: Data Validation

Data ->Data Tools-> Data Validation