Dropdown Menus

  • Thread starter Thread starter PJ
  • Start date Start date
PJ,

I think you are looking for Data|Validation

Select the Allow List option and either type your list into the Source area
or reference a range of cells that contain the list. Note if the list is on
a different worksheet you need to name the range and reference the named
range.

PC
 

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

filter dropdown menu so 2nd drop menu is customized 1
Modifying Data in Drop Down Menu 2
excel dropdown question 4
Nesting drop-down menus 1
How do I copy worksheets with drop-down menus intact? 4
Date Range Drop Down Menu 1
Auto fill Cells with text 2
Protect Drop-down list from range of cells 3

Back
Top