Excel limitation within a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the excel workwork as a weekly report. Some cell will have more text and others. Currents when I am printing out my workbook certain cells are unprintable. That is a portion of the cell is printed. What you see is that the text is cut off in the middle of the sentence. The only way to see the whole cell in full is if you click on the cell while on the softcopy. I can not find where the text restriction is so I can turn it off. Help.
 
Can you add some alt-enters (to force new lines within the cell)?

When you do this, you can usually see more text.
 
Hi ma,

1024 is the magic number...i.e. length of characters
Excel will accept in one cell and print out correctly.
You'll see more in the cell but they won't print. I ran
into this a few weeks ago.

As Dave says, this limit can be worked around by
inserting "Alt/Enter" commands. I found, for my
purposes, it was best to just seperate the Data into
different cells, but whatever works for you.

HTH,

Don

-----Original Message-----
I am using the excel workwork as a weekly report. Some
Click to expand...
cell will have more text and others. Currents when I am
printing out my workbook certain cells are unprintable.
That is a portion of the cell is printed. What you see is
that the text is cut off in the middle of the sentence.
The only way to see the whole cell in full is if you
click on the cell while on the softcopy. I can not find
where the text restriction is so I can turn it off.
Help.
 
Another option is to use a Textbox (either from the Drawing toolbar or from the
ControlToolbox toolbar).


Hi ma,

1024 is the magic number...i.e. length of characters
Excel will accept in one cell and print out correctly.
You'll see more in the cell but they won't print. I ran
into this a few weeks ago.

As Dave says, this limit can be worked around by
inserting "Alt/Enter" commands. I found, for my
purposes, it was best to just seperate the Data into
different cells, but whatever works for you.

HTH,

Don
-----Original Message-----
I am using the excel workwork as a weekly report. Some
Click to expand...
cell will have more text and others. Currents when I am
printing out my workbook certain cells are unprintable.
That is a portion of the cell is printed. What you see is
that the text is cut off in the middle of the sentence.
The only way to see the whole cell in full is if you
click on the cell while on the softcopy. I can not find
where the text restriction is so I can turn it off.
Help.
Click to expand...
 
Back
Top