| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need an option list for a table...
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an option list for a table...
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an option list for a table...
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an option list for a table...
Do we have a problem in leaving it blank..
If this post helps click Yes --------------- Jacob Skaria "Derrick" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an option list for a table...
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! "Jacob Skaria" wrote: Do we have a problem in leaving it blank.. If this post helps click Yes --------------- Jacob Skaria "Derrick" wrote: 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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an option list for a table...
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| Pivot table summary option--display list of values | Excel Worksheet Functions | |||
| I do not have the List-create a list option on my data toolbar ?? | New Users to Excel | |||
| how do i define a range as a list when there is no list option in. | Excel Worksheet Functions | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
Linear Mode
