| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
Is there a way to edit and remove something from a drop down list?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list
hi,
yes. what kind of drop down lists. data validation, sheet combo box, form combo box, other....... if data validation, on the menu bar.... datavalidation... on the setting tab, at the bottom should list a range address where the source data is at. edit the source data. post back if that don't work. Regards FSt1 "Cheri" wrote: Is there a way to edit and remove something from a drop down list? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list
There is no range address where the source data is at. It's a list that was
created automatically from data I've entered into a certain column. "FSt1" wrote: hi, yes. what kind of drop down lists. data validation, sheet combo box, form combo box, other....... if data validation, on the menu bar.... datavalidation... on the setting tab, at the bottom should list a range address where the source data is at. edit the source data. post back if that don't work. Regards FSt1 "Cheri" wrote: Is there a way to edit and remove something from a drop down list? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list
hi
then edit that column because that should be the source. regards FSt1 "Cheri" wrote: There is no range address where the source data is at. It's a list that was created automatically from data I've entered into a certain column. "FSt1" wrote: hi, yes. what kind of drop down lists. data validation, sheet combo box, form combo box, other....... if data validation, on the menu bar.... datavalidation... on the setting tab, at the bottom should list a range address where the source data is at. edit the source data. post back if that don't work. Regards FSt1 "Cheri" wrote: Is there a way to edit and remove something from a drop down list? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list
Try to edit the list in the column you created.
-- Richard "Cheri" wrote: Is there a way to edit and remove something from a drop down list? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| 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) | |||
Linear Mode
