Text in formula bar is not displaying in cell
 

I am using Excel 2003. I am working in a merged cell with a row height of
375, which is less than the maximum of 409. The text in the cell gets cut
off once I click off of it even though it displays in the formula bar and it
also displays in the cell when I double-click inside the cell. There is
plenty of space within the cell for all of the text, but it just doesn't
display completely. I changed the font to a smaller size, and it still cuts
off at the same spot. Can anyone help, please?? Thank you!!

Raquel

Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell.

However, it goes on to state that "only 1024 characters will be visible or can
be printed"

To work around this limitation, stick a few ALT + ENTERs in at appropriate
spots, about every 200 characters..

The ALT + ENTER forces a line-feed and expands the 1024 limit.

How far is not really known. Just experiment.

.........From Dave Peterson..........

I put this formula in A1:
="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

And adjusted the columnwidth, rowheight and font size and I got about 7300
characters to print ok.

.........End Dave P.................

Failing that, use a Text Box to store the text or MS Word which is a word
processing application, unlike Excel which is not.


Gord Dibben Excel MVP

On Mon, 29 Aug 2005 13:53:17 -0700, "Raquel8D"
wrote:

I am using Excel 2003. I am working in a merged cell with a row height of
375, which is less than the maximum of 409. The text in the cell gets cut
off once I click off of it even though it displays in the formula bar and it
also displays in the cell when I double-click inside the cell. There is
plenty of space within the cell for all of the text, but it just doesn't
display completely. I changed the font to a smaller size, and it still cuts
off at the same spot. Can anyone help, please?? Thank you!!