Resetting row height to default

[Wayne.Miller]

I have a spreadsheet with many rows that were manually set to a
variety of row heights. When text is changed, the fit of the row
height to the amount of text present in a cell is frequently not
good. The Format-Row-Autofit command ignores rows with manually set
heights. How can I reset all the row heights in the spreadsheet to a
default height that will allow me to use the Format-Row-Autofit
command?

Wayne

 

[little_creature]

I have a spreadsheet with many rows that were manually set to a
variety of row heights. When text is changed, the fit of the row
height to the amount of text present in a cell is frequently not
good. The Format-Row-Autofit command ignores rows with manually set
heights. How can I reset all the row heights in the spreadsheet to a
default height that will allow me to use the Format-Row-Autofit
command?

This is strange this should work. Does this happens on all documents
or just certain?

 

[little_creature]

I have a spreadsheet with many rows that were manually set to a
variety of row heights. When text is changed, the fit of the row
height to the amount of text present in a cell is frequently not
good. The Format-Row-Autofit command ignores rows with manually set
heights. How can I reset all the row heights in the spreadsheet to a
default height that will allow me to use the Format-Row-Autofit
command?

Wayne

Other idea, was these cell merged? Do you have text wrapping swithed
on (format>cell)?

 

[Wayne.Miller]

Other idea, was these cell merged? Do you have text wrapping
swithed

on (format>cell)?

I have no merged cells on the spreadsheet, but nearly every row has
text wrapping. I searched this forum for the autofit command and
found that the command did not work when manually adjusted row heights
were present. But I couldn't find a work around.

Does the autofit command work for you on rows with manually adjusted
heights?

 

[little_creature]

I have no merged cells on the spreadsheet, but nearly every row has
text wrapping. I searched this forum for the autofit command and
found that the command did not work when manually adjusted row heights
were present. But I couldn't find a work around.

Does the autofit command work for you on rows with manually adjusted
heights?

Yes it did, as far as I have tried - I just drag and drop one row to
make it huge then selected whole spreadsheet - adjusted by format>row
autofit and it got smaller. Is that what you are writing about?

 

[CyberTaz]

I have no merged cells on the spreadsheet, but nearly every row has
text wrapping. I searched this forum for the autofit command and
found that the command did not work when manually adjusted row heights
were present. But I couldn't find a work around.

Does the autofit command work for you on rows with manually adjusted
heights?

Hi Wayne -

L_c's right about how the row height should adjust using the AutoFit
command. It doesn't make any difference how the height was changed from the
default, but there are some potential variables involved. Most have already
been touched on here but there are others that are rather devious

Automatic row height is dictated by the largest height requirement of any
cell in the row. Even if the cell has no apparent content but its font size
has been set to 18 pts the row will not adjust to anything less than that
requirement when you AutoFit the row. You might try selecting a row that's
giving you the problem, change the font size to 10 pts for the entire row,
then try the AutoFit command - which you may not even have to do. You may
find that the row height automatically changes as soon as you reduce the
font size.

Another possibility is that at least one cell in each of the problem rows
contains a line break (Option+Command+Return). This can even be the case if
the cell appears to have no content, which makes it even harder to identify.

In either of these cases the row height *is* being autofitted, but to a size
requirement larger that what you are expecting.

HTH |:>)
Bob Jones
[MVP] Office:Mac