ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need cells to veritacally stretch as amount of info in cell grows (https://www.excelbanter.com/excel-discussion-misc-queries/185749-need-cells-veritacally-stretch-amount-info-cell-grows.html)

Wesmor

Need cells to veritacally stretch as amount of info in cell grows
 
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?

Dave

Need cells to veritacally stretch as amount of info in cell grows
 
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?


Gord Dibben

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?




All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com