Hard coding column formats

C

Chris

I have a column that I want to code so that the cells can
be filled in with certain answers only (there are five to
choose from). Is there a way to do this without using
drop down menus? Reason being: each cell in the column
can be input with one of five answers, but there maybe 25
cells (consective) that could be filled in (autofill?) at
the same file. Example:
Column A Column B
Status Comments
----------------------------------
Valid Answer C
Valid " "
Expired B
Valid
Valid
Valid
Expired
Expired
Expired
 
O

Otto Moehrbach

I gather that the problem you are asking help on is that you have to setup
Data Validation in each of 25 or so cells. Just select all 25 cells and
setup Data Validation just once. It will go into all 25 cells. HTH Otto
 
Top