ExcelBanter - Cell Size Issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell Size Issue (https://www.excelbanter.com/excel-discussion-misc-queries/187456-cell-size-issue.html)

I have 3 cells that are merged into one cell. Wrap text is check as is Merged
cells in the Format Dialog box. However, the text does not wrap and the cell
does not expand when I type text in. Are any other settings that I am
missing....

marf

Welcome to the wonderful world of merged cells which cause no end of problems
and should be banned from existence.

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. Watch out for word wrap in
the URL which all one line.

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

Gord Dibben MS Excel MVP

On Wed, 14 May 2008 12:41:03 -0700, marf wrote:

I have 3 cells that are merged into one cell. Wrap text is check as is Merged
cells in the Format Dialog box. However, the text does not wrap and the cell
does not expand when I type text in. Are any other settings that I am
missing....