Validating Number Entries in Excel 2007

 

To validate number entries:

1. Select a range of cells.
2. Select Data -> Data Validation (in Data Tools Group).
3. Select Settings -> Allow -> Whole number.
4. From Data dropdown list select Between.
5. In the Minimum box, enter the required lower limit, for example, 1000.
6. In the Maximum box, enter the required upper limit, for example, 9999.
7. Click OK.
Screenshot // Validating Number Entries in Excel 2007
Validating Number Entries in Excel 2007



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>