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 How do I change the size of cells dynamically in Excel?

FormatRowAutofit

FormatColumnAutofit Selection.

Both of these require you to have wrap text enabled.


Gord Dibben MS Excel MVP

On Wed, 3 Oct 2007 15:33:01 -0700, Little Eagle <Little
wrote:

A client wants the cell size to change dynamically when typing in it. This is
not the same as wrapping. They want the cell size to change.