Cell text not printing

[Adam Torgerson]

Hi,

One of my worksheets (Excel X SR1) will not print all of the text within the
cells even though it is visible onscreen (but not on print preview). It
does not seem to be cutting of at a particular point (like 255 characters),
instead it stops printing anywhere from 270 characters to 450 characters.
What am I missing?

I know on a PC that pivot tables only display 255 characters per cell and so
do copied worksheets, but there does not seem to be consistency as to when
the text will not print.

Thanks,

Adam

 

[Jim Gordon]

Hi

If you look in Page Setup, are you printing at 100% or is Excel scaling? If
you change the font or use a different font size does that have an effect?

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Jason Kelly [MS]]

Thank you. I have tried courier new and a couple of others since I know
that some fonts do not display onscreen the same way that they print; none
of them show the entire cell contents on print preview even though the cell
contents display correctly in either normal or page break view.

The page setup is set for 100%.

Try making sure the print area is large enough. Even if the print area
includes all cells with text, any text that goes outside cell boundaries
(and outside the print area) won't be printed. This can happen if printed
text ends up slightly larger that the text appears on screen.

Let us know if that helps...

 

[Adam Torgerson]

Try making sure the print area is large enough. Even if the print area
includes all cells with text, any text that goes outside cell boundaries
(and outside the print area) won't be printed. This can happen if printed
text ends up slightly larger that the text appears on screen.

Let us know if that helps...

Thank you Jason, that seems to have worked. It still cuts off a bit of the
letters (like "g" or "p") but it is legible. Is there a specific font that
I can use to avoid this disparity?

Adam