Take a look at Data/Validation in XL Help (the "About setting
restrictions on cells and displaying input and error messages" topic,
specifically using lists).

See http://www.contextures.com/xlDataVal01.html for more


In article ,
TheRulie wrote:

I'm trying to create a drop down list box in my excel sheet that is populated
by a list of values. For each cell in the column I want this drop down to
appear.

It's effectively a pick list ..

Any ideas on how to do this?

Thanks