 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2005Help with drop-down list (2003)
Is there any way to control how the dropdown list is displayed? Specifically, I have a data validation list in a cell. The column it is in is only 4 units wide, with the text aligned at 90 degrees (vertically). The dropdown list displayed is also only 4 units wide, and does not show enough characters of each list item. I've seen other spreadsheets where the dropdown list is wider than the column, but it seems to be somewhat random... Is there any way to increase the size (or other properties) of the dropdown list (apart from increasing the column width)?  Signatureseantera You can't control the data validation list width -- it's controlled by the column width. You can use code to make the column temporarily wider. There's sample code here: http://www.contextures.com/xlDataVal08.html#Wider > Is there any way to control how the dropdown list is displayed? > Specifically, I have a data validation list in a cell. The column it is [quoted text clipped - 6 lines] > Is there any way to increase the size (or other properties) of the > dropdown list (apart from increasing the column width)? SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html thank you for responding, the problem is on one of the sheets the dro down is bigger than the cell and after I copy the sheet and use th drop down box a couple of times it shrinks up Extra wide dropdown lists appear occasionally, usually if cells on the worksheet have been merged (not necessarily the cell with the data validation). To get rid of them, you may have to delete the row or column and recreate the data validation. > thank you for responding, the problem is on one of the sheets the drop > down is bigger than the cell and after I copy the sheet and use the > drop down box a couple of times it shrinks up! SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.