Thread: Format AutoFit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Format AutoFit

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 is all one line.

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


Gord Dibben MS Excel MVP


On Wed, 31 Dec 2008 19:38:00 -0800, jolowe
wrote:

I have merged two cells (columns), in an area of my worksheet (the area
contains 13 rows) I set the row heights of all 13 to AutoFit. When I type
in the cell it expands and I can see all the lines of print - but as soon as
I press enter the cell goes back to its original height and only one line of
print is visable - Is there a way to make the expanded cell stay expanded
when I move on to the next line???