Not all of the text is visible when looking at the cell.

[Guest]

Not all of the text in a cell appears when looking at the cell unless I
double click the cell or look at the formula bar. Autofit the row height is
on and shows a lot of white space. No special styles are applied. Wrap text
is on. Cell number is formatted as normal but have tried it as text also.

 

[Jim Rech]

It's an Excel limitation:

http://support.microsoft.com/default.aspx?scid=kb;en-us;211580

--
Jim
| Not all of the text in a cell appears when looking at the cell unless I
| double click the cell or look at the formula bar. Autofit the row height
is
| on and shows a lot of white space. No special styles are applied. Wrap
text
| is on. Cell number is formatted as normal but have tried it as text also.

 

[Dave Peterson]

If you add alt-enters every 80-100 characters, you'll be able to see lots more
characters.

 

[Guest]

Jim, thanks for the answer. I never even thought to look at the cell
display limits because I knew that the number of characters allowed was a
whole lot more than what was typed.

 

[Guest]

Dave,

Thanks but when I tried this the whole text only showed until I left the
cell, then the display reverted to the Excel limit of 1024 characters
displayed in a cell (a previous reply gave me that answer). Double clicking

 

[Dave Peterson]

I've never seen excel behave this way.

After I've added lots of alt-enters, I could see lots of characters.

I tried it this way:

I put this formula in A1:
="yyy"&CHAR(10)&REPT(REPT("asdf ",40)&CHAR(10),30)&"xxx"
(edit|copy, edit|paste special|values if you want)
turn wrap text on.

And adjusted the columnwidth, rowheight and font size and I could see over 6000
characters.