Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"Derrick" wrote in message
...
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!