Thread: Excel: How do I auto expand Cells to show all the wrapped text?
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 Excel: How do I auto expand Cells to show all the wrapped text?
FormatRowsAutofit with cells set to Wrap Text under FormatCellsAlignment

NOTE: if you are using "merged cells" autofit will not work and needs VBA event
code to change row heights.


Gord Dibben MS Excel MVP

On Tue, 12 Jun 2007 17:22:00 -0700, DonnaTypes01
wrote:

Trying to make row heights change to accommodate varying amounts of text
without manually adjusting the row height. Is there a setting I can use?

Thanks

Reply With QuoteReply With Quote