View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Need cells to veritacally stretch as amount of info in cell grows

Text-Wrap and FormatRowsAutofit


Gord Dibben MS Excel MVP


On Wed, 30 Apr 2008 16:43:19 -0700, Dave wrote:

Hi,
I think you just have to format the cells to Text Wrap.
Works ok in my xl2000.
Regards - Dave.

"Wesmor" wrote:

I am constantly adding information to the same cells on a page and the cells
need to be able to stretch verticatly as the information grows. I know excel
has done it before but i don't know how to get it to do it again. Can anyone
help me format the cells so they grow w/ the amount of info entered?