Excel List Box
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 |
All times are GMT +1. The time now is 11:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com