Scrolling Within a Cell

[mbennion]

I am trying to create an issue log using Excel 2007. The status reporting
creates some rather lengthy text narratives. If I resize the row height to
show all the narrative, I get some astonishingly large rows, which makes the
number if the "issue #" cell look tiny and lonesome.
Is there a way to format a cell (a text cell) so that the user can just
scroll through the text? So I can set the standard row height to, say, 30,
and then if there is more text than will display in that space, the user can
just access a scroll bar and read through the details to her heart's content?

 

[Gord Dibben]

Show user how to select the cell.

Then expand the formula bar(click on double arrows at right end)

If more than 3 lines use the scroll arrows found at right end.


Gord Dibben MS Excel MVP