Text print size
 

Hello,

here is my problem,
when printing an excel sheet, the size of texts seems to be bigger than on
the screen.

The effect is that some of them are cutted : they fill in the cells only on
the screen.
On the printed page (or on the print preview) the text is bigger, and does
not fit anymore.

I do not understand why the text size is not the same on the screen and when
printing.
I tryed with True Type or not / I tryed qith auto-scale of the page or not
/ always the same result.

What's the matter ? How to change that ?

--
dc

any idea ?
any one ?

Are you writing about text in a single cell (or a few cells)?

If yes, then I think what you're seeing is pretty much normal.

WYSIWYG (what you see is what you get) is still close, but not identical.

If it's really important to me, I'll make sure that the hardcopy looks perfect
(or change the font size to something a little smaller).

That way if the workbook gets printed on a printer I don't own, it still might
be ok.



abcd wrote:

Hello,

here is my problem,
when printing an excel sheet, the size of texts seems to be bigger than on
the screen.

The effect is that some of them are cutted : they fill in the cells only on
the screen.
On the printed page (or on the print preview) the text is bigger, and does
not fit anymore.

I do not understand why the text size is not the same on the screen and when
printing.
I tryed with True Type or not / I tryed qith auto-scale of the page or not
/ always the same result.

What's the matter ? How to change that ?

--
dc

--

Dave Peterson

thank you,

well, if the effect you are talking about is the only problem, then it's a
bigger effect than I could imagine:

I made a try: a text showing on the screen (width = half a page), compared
with colons borders.
The printed text is longer than the text on screen: but i'm talking about 4
or 5 characters !
(i.e. I need to type many characters to bring the text on screen at the
same border-end than the printed text !)

The "arial" is bad. [to end on the creen at the same border I need to add 5
characters on the line]

The "times new roman" comes bigger but not so much, it's not acceptable but
less effect. [2 more characters]

With Batang it's very very bad ! [10 more characters !]

With some special fonts (8514oem) the effect is the opposite (it gets
smaller).

I suppose the fonts are not the same on the printer and on the screen but
sometimes is hard to say:
With Courier I need to add 14 ! (courier is supposed to be known by almost
all the printers)

So is it the "still close, but not identical" you are talking about ?
I'm still very surprised. Is it really "normal" ?

It's always been normal when I do it. (But it's not what I want.)

I sometimes add an additional alt-enter at the end of cell's value. Then if
that cell wraps weirdly, I still figure my text will still be there.

WYSIWYG isn't really WYSIWYG

You may want to try:
format|cells|Alignment tab|and shrink to fit.

It may shrink the text to something slightly smaller that'll work on your
hardcopy. (I didn't test this.)



abcd wrote:

thank you,

well, if the effect you are talking about is the only problem, then it's a
bigger effect than I could imagine:

I made a try: a text showing on the screen (width = half a page), compared
with colons borders.
The printed text is longer than the text on screen: but i'm talking about 4
or 5 characters !
(i.e. I need to type many characters to bring the text on screen at the
same border-end than the printed text !)

The "arial" is bad. [to end on the creen at the same border I need to add 5
characters on the line]

The "times new roman" comes bigger but not so much, it's not acceptable but
less effect. [2 more characters]

With Batang it's very very bad ! [10 more characters !]

With some special fonts (8514oem) the effect is the opposite (it gets
smaller).

I suppose the fonts are not the same on the printer and on the screen but
sometimes is hard to say:
With Courier I need to add 14 ! (courier is supposed to be known by almost
all the printers)

So is it the "still close, but not identical" you are talking about ?
I'm still very surprised. Is it really "normal" ?

--

Dave Peterson