98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Validating text entries

Validating 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.

Added by Rich on 28th June 2006

More Excel hints and tips, like:

• Recovering Unsaved Work in Excel 2010
• Missing Field handle
• Wrapping Text in a Cell in an Excel 2010 Workbook