Excel drop down list not wide enough
Ngày đăng:
12/12/2021
Trả lời:
0
Lượt xem:
139
D Depley
I have made drop down boxes for several columns in a workbook. The problem is that the drop down box is too wide. For example, for a simple "Yes,No" selection the drop down box is +/- 7 inches wide. Can I size the driop down box to simply be the width of the column it is referring to? I have looked everywhere, and in the process learned many things but have not found an answer to my delemma. Any help would be greatly appreciated. Reply R Roger Govier
Hi How did you create the dropdowns, with Data Validation or Combobox? If ComboBox, then you can adjust the width of that when in Design mode. If Data Validation, then take a look at Debra Dalgleish's site. She has code there for making the box wider, but just change the values to get the size of columns you wish. http://www.contextures.com/xlDataVal08.html#Wider Reply D Depley
Reply D Debra Dalgleish
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. There's a bit more information here: http://www.contextures.com/xlDataValWidth.html Reply D Depley
Reply |