Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Select the cell, then select Data Validation. Set up the List-based
validation, then go to the Error Alert tab. Uncheck the box marked 'Show error alert after invalid data is entered' OK. Hope this helps, Hutch "Vera" wrote: Hi, I'm working with Excel 2003 and I need a cell to have a dropdown list to choose from and allow people to type something different. When I use the data validation tool, it will only allow what's in my list. Any other method to get a dropdown list and allow a different entry? Thanks for all your hard work! Vera |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
applying dropdown list entry to multple cells | New Users to Excel | |||
LIST ENTRY ENABLE DROP DOWN LIST TO ACCEPT MORE THAN 1 ENTRY | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) |