» Validating Number Entries in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
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:
- How to Read A Financial Report
- Microsoft Windows XP Inside Out
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.
