Setting rows to autofit wrapping text in a cell


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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top