I need an option list for a table...

[Derrick]

sounds simple? i hope so
i want to be able to make a large table, where certain columns are only
allowed to be certain imputs.
ie: a system type column, where the options are open, closed, or 2-piece
and a zone column, where the options are corner or typical.
so, it will effectivly look like this:
a b
1 Select Zone Select system

2 corner open
3 typical closed
4 corner 2-piece
5 corner closed
6 typical 2 piece
: : :

Thanks for helpin!

 

[Jacob Skaria]

Select Column A
From menu Data>Validation>Select List and enter (comma seperated)
corner,typical

Select Column B
From menu Data>Validation>Select List and enter (comma seperated)
open, closed,2-piece

If this post helps click Yes

 

[Derrick]

thanks. what if i want them to remain blank?
so for un-used rows there's nothing in them?
like so:
1 Select Zone Select system

2 corner open
3 typical closed
4 corner 2-piece
5
6
: : :

 

[Jacob Skaria]

Do we have a problem in leaving it blank..

If this post helps click Yes

 

[Derrick]

lol i just pressed delete and it was fine.
i was trying to backspace the entry, and it was giving me the 'not
acceptable value' schpeel. so ya we're good if we just hit the delete key.
thanks!

 

[T. Valko]

Watch this 5 min video:

How to setup a data validation drop down list: