View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default expand row to fit

FormatCellsAligmentWrap Text

FormatRowAutofit.

Note: if cells are merged the row autofit won't work.


Gord Dibben MS Excel MVP

On Wed, 5 May 2010 15:06:01 -0700, Peter
wrote:

Is it possible to format a cell / row so that if the text in a cell is longer
than the width the text wraps and the row height expands to include the extra
line(s)?

Thanks,
Peter.