» Validating Number Entries in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft 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.
Book Store:
Recommended Books:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Guide to Understanding Financial Statements
- Microsoft Windows XP Step by Step (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Excel 2002 Power Programming with VBA
No comments have been submitted.
