DropDown Menues for Cells

[Chaz]

Is it possible to have a drop down menu in an excel
spreadsheet.

What I am doing is listing products on a spreadsheet, but
the color column, I want to pick from a list of colors,
rather than type each color each time. I need the same
type of functionality that you would see on a web page
asking for what state you live in, where you can choose
from all 50 states.

Any suggestions?

Thanks

Chaz

 

[Chaz]

Just figured it out. Thanks anyway........

Chaz

 

[Gord Dibben]

Chaz

Data>Validation>Allow"List"

Either type in the list of colors with a comma between each or point to a list
range on the sheet.

If list range is on another sheet, you must name the range then refer to the
named range.

For full instructions and pictures see Debra Dalgleish's site.

http://www.contextures.on.ca/xlDataVal01.html

Gord Dibben Excel MVP