Drop Down in every cell - up to 250 rows

D

dipsy

I want to create multiple drop-down choice columns and in
every row I want to provide the same drop-down for
different columns.

I am creating a template and I want to limit the choices
but I want to allow people to enter as many lines of
information as they want.

For example:
Column 1 - Name
Column 2 - Drop Down - Project Type
Column 3 - Drop Down - Project Start Date
Column 4 - Drop Down - Project End Date

What is the best way to do this?

Thanks in advance for the assistance.
 
C

cwilson

You can create your lists in a hidden area on the sheet. One for each
column. Then you can select the first column and select data, validation.
Select allow: List and choose your first list. Do this for each column.

Chris
 
D

dipsy

Thanks - it worked.
-----Original Message-----
You can create your lists in a hidden area on the sheet. One for each
column. Then you can select the first column and select data, validation.
Select allow: List and choose your first list. Do this for each column.

Chris


.
Click to expand...
 
Top