Limit valid input to a cell

B

bruster

Is there a way to limit the valid entries to a cell? For example, I want a
cell to get a "Y" for Yes and an "N" for no, but I don't want the person
filling in the form to enter any other values. Also, I prefer not to use a
dropdown box. Anybody?
 
J

JulieD

Hi bruster

use Data / Validation - choose 'list' if you don't want the drop down arrow,
untick "in cell drop down"
Debra Dalgleish has extensive information on data validation on her site at
www.contextures.com

Cheers
JulieD
 
T

tjtjjtjt

Use Data Validation.
Switch the Allow to List
For the Source type: Y,N

If you don't want the Drop-down, uncheck the option for in cell drop-downon
the right side of the dialog box.

You may also want to set an Error Message--just click on the Tab by that name.

Note: People can copy and paste over the top of Data Validation, so it isn't
foolproof, but it should keep most entries in line.

tj
 
Top