Auto cell height problem

[mingus]

I have an excel spreadsheet which contains mainly text. Come of the cells have several paragraphs in them so need to automatically resize to fit. For most rows this is working fine however one particular row always reverts to being too small so that 6 or so lines of text are not visible. The required size does not exceed the row heigh limit (409 point) and there are no merged cells in the sheet, so auto-resize should work fine.

Any ideas as to what might cause this to happen?

[shg]

Probably too many characters. Excel is spec'd to display only 1024. It can do more if there are line feeds interspersed, but still may not autofit.

[mingus]

Probably too many characters. Excel is spec'd to display only 1024. It can do more if there are line feeds interspersed, but still may not autofit.

Seems that you're correct, adding or removing a few line feeds shanges the text displayed but i still can't get it to autofit to the entire contents.

Once complete the size of this row won't need to change, is there a way i can fix the height at the value i want and prevent auto-fit from changing it?

[shg]

Just manually size the row as you want. If you don't alter the contents thereafter, or autosize it, it should stay the same.

That said, Excel is a unapologetically a spreadsheet, not a word processor.