Friday, March 26, 2010

How to add validation rule

1. Click on the cell you wish to add the validation rule to

2. Click on the Data tab

3. Click on the Data Validation button  in the Data Tools group.

The Data Validation dialog box will open

4. And after that you can either put a validation rule for example whole numbers,integers etc.  

No comments: