Excel - Resizing merged / wrapped cells.

Asked By NathanElphic on 24-Oct-07 12:24 PM
Is it possible to automatically resize a cell to show all the text when it is
merged and wrapped.  Home/Cells/Format/Auto Fit Row Height does not work.  I
am merging and wrapping cells B4 - G4 with 3 rows of text and resizing by
dragging the row to increase the size is a poor solution.

Gord Dibben replied on 24-Oct-07 06:23 PM
If cells are merged. the row will not autofit even with wrap text enabled
without using VBA

See google search thread for code by Greg Wilson


Second piece of advice is.............get rid of the merged cells.

They cause no end of problems with copying, pasting, sorting, filtering,
autofitting and a few(many?) others that have slipped my mind at present.

Gord Dibben  MS Excel MVP

On Wed, 24 Oct 2007 09:24:00 -0700, Nathan Elphick
NathanElphic replied on 25-Oct-07 05:53 AM

Wonderful - many thanks