software

How do I get an excel cell that exceeds 1,024 characters to print? I have
typed a paragraph that exceeds the 1,024 character display limit, but does
not exceed the 32,767 length of cell contents limit. The page is set up with
multiple columns, the content is typed into one cell, and then several cells
over the rows and columns are merged and text is wrapped. Everything shows
in the formula bar, but the display on the page is cut off and when I print
it is cut off. I have tried printing to 2 different printers on our network.
I'm using Excel 2003. I think my operating system is XP.

If you add alt-enters (to force new lines within the cell) every 80-100
characters, you'll be able to see more characters.

And if you widen the column, increase the rowheight and use a smaller font, you
may be able to print (and see) what you want.

Jenny wrote:
gt;
gt; How do I get an excel cell that exceeds 1,024 characters to print? I have
gt; typed a paragraph that exceeds the 1,024 character display limit, but does
gt; not exceed the 32,767 length of cell contents limit. The page is set up with
gt; multiple columns, the content is typed into one cell, and then several cells
gt; over the rows and columns are merged and text is wrapped. Everything shows
gt; in the formula bar, but the display on the page is cut off and when I print
gt; it is cut off. I have tried printing to 2 different printers on our network.
gt; I'm using Excel 2003. I think my operating system is XP.

--

Dave Peterson

Thank you Dave. While I am not able to see all the characters the way I
would like to while looking at the worksheet page, I can see them in the
formula bar. I did not want to change the row/column settings as we are
working with a template. This did make it though so that everything I typed
within that cell printed for me, and that's the main thing I was looking for.
Thank you again.

quot;Dave Petersonquot; wrote:

gt; If you add alt-enters (to force new lines within the cell) every 80-100
gt; characters, you'll be able to see more characters.
gt;
gt; And if you widen the column, increase the rowheight and use a smaller font, you
gt; may be able to print (and see) what you want.
gt;
gt; Jenny wrote:
gt; gt;
gt; gt; How do I get an excel cell that exceeds 1,024 characters to print? I have
gt; gt; typed a paragraph that exceeds the 1,024 character display limit, but does
gt; gt; not exceed the 32,767 length of cell contents limit. The page is set up with
gt; gt; multiple columns, the content is typed into one cell, and then several cells
gt; gt; over the rows and columns are merged and text is wrapped. Everything shows
gt; gt; in the formula bar, but the display on the page is cut off and when I print
gt; gt; it is cut off. I have tried printing to 2 different printers on our network.
gt; gt; I'm using Excel 2003. I think my operating system is XP.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I am also having the problem Jenny explained however, when I resize my font
to even a 7 then widen my box I can see a lot of space below the typed text
content. When I print preview and also print, the content is still either
cut off or prints right on the outline of the box. I have talked to our tech
at school and she cannot figure this out either. We have to drage the bar
pretty far to make the content print within the box.

quot;Jennyquot; wrote:

gt; Thank you Dave. While I am not able to see all the characters the way I
gt; would like to while looking at the worksheet page, I can see them in the
gt; formula bar. I did not want to change the row/column settings as we are
gt; working with a template. This did make it though so that everything I typed
gt; within that cell printed for me, and that's the main thing I was looking for.
gt; Thank you again.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; If you add alt-enters (to force new lines within the cell) every 80-100
gt; gt; characters, you'll be able to see more characters.
gt; gt;
gt; gt; And if you widen the column, increase the rowheight and use a smaller font, you
gt; gt; may be able to print (and see) what you want.
gt; gt;
gt; gt; Jenny wrote:
gt; gt; gt;
gt; gt; gt; How do I get an excel cell that exceeds 1,024 characters to print? I have
gt; gt; gt; typed a paragraph that exceeds the 1,024 character display limit, but does
gt; gt; gt; not exceed the 32,767 length of cell contents limit. The page is set up with
gt; gt; gt; multiple columns, the content is typed into one cell, and then several cells
gt; gt; gt; over the rows and columns are merged and text is wrapped. Everything shows
gt; gt; gt; in the formula bar, but the display on the page is cut off and when I print
gt; gt; gt; it is cut off. I have tried printing to 2 different printers on our network.
gt; gt; gt; I'm using Excel 2003. I think my operating system is XP.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

Give us an example of what's in the cell, and how wide your column is. Are
you using merged cells?

Regards,
Fred.

quot;Rebeccaquot; gt; wrote in message
...
gt;I am also having the problem Jenny explained however, when I resize my font
gt; to even a 7 then widen my box I can see a lot of space below the typed
gt; text
gt; content. When I print preview and also print, the content is still either
gt; cut off or prints right on the outline of the box. I have talked to our
gt; tech
gt; at school and she cannot figure this out either. We have to drage the bar
gt; pretty far to make the content print within the box.
gt;
gt; quot;Jennyquot; wrote:
gt;
gt;gt; Thank you Dave. While I am not able to see all the characters the
gt;gt; way I
gt;gt; would like to while looking at the worksheet page, I can see them in the
gt;gt; formula bar. I did not want to change the row/column settings as we are
gt;gt; working with a template. This did make it though so that everything I
gt;gt; typed
gt;gt; within that cell printed for me, and that's the main thing I was looking
gt;gt; for.
gt;gt; Thank you again.
gt;gt;
gt;gt; quot;Dave Petersonquot; wrote:
gt;gt;
gt;gt; gt; If you add alt-enters (to force new lines within the cell) every 80-100
gt;gt; gt; characters, you'll be able to see more characters.
gt;gt; gt;
gt;gt; gt; And if you widen the column, increase the rowheight and use a smaller
gt;gt; gt; font, you
gt;gt; gt; may be able to print (and see) what you want.
gt;gt; gt;
gt;gt; gt; Jenny wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; How do I get an excel cell that exceeds 1,024 characters to print? I
gt;gt; gt; gt; have
gt;gt; gt; gt; typed a paragraph that exceeds the 1,024 character display limit, but
gt;gt; gt; gt; does
gt;gt; gt; gt; not exceed the 32,767 length of cell contents limit. The page is set
gt;gt; gt; gt; up with
gt;gt; gt; gt; multiple columns, the content is typed into one cell, and then
gt;gt; gt; gt; several cells
gt;gt; gt; gt; over the rows and columns are merged and text is wrapped. Everything
gt;gt; gt; gt; shows
gt;gt; gt; gt; in the formula bar, but the display on the page is cut off and when I
gt;gt; gt; gt; print
gt;gt; gt; gt; it is cut off. I have tried printing to 2 different printers on our
gt;gt; gt; gt; network.
gt;gt; gt; gt; I'm using Excel 2003. I think my operating system is XP.
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; Dave Peterson
gt;gt; gt; Did you add those alt-enters every 80-100 characters?

Rebecca wrote:
gt;
gt; I am also having the problem Jenny explained however, when I resize my font
gt; to even a 7 then widen my box I can see a lot of space below the typed text
gt; content. When I print preview and also print, the content is still either
gt; cut off or prints right on the outline of the box. I have talked to our tech
gt; at school and she cannot figure this out either. We have to drage the bar
gt; pretty far to make the content print within the box.
gt;
gt; quot;Jennyquot; wrote:
gt;
gt; gt; Thank you Dave. While I am not able to see all the characters the way I
gt; gt; would like to while looking at the worksheet page, I can see them in the
gt; gt; formula bar. I did not want to change the row/column settings as we are
gt; gt; working with a template. This did make it though so that everything I typed
gt; gt; within that cell printed for me, and that's the main thing I was looking for.
gt; gt; Thank you again.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; If you add alt-enters (to force new lines within the cell) every 80-100
gt; gt; gt; characters, you'll be able to see more characters.
gt; gt; gt;
gt; gt; gt; And if you widen the column, increase the rowheight and use a smaller font, you
gt; gt; gt; may be able to print (and see) what you want.
gt; gt; gt;
gt; gt; gt; Jenny wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; How do I get an excel cell that exceeds 1,024 characters to print? I have
gt; gt; gt; gt; typed a paragraph that exceeds the 1,024 character display limit, but does
gt; gt; gt; gt; not exceed the 32,767 length of cell contents limit. The page is set up with
gt; gt; gt; gt; multiple columns, the content is typed into one cell, and then several cells
gt; gt; gt; gt; over the rows and columns are merged and text is wrapped. Everything shows
gt; gt; gt; gt; in the formula bar, but the display on the page is cut off and when I print
gt; gt; gt; gt; it is cut off. I have tried printing to 2 different printers on our network.
gt; gt; gt; gt; I'm using Excel 2003. I think my operating system is XP.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;

--

Dave Peterson