Blog

Data Validation rules enable you, as the owner of the workbook, to set rules on what entries are allowed inside individual cells.

For instance, you can set one Validation Rule that only allows whole numbers between 1 and 100 to be entered into a cell. And, on another cell in the same workbook, you can specify that only entries from a drop-down list that you’ve created can be entered into a cell.

The possibilities are almost endless.

Setting Data Validation Rules
1. Select the cells on which you want to enable Data Validation
2. Click the Data Validation command in the Data Tools group on the Data tab
3. Choose Data Validation

4. On the Settings tab, choose the value type that you will allow
5. Click the Input Message tab

6. Enter the title and Message to help your user understand what is required for input

Subscribe to the Keystone OnDemand blog to be the first to learn about future Microsoft Office 2010 and SharePoint Training news and special subscriber offers.