I'm not sure what you're trying to do. Perhaps you could use data
validation in one cell, then VLOOKUP formulas to return the matching
values in the adjacent cells.

Armando wrote:
I am would like to make a drop down list to selects different option of
tested that we normally use in excel, however in order for the text to look
right it must merge with several cells. I tried the data validation however
it does not allow merged cells.
How can I accomplish this?

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