View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default autofit row text (wrapped) without changing column width?

Select your rows.

FormatRowAutofit.

Also make sure the rows are set for Wrap Text.


Gord Dibben MS Excel MVP

On Tue, 7 Nov 2006 08:46:02 -0800, kimdnw
wrote:

Working in spreadsheets with established columns. However, as data is added
and subtracted, text repeatedly becomes hidden when rows shift. Can I cause
the cells to "auto fit" text to the row without changing column width?