Another way is to select your range to get the validation. Then set it all at
once.

If you use a formula, excel will adjust it just like it does when you copy a
formula down a column.

Susan wrote:

Thank you, that was exactly what I was looking for, one
more question, is it possible to copy the validation from
one cell to another without having to repeat the steps?
Thanks
Susan
-----Original Message-----
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

.


--

Dave Peterson