Excel List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop down list 2
Sharing workbooks limitations - Merged Cells 12
Excel; tabbing through protected worksheet 2
Picture displayed when item selected in a different cell 2
data - validation - list question 2
How to delete a drop down box in Excel 2007 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Behavior of text in cells..... 1

Back
Top