ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I type words in the cell and when I make it wordwrap it dissapears (https://www.excelbanter.com/excel-discussion-misc-queries/204349-i-type-words-cell-when-i-make-wordwrap-dissapears.html)

ginlee2

I type words in the cell and when I make it wordwrap it dissapears
 
I am having such a big problem...I type a lot of cells and then do wordwrap
and everything it disappears. I can click on each cell and it shows that it
is there. I can view the worksheet and everything is there...Help

Peo Sjoblom[_2_]

I type words in the cell and when I make it wordwrap it dissapears
 
Look up specifications in excel help and you will see that it will only
display
a certain number of characters

--


Regards,


Peo Sjoblom

"ginlee2" wrote in message
...
I am having such a big problem...I type a lot of cells and then do wordwrap
and everything it disappears. I can click on each cell and it shows that
it
is there. I can view the worksheet and everything is there...Help




Dave Peterson

I type words in the cell and when I make it wordwrap it dissapears
 
You'll see about 1000 characters in a cell unless you do something special.

You can add alt-enters (to force a newline within the cell) every 80-100
characters to see lots more.

Depending on the length of string, you may still have to adjust the rowheight
manually, though.

ginlee2 wrote:

I am having such a big problem...I type a lot of cells and then do wordwrap
and everything it disappears. I can click on each cell and it shows that it
is there. I can view the worksheet and everything is there...Help


--

Dave Peterson


All times are GMT +1. The time now is 02:51 AM.

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