Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Automatic row height adjust
1 view
Skip to first unread message
ckemler
Dec 22, 2009, 12:07:01 PM12/22/09
to
I have merged three cells in the same row for the user to enter a description
and formatted the cell to wrap the text. The intent is for the row height to
adjust automatically when a long string is entered, and currently it is not.
I have other spreadsheets where it does and I have taken for granted that
this will happen automatically.
Is there a setting or format that I have missed?
and formatted the cell to wrap the text. The intent is for the row height to
adjust automatically when a long string is entered, and currently it is not.
I have other spreadsheets where it does and I have taken for granted that
this will happen automatically.
Is there a setting or format that I have missed?
Thanks for your help
Gord Dibben
Dec 22, 2009, 12:26:24 PM12/22/09
to
Merged cells will kill the autofit of a row.
Just one of the multitude of problems caused by merged cells.
You need VBA code to overcome this feature.
For worksheet event code...............
See google search thread for code by Greg Wilson. Watch out for word wrap
in the URL which all one line.
Gord Dibben MS Excel MVP
0 new messages