Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Why does it not print how is it on screen?

I have wrapped text in several cells. When I autofit the row height, it adds
a space at the bottom, but there is no text on that line. Also, in other
instances, it puts a word on the next line on screen because it doesn't fit,
but then when I print it, it all fits on one line and still prints the extra
space at the bottom. It is driving me crazy and I just can't figure out why
it does it.

If anybody can help, I would appreciate it. Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Why does it not print how is it on screen?

What you see is what you get (WYSIWYG) ain't necessarily so.

The only way I know for sure how it looks on my printer is to print and review
the paper.

And that doesn't help me know how it'll print on other printers for other
people. If I'm worried, I'll increase the row height to make sure nothing is
cut off. (I'd rather have too much space than lose some of the text in the
cell.)

JackieB80 wrote:

I have wrapped text in several cells. When I autofit the row height, it adds
a space at the bottom, but there is no text on that line. Also, in other
instances, it puts a word on the next line on screen because it doesn't fit,
but then when I print it, it all fits on one line and still prints the extra
space at the bottom. It is driving me crazy and I just can't figure out why
it does it.

If anybody can help, I would appreciate it. Thanks!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Why does it not print how is it on screen?

Here is an example: type the following in a single cell, size 10 and Times
New Roman font. Wrap the text, top vertical alignment:

Pain managed with POC. Fever. Increased dyspnea. Increased
incontinence-Daughter updated.

Add a background color (so you can see how it prints). When you go to print
preview, it doesn't print how it looks on screen and it adds 2 extra lines.

"JackieB80" wrote:

I have wrapped text in several cells. When I autofit the row height, it adds
a space at the bottom, but there is no text on that line. Also, in other
instances, it puts a word on the next line on screen because it doesn't fit,
but then when I print it, it all fits on one line and still prints the extra
space at the bottom. It is driving me crazy and I just can't figure out why
it does it.

If anybody can help, I would appreciate it. Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Screen Richard Excel Discussion (Misc queries) 4 March 3rd 08 04:28 PM
print box opens in right screen of dual screen setup why gerrys Excel Discussion (Misc queries) 1 June 30th 06 07:47 PM
print screen climax Excel Discussion (Misc queries) 4 February 26th 06 08:52 PM
How do I get a pasted screen print to appear? Fecha1776 Excel Discussion (Misc queries) 0 July 26th 05 06:31 PM
Print and Print Preview don't match screen JNohl Excel Worksheet Functions 0 March 11th 05 06:23 PM


All times are GMT +1. The time now is 07:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"