Dropdown Menus

[PJ]

Will you please explain how to insert a drop-down menu
into a worksheet?

 

[Ken Wright]

Data validation. Step by step instructions:-

http://www.contextures.com/xlDataVal01.html

 

[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