» 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:
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Business Plans For Dummies®
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Microsoft Office XP Introductory Concepts and Techniques
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Microsoft Windows XP Step by Step (With CD-ROM)
No comments have been submitted.
