Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2003 Is it possible to print a split screen in a spreadsh | Excel Discussion (Misc queries) | |||
Print and Print Preview don't match screen | Excel Worksheet Functions | |||
Difference between screen view and print | Excel Discussion (Misc queries) | |||
Print a screen shot in Excel? | Excel Discussion (Misc queries) | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) |