Excel: Overtime Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

Data -> Data Tools -> Data Validation

Validation Settings

Data Validation has several interesting format options. Go back to Sheet 1 and select cell A2 to begin.

 

Go to the Data Ribbon and look in the Data Tools for Data Validation.

 

 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 1. Creating and Manipulating Data

  1.2.1. Restrict data using data validation: Restrict the type of data that can be entered in cells