Mẹo Hướng dẫn Excel drop down list not wide enough 2022
Pro đang tìm kiếm từ khóa Excel drop down list not wide enough được Update vào lúc : 2022-12-12 13:28:09 . Với phương châm chia sẻ Mẹo về trong nội dung bài viết một cách Chi Tiết 2022. Nếu sau khi Read Post vẫn ko hiểu thì hoàn toàn có thể lại Comments ở cuối bài để Tác giả lý giải và hướng dẫn lại nha.
DDepley
- Sep 5, 2008
- #1
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.ReplyRRoger Govier
- Sep 5, 2008
- #2
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 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#WiderReplyDDepley
- Sep 5, 2008
- #3
Roger Govier said: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 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
—
Regards
Roger Govier
The drop downs were created with Data Validation. I have four columns with drop down boxes that all have the same problem, i.e., the drop down box is +/- 7 inches wide and the column may be 1″ wide. I have done many spreadsheets with drop down boxes but have never had this problem. I am using OfficePro 2003. If I use your solution I assume I would have to insert this code for each column?Click to expand…ReplyDDebra Dalgleish
- Sep 6, 2008
- #4
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.htmlReplyDDepley
- Sep 6, 2008
- #5
Debra Dalgleish said: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
—
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com
Thank all who responded. There were two merged cells but unmerging them did not work. Deleting the drop down validations and then reinserting new validation drop down boxes did not work. Nothing worked but Debra’s response got me thinking, I inserted another worksheet, deleted all validations from the columns, copied the entire worksheet and pasted to the new worksheet, and then added back my validation drop down lists. All in the world is good again!!!!! Thank you.Click to expand…Reply
Reply
3
0
Chia sẻ
Chia Sẻ Link Down Excel drop down list not wide enough miễn phí
Bạn vừa tìm hiểu thêm nội dung bài viết Với Một số hướng dẫn một cách rõ ràng hơn về Clip Excel drop down list not wide enough tiên tiến và phát triển nhất và Share Link Down Excel drop down list not wide enough Free.
Thảo Luận vướng mắc về Excel drop down list not wide enough
Nếu sau khi đọc nội dung bài viết Excel drop down list not wide enough vẫn chưa hiểu thì hoàn toàn có thể lại Comments ở cuối bài để Tác giả lý giải và hướng dẫn lại nha
#Excel #drop #list #wide