| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down menu
How do you edit a drop down menu's location?
-- Thanks, George |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
"George" wrote:
How do you edit a drop down menu's location? One guess as to the root Q here. Use named ranges as DV sources for better flexibility. Then you can set the DV up easily to work across sheets as well. Any joy? hit YES below -- Max Singapore --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
Location of the dropdown or location of the list range for the dropdown?
Cut and paste should get you the first. In DVListSource dialog you should be able to change the list range. Gord Dibben MS Excel MVP On Sat, 20 Feb 2010 14:05:01 -0800, George wrote: How do you edit a drop down menu's location? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down choice needs to lead to another drop down menu | Excel Discussion (Misc queries) | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
| Drop Down Menu Help | Excel Discussion (Misc queries) | |||
Linear Mode
