You can use DataValidation. There are some instructions he

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

Susan wrote:
I notice a friends excel document that contain a drop
down box for selection in every cell, I know how to to go
to the control toolbox and add a combo box, but it never
fits the cells.
What are the steps for me to create that in a row of cells

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html