» Validating Text Entries
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:
=IsText (A1)
where A1 is the first cell in the range.
6. Click OK.
Book Store:
Recommended Books:
- Word 2002: The Complete Reference
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- PowerPoint® 2002 For Dummies®
- Microsoft Excel VBA Programming for the Absolute Beginner
No comments have been submitted.
