ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Words wrapped differently on screen and on print preview (https://www.excelbanter.com/excel-discussion-misc-queries/32486-words-wrapped-differently-screen-print-preview.html)

Merike

Words wrapped differently on screen and on print preview
 
Some words in a cell are too long to fit in so they're wrapped. I put in - so
it gets wrapped at a certain point. On screen it wraps according to - like:
wordbeginning-
wordend
but on print preview it displays:
wordbeginning-end
on one line instead of wrapping. That is only if it's not too long word
because it doesn't stretch cells. It seems as if cells on screen are smaller
than on print preview?!

How can I make them wrap the same way so I can be sure what I see on screen
is the same others will see on paper?
--
You can't know everything about everything.

RagDyeR

Try using manual (forced) line breaks.

<Alt <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Merike" wrote in message
...
Some words in a cell are too long to fit in so they're wrapped. I put in -
so
it gets wrapped at a certain point. On screen it wraps according to - like:
wordbeginning-
wordend
but on print preview it displays:
wordbeginning-end
on one line instead of wrapping. That is only if it's not too long word
because it doesn't stretch cells. It seems as if cells on screen are smaller
than on print preview?!

How can I make them wrap the same way so I can be sure what I see on screen
is the same others will see on paper?
--
You can't know everything about everything.



Merike

It solved it. Thanks a lot.

Still I find it bizarre since truetype font is the same size in pixels both
way...
--
You can't know everything about everything.


"RagDyeR" wrote:

Try using manual (forced) line breaks.

<Alt <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Merike" wrote in message
...
Some words in a cell are too long to fit in so they're wrapped. I put in -
so
it gets wrapped at a certain point. On screen it wraps according to - like:
wordbeginning-
wordend
but on print preview it displays:
wordbeginning-end
on one line instead of wrapping. That is only if it's not too long word
because it doesn't stretch cells. It seems as if cells on screen are smaller
than on print preview?!

How can I make them wrap the same way so I can be sure what I see on screen
is the same others will see on paper?
--
You can't know everything about everything.




Ragdyer

Appreciate the feed-back.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Merike" wrote in message
...
It solved it. Thanks a lot.

Still I find it bizarre since truetype font is the same size in pixels

both
way...
--
You can't know everything about everything.


"RagDyeR" wrote:

Try using manual (forced) line breaks.

<Alt <Enter
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Merike" wrote in message
...
Some words in a cell are too long to fit in so they're wrapped. I put

in -
so
it gets wrapped at a certain point. On screen it wraps according to -

like:
wordbeginning-
wordend
but on print preview it displays:
wordbeginning-end
on one line instead of wrapping. That is only if it's not too long word
because it doesn't stretch cells. It seems as if cells on screen are

smaller
than on print preview?!

How can I make them wrap the same way so I can be sure what I see on

screen
is the same others will see on paper?
--
You can't know everything about everything.





abcd

this problem is surprising but you're not the only one:
everything act like if the scale for cells and for fonts are not the
same. It depends on the font: some have big gap between screen and
printer. Some others stay quite stable: if you have a variable text
changing a lot: it's better to try different fonts print it and see
which one has a small gap.

every one want true type to be "true" type. But it's not.


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com