Drop down menu

  • Thread starter Thread starter George
  • Start date Start date
George said:
How do you edit a drop down menu's location?
Click to expand...
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
 
Location of the dropdown or location of the list range for the dropdown?

Cut and paste should get you the first.

In DV>List>Source dialog you should be able to change the list range.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modifying Data in Drop Down Menu 2
Formatted cell column in drop down list 1
Drop Down Menu AutoPopulate Contact Info? 2
How do I change fonts in a DV drop down menu 1
DROP DOWN MENU "source" 5
Drop Down Menu Title 2
Dependent drop down dynamic range formula, off sheet. 7
Display invisible numbers in a drop down menu 1

Back
Top