Excel - How can I get a cell to automatically resize vertically with the amount of text in it ??

Asked By luke58 on 12-Apr-07 02:18 PM
How can I get a cell (row) to automatically resize vertically with the
amount of text in it ??




Bob I replied on 12-Apr-07 02:38 PM
Format, Cells, Alignment, Wrap text
Gord Dibben replied on 13-Apr-07 03:03 PM
Set to "warap text" and row autofit.

If it is not working for you, could be you have merged cells which autofit will
not handle.

Need VBA code or manually fit to size.


Gord Dibben  MS Excel MVP