| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List data
Can I have a drop down list that, I can either choose from or input something
different? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
List data
Yes.
Watch this 5 min video: How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM That'll show how to setup the list for selecting items. To be able to *enter* items not on the list, after you have the basic list set select the Error Alert tab and uncheck: Show error alert after invalid data is entered. Then OK. -- Biff Microsoft Excel MVP "Big Rob" wrote in message ... Can I have a drop down list that, I can either choose from or input something different? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
| data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
| How to view a list of data based on another list of data | Excel Discussion (Misc queries) | |||
| converting vertical data list to horizontal data list | Excel Worksheet Functions | |||
| Does Excel 2002 have a List>Create List option under Data? | Excel Discussion (Misc queries) | |||
![Big Rob[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
