» Validating Text Entries
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
To validate text entries: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:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Yes, You Can Time the Market!
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Definitive Guide to Excel VBA
- Mortgages For Dummies®
No comments have been submitted.
