Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default i need an option list

This can get pretty complicated. I suggest this link...

http://office.microsoft.com/en-us/ex...726001033.aspx


"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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to remove list option VIVEKMANE Excel Discussion (Misc queries) 2 October 23rd 07 12:41 PM
I do not have the List-create a list option on my data toolbar ?? Ruthlife New Users to Excel 2 September 6th 06 02:10 PM
How do I use the custom list option? Slabtamer New Users to Excel 2 May 31st 05 03:02 AM
how do i define a range as a list when there is no list option in. Domespacio Excel Worksheet Functions 2 May 25th 05 11:36 AM
Does Excel 2002 have a List>Create List option under Data? Jesse Excel Discussion (Misc queries) 3 May 20th 05 01:52 PM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"