Row Height

[Chantel]

I'm working on this spreadsheet and we are constantly adding more information
to these cells in a certain column. After a while when there is a lot of text
added into the cell, it begins to not continue wordwrap-ing it anymore, and
cuts it off, as well as when choosing AutoFit for cell height, it won't go
any bigger than 171.00. Is there anyway to change those settings?

[Dave Peterson]

If you add alt-enters to force a new line within the cell, then you'll be able
to see more text in that cell and the wordwrap should come back.

Try adding them every 80-100 characters.

Chantel wrote:
>
> I'm working on this spreadsheet and we are constantly adding more information
> to these cells in a certain column. After a while when there is a lot of text
> added into the cell, it begins to not continue wordwrap-ing it anymore, and
> cuts it off, as well as when choosing AutoFit for cell height, it won't go
> any bigger than 171.00. Is there anyway to change those settings?

--

Dave Peterson

[Bill Sharpe]

Excel isn't really designed for putting huge amounts of text in one
cell. Suggest you insert another row below the cell of interest and put
your additional information there.

Cell height is given in points and 171 is over 14 inches. A normal size
printout won't fit on one sheet for this cell.

Bill

"Chantel" <Chantel@discussions.microsoft.com> wrote in message
news:564EC257-0FAE-40BF-84CB-38675D78CD23@microsoft.com...
I'm working on this spreadsheet and we are constantly adding more
information
to these cells in a certain column. After a while when there is a lot of
text
added into the cell, it begins to not continue wordwrap-ing it anymore,
and
cuts it off, as well as when choosing AutoFit for cell height, it won't
go
any bigger than 171.00. Is there anyway to change those settings?