» Validating Text Entries in Excel 2007
CATEGORY - Excel Editing
VERSION - Microsoft Excel 2007
To validate text entries: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:
- The 11 Immutable Laws of Internet Branding
- Financial Modeling - 2nd Edition
- Yes, You Can Time the Market!
- Microsoft Windows XP Inside Out
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- The Intelligent Investor: The Classic Bestseller on Value Investing
No comments have been submitted.
