» 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:
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Outlook 2002 for Dummies
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Microsoft Windows XP Inside Out
No comments have been submitted.
