View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel 2007 AutoFit Row Height not working

Are the cells "merged"?

Merged cells with wrap text won't Autofit.

You need VBA event code to get the autofit.

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 Tue, 10 Mar 2009 09:27:00 -0700, KristinQ
wrote:

I have several cells that are aligned "Top" with wrap text turned on that run
past the border of the cell. The Format/AutoFit Row Height command does not
fix the issue, nor does selecting all and clicking on the bottom row border.
I'm having to fix them all by hand. What am I doing wrong? They are only
one or two sentences long, so shouldn't be too much data. Thanks!