| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
drop down lists
i followed steps & created drop down lists in cells by creating lists in same
worksheet. all was fine but then they all disappeared but the drop down arrow is still there? do i have to keep the lists in the worksheet that i used to create the drop downs?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
drop down lists
Hi,
You certainly need to keep the list somewhere, though they can be on a different sheet, if you used a defined name to reference them. Dave "sarah - woolbro" wrote: i followed steps & created drop down lists in cells by creating lists in same worksheet. all was fine but then they all disappeared but the drop down arrow is still there? do i have to keep the lists in the worksheet that i used to create the drop downs?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down list predicated on other drop down lists | Excel Worksheet Functions | |||
| 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 Lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Linear Mode
