Dropdown Menus

P

Paul Corrado

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
How to have conditional dropdown 1
Dependent Validation 1
Date Range Drop Down Menu 1

Top