» 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:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Financial Numbers Game: Detecting Creative Accounting Practices
- The 22 Immutable Laws of Branding
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
