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.
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:
My first thought would be to place a texbox in the cell, set MultiLine=True, WordWrap=True, EnterKeyBehavior=True, ScrollBars=fmScrollBarsVertical. Size the textbox to the same dimensions as the cell.
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!
Without adding anything to your sheet, the contents of the cell are already scrollable in the formula bar. Just select the cell, and scroll the text in the formula bar.
An Excel cell doesn't have scroll attributes itself (Without adding an external object container via OLE, ActiveX, etc).
If its a relatively small amount of text, you can use the auto-resize option to get either the row or column to expand to display the full contents of the largest value in that row or column. To use it, slowly mouse over either the row or column headers (the A B C
... or 1 2 3
...).
When the cursor is within a few pixels of the caption border, it changes from an arrow pointer to a "resize" line.
While the cursor is in the state, double-click once to autosize that row (or column).
adding to jdh's answer:
OR you can use wrap text the cell/column if you want to preserve cell width.