Excel limitation within a cell

[MA expanding the knowledge of excel]

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.

 

[Dave Peterson]

Can you add some alt-enters (to force new lines within the cell)?

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

 

[Don]

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

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.

 

[Dave Peterson]

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

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.