How to fit a row height to a cell contents automatically?

[Dmitriy Kopnichev]

Hello
How to fit a row height to a cell contents automatically? Double clicking on
the row edge doesn't decrease height. There's free space left below text.
This happens to some rows only.
--
Please, inform me of your reply: click Message menu, then 'Reply to all' in
Outlook Express (this sends your reply to the newsgroups and to my email
address at the same time) or inform me by sms to 79163876746 from
www.mts.ru/sms or to my ICQ#135557327 or by messenger to
(e-mail address removed)
Mr. Dmitriy Kopnichev
e-mail: (e-mail address removed)

 

[Alex McGow]

Select whole row and set font size to, say, 6.

Row height will now be set automatically by largest cell font in the row.

Alex.

 

[Paul Cundle]

Are you sure there isn't a load of excess trailing spaces at the end of any
of the cells?

Try selecting an offending row and in format-->cells-->alignment turn off
"wrap text". This would mean that the spaces over-run the cell edges and
could look funny, though.

Or, suppose row 10 is too high. In A11, put
=TRIM(A10)
and drag this formula all the way across the worksheet. It will clear out
unnecessary spaces for every cell in row 10 and so row 11 should autofit
properly. If this works, you'll have to go through the whole sheet locating
cells with extra spaces.

Paul C,
--