Setting rows to autofit wrapping text in a cell

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Back
Top