| 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! |
| 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 | |||
![myBasic[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
