Go to File, Page Setup
Set the "Print Quality" to 600 dpi
Lazzmataz wrote:
Thank you for your response, but it's not going to help.
04-Oct-08
Thank you for your response, but it's not going to help. First thing I ALWAYS
do is set print area. I always work in Page Break view and use the blue lines
to set page breaks. The defect I am describing only occurs in Print Preview.
It does not affect printing to paper - it prints just fine. However, Acrobat
takes a picture of what is visible in Print Preview to convert it to PDF,
which is where the problem lies. If memory serves, the same glitch also
occurs in Word. (I do not use Word for this purpose nearly as much as Excel.)
This leads me to believe that this maybe a deeper underlying defect of the
Print Preview feature perhaps in all Office applications.
I talked to many heavy users of Excel and confirmed that they have all seen
this problem. Has anyone else seen it out there, especially at Microsoft? Any
further suggestions?
"Sean Timmons" wrote:
Previous Posts In This Thread:
On Friday, October 03, 2008 5:27 PM
Lazzmataz wrote:
Excel cuts off bottom of page in Print Preview
In some Excel files, especially ones received via email and then edited, the
Print Preview cuts off the bottom portion (a quarter or a third) of the page.
Files with multiple tabs can occasionally exhibit the same error in only one
tab, but sometimes all of them. When printed to Adobe Acrobat, the PDF file
displays the same error. This is a major pain, since I have to do this many
times a day with some fairly large spreadsheets. The defective pages have to
be copied and pasted into new pages and reformatted by hand for a successful
PDF conversion - hours of unnecessary work! [Excel 2003, WinXP Pro, SP3]
Is anyone else aware of this glitch, and is there a fix?
On Friday, October 03, 2008 6:41 PM
SeanTimmon wrote:
Only fix I know of is to view the page in Page Break Preview and drag the blue
Only fix I know of is to view the page in Page Break Preview and drag the
blue lines around the text. That or Highlighting the entier table and Using
File - Print Area - Set Print Area...
"Lazzmatazz" wrote:
On Saturday, October 04, 2008 5:28 AM
Lazzmataz wrote:
Thank you for your response, but it's not going to help.
Thank you for your response, but it's not going to help. First thing I ALWAYS
do is set print area. I always work in Page Break view and use the blue lines
to set page breaks. The defect I am describing only occurs in Print Preview.
It does not affect printing to paper - it prints just fine. However, Acrobat
takes a picture of what is visible in Print Preview to convert it to PDF,
which is where the problem lies. If memory serves, the same glitch also
occurs in Word. (I do not use Word for this purpose nearly as much as Excel.)
This leads me to believe that this maybe a deeper underlying defect of the
Print Preview feature perhaps in all Office applications.
I talked to many heavy users of Excel and confirmed that they have all seen
this problem. Has anyone else seen it out there, especially at Microsoft? Any
further suggestions?
"Sean Timmons" wrote:
EggHeadCafe - Software Developer Portal of Choice
Analyzing the .NET Framework 2.0 with NDepend and CQL
http://www.eggheadcafe.com/tutorials...et-framew.aspx