Resizing merged / wrapped cells.
 

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.

Resizing merged / wrapped cells.
 

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

http://groups.google.com/group/micro...1c160cbeb27874

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
wrote:

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.

Resizing merged / wrapped cells.
 

Gord,

Wonderful - many thanks

N.

"Gord Dibben" wrote:

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

http://groups.google.com/group/micro...1c160cbeb27874

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
wrote:

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.