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" wrote:

Select Column A
From menu DataValidationSelect List and enter (comma seperated)
corner,typical

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

If this post helps click Yes
---------------
Jacob Skaria


"Derrick" wrote:

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!