Excel List Box

[Armando]

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

 

[Debra Dalgleish]

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.