I have a spreadsheet with many cells containing multiple lines of text. I've
formatted all of them to autofit the row height, but some cells refuse to
autofit, and display the text as ######### regardless of how I adjust the row
height, even manually. I have no merged cells.

In other cells (also formatted to autofit), the text is showing, but only a
few lines--again, the row height refuses to adjust.

Peter

Try formatting the cells as General. Excel has problems with text-formatted
cells when it gets above 250 characters or so.

Also, you can enter 32,767 characters in a cell but Excel will display, in
most cases, about 1024 of these.

If you are above that number you could use ALT + ENTER to set line-feeds at
appropriate spots in the text to increase the visible characters.

Also make sure the format for the cells has been set to "wrap text" in order
for autofit to work properly.


Gord Dibben Excel MVP

On Tue, 18 Jan 2005 13:01:06 -0800, "Peter Graff" <Peter
wrote:

I have a spreadsheet with many cells containing multiple lines of text. I've
formatted all of them to autofit the row height, but some cells refuse to
autofit, and display the text as ######### regardless of how I adjust the row
height, even manually. I have no merged cells.

In other cells (also formatted to autofit), the text is showing, but only a
few lines--again, the row height refuses to adjust.

Gord,

Thanks, the general format tip seemed to work.

-p


"Gord Dibben" wrote:

Peter

Try formatting the cells as General. Excel has problems with text-formatted
cells when it gets above 250 characters or so.

Also, you can enter 32,767 characters in a cell but Excel will display, in
most cases, about 1024 of these.

If you are above that number you could use ALT + ENTER to set line-feeds at
appropriate spots in the text to increase the visible characters.

Also make sure the format for the cells has been set to "wrap text" in order
for autofit to work properly.


Gord Dibben Excel MVP

On Tue, 18 Jan 2005 13:01:06 -0800, "Peter Graff" <Peter
wrote:

I have a spreadsheet with many cells containing multiple lines of text. I've
formatted all of them to autofit the row height, but some cells refuse to
autofit, and display the text as ######### regardless of how I adjust the row
height, even manually. I have no merged cells.

In other cells (also formatted to autofit), the text is showing, but only a
few lines--again, the row height refuses to adjust.

Thanks for the feedback Peter.

Gord

On Tue, 18 Jan 2005 14:03:02 -0800, "Peter Graff"
wrote:

Gord,

Thanks, the general format tip seemed to work.

-p


"Gord Dibben" wrote:

Peter

Try formatting the cells as General. Excel has problems with text-formatted
cells when it gets above 250 characters or so.

Also, you can enter 32,767 characters in a cell but Excel will display, in
most cases, about 1024 of these.

If you are above that number you could use ALT + ENTER to set line-feeds at
appropriate spots in the text to increase the visible characters.

Also make sure the format for the cells has been set to "wrap text" in order
for autofit to work properly.


Gord Dibben Excel MVP

On Tue, 18 Jan 2005 13:01:06 -0800, "Peter Graff" <Peter
wrote:

I have a spreadsheet with many cells containing multiple lines of text. I've
formatted all of them to autofit the row height, but some cells refuse to
autofit, and display the text as ######### regardless of how I adjust the row
height, even manually. I have no merged cells.

In other cells (also formatted to autofit), the text is showing, but only a
few lines--again, the row height refuses to adjust.