Too much text for an Excel cell -- how to make the cell scrollable
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.
- Turn on Developer Options: Click the Microsoft Office Button at the top left, and click "Excel Options" (next to Exit Excel). Enable "Show
Developer Tab in the Ribbon" and click okay.
- Click the Developer Tab. Under the Controls section, click Insert, and under the Active-X section, choose the Text Box (it looks like 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.