What do I do when I have more text in an Excel cell than I want to show in the allocated space?
Something making it "scrollable" would be preferred.
microsoft excelmicrosoft-excel-2003spreadsheet
What do I do when I have more text in an Excel cell than I want to show in the allocated space?
Something making it "scrollable" would be preferred.
Best Answer
You should create an Active-X text box in the cell and edit some of it's settings to enable the scrolling/wrapping/multi-line features. I got this answer from this MrExcel.com forum post:
ab|
).On the main worksheet, click-drag the area where you want to place the text box.
Ensure Design Mode is enabled and click Properties.
Hope this helps!