Setting rows to autofit wrapping text in a cell

[John]

I have a spreadsheet with 5 columns and 6 rows. Each cell will contain text
of an indeterminate length. I would like the rows to autofit the text but
even though I've selected that in format when I test a cell to see if the row
will automatically increase in height to accommodate the text the row does
not adjust and all of the text is not seen. Is there a way to fix this?

Thanks

 

[Gord Dibben]

A few things to look for.

The cells must be set to Wrap Text and rows set to Autofit.

BUT.........if any cells are merged row autofit will not work and VBA must
be employed.

Also. if the number of characters in the cell exceeds 1024 you will not see
characters past that point even with wrap text and row autofit.

In the latter case, add an in-cell linefeed every 100 or so characters using
Alt + Enter


Gord Dibben MS Excel MVP