» 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:
Validation Input Message Placement
Stephen Haynes Posted on: 31-12-1969
Is there any way to pre-place the input message so that it doesn't cover up other text on my sheet?allow only specific entires
RAKESH Posted on: 31-12-1969
how can i restrict cell entires to a few specific characters
eg "A" ,"B" ,"C"
data validation in MS Excel
Guruprasad Posted on: 31-12-1969
i want to have the data in the in the range of cells without duplication of previously entered data(number),
kindly help me to solve this problem
data validation
Aaron Joshua Tiu Posted on: 31-12-1969
How do i restrict the entry of numbers and certain characters on a cell? is it possible? i want to input letters and letters only, nothing else... Thanks Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
