1-866-245-5224 sales@keystonelearning.com

Excel 2007: Working with Data Validation Rules

Excel 2007: Working with Data Validation Rules

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.  
  3. Click the Data Validation command in the Data Tools group on the Data tab
     
  4.  
  5.  Choose Data Validation…
     

Figure 35. Data Validation Dialog Box - Settings Tab

    4.       On the Settings tab, choose the value type that you will allow

    5.       Click the Input Message tab

 

Figure 36. Data Validation Dialog Box - Input Message Tab

 

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

    7.       Click the Error Alert tab

 

Figure 37. Data Validation Dialog Box - Error Alert tab

 

8.       Set your error message Style, Title and Message

9.       Click OK

Remove Data Validation Rules

Once Data Validation is set, it’s actually very easy to remove.

     
  1. Select the cells on which you want to disable Data Validation
     
  2.  
  3. Click the Data Validation command in the Data Tools group on the Data tab
     
  4.  
  5. Choose Data Validation…
     
  6.  
  7. Click Clear All
     
  8.  
  9. Click OK