Resizing rows

[balper]

When I have too much text in a cell, auto-resizing will not "stretch" the row height enough to see all of the text. Please help, I've been struggling with this issue forever.

[Cutter]

By "auto-resizing" are you referring to:

Home - Cells - Format - AutoFit Row Height?

If not, give that a try.

[davegugg]

The max row height in Excel is 409.5 points. If you want a row with a hieght greater than 409.5, you can merge cells. You can also make the cells wider to fit more text. Those are the only options that I'm aware of.

[Cutter]

There is a 3rd option:

Use a smaller font size

[Marcol]

And another,

Use Word, if you want to tell a story,

[davesexcel]

You could also try using a text box

[balper]

I am refering to AutoFit Row Height.

Its not that I've hit the max cell height, for some reason past a certain point excel only expands the cell to 80~90% of the height of the full contents, leaving some of the text still hidden.

Appreciate the humor , but any other ideas? (like a macro or something)

[Marcol]

Have a look at this thread.

http://www.excelforum.com/excel-prog...ow-height.html

There are several more like threads in the Forum.