Hard coding column formats

  • Thread starter Thread starter Chris
  • Start date Start date
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
 
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
 
Back
Top