Rows not Resizing

S

Sigma

I have a spreadsheet which will wrap the text in the cells as selected
but the row will not resize to fit the contents.

Does anyone know a cause or a fix for this?
 
N

Ninja Stevie

Select the whole sheet, and then double click between two row numbers
on the very left (when the curser changes into a horizontal line with
an arrow pointing upwards and an arrow pointing downwards)
 
D

Dave Peterson

Do you have lots of text in your cells?

Do you use merged cells?

Both of these can upset autofitting of rows.
 
S

Sigma

The text amount is usually limited to around 150 characters or less so I
don't think that is the issue.

I do have merged cells at the top of the document, the first 7 rows. My
problem is with the rows after this "header" portion. There aren't any
merged cells in these areas.

If the merging cells are the issue, is there a patch or a viable
work-around?
 
D

Dave Peterson

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

But that doesn't sound like your problem.

If you've ever changed the rowheight manually, excel won't change the rowheight
automatically until you autofit that row (but you said you did that and it still
didn't work).

How are those cells changing?

If the changes are the results of formulas, then excel won't fix them either. I
don't have any other guesses if you're doing the typing.
 
D

Dave Peterson

You said that the rows that didn't autofit we not merged--so that macro wouldn't
change those rowheights.

I'm all out of guesses.
 
Top