Excel ListBox overlap options

Mustang0710

New Member
Joined
Mar 4, 2015
Messages
16
In Excel, if the text in an column is longer than the width of the column and there is no text to the cell to the right, it will overlap into that cell on the display. Is there an option for a ListBox to work the same way. I am displaying an indented structure and intentionally want the column widths to only be about a quarter of inch wide, but the column text is much longer. Currently, it cuts off the text at the end of the column width. I would like it to overlap into the next column. Wrapping text doesn't look as nice and setting the column width to the width of text make it hard to see the overall structure because it scrolls to the right so far.
Thanks for your help.
David
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,214,787
Messages
6,121,558
Members
449,038
Latest member
Guest1337

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top