Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop list in cell
Hi Everybody,
Would you tell me if there's any functions in Excel 2000 to make a drop list in a cell, for preventing users from any typing errors. Let's say they have to key in data in colume 'DEPARTMENT', so should confine them to 'Marketing','Porduction','Accounting','Administrat ion', etc. Thought that dropdown list to select items would be tbe better choice. Thanks & regards! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop list in cell
Hi
see: http://www.contextures.com/xlDataVal01.html -----Original Message----- Hi Everybody, Would you tell me if there's any functions in Excel 2000 to make a drop list in a cell, for preventing users from any typing errors. Let's say they have to key in data in colume 'DEPARTMENT', so should confine them to 'Marketing','Porduction','Accounting','Administrat ion', etc. Thought that dropdown list to select items would be tbe better choice. Thanks & regards! . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop list in cell
Hi Frank,
Thank you very much for your response. I found your examples works fine, but some problems, I know the example of looking up a whole row : =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1), right. -- But, how about looking up a whole column, just like: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$1:$1)) it failed!!! Kindly tells the fact. Thanks & regards! "Frank Kabel" wrote: Hi see: http://www.contextures.com/xlDataVal01.html -----Original Message----- Hi Everybody, Would you tell me if there's any functions in Excel 2000 to make a drop list in a cell, for preventing users from any typing errors. Let's say they have to key in data in colume 'DEPARTMENT', so should confine them to 'Marketing','Porduction','Accounting','Administrat ion', etc. Thought that dropdown list to select items would be tbe better choice. Thanks & regards! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
How do I set up drop-down list for a cell when the list is in ano. | Excel Discussion (Misc queries) | |||
Dynamically adding an in-cell drop-down list (i.e. Validation Object) to a cell? | Excel Programming |