» Validating Text 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 -> Custom.
4. In the Formula box, enter the following formula:
=IsText (A1)
where A1 is the first cell in the range.
5. Click OK.
Book Store:
Recommended Books:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Harry Potter and the Order of the Phoenix (Book 5)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Accounting Principles, with CD, 6th Edition
- Financial Risk Manager Handbook, Second Edition
- Financial Statement Analysis with S&P insert card
No comments have been submitted.
