Hello,

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?

Thank you

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