Excel cuts off bottom of page in Print Preview

L

Lazzmatazz

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?
 
S

Sean Timmons

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...
 
L

Lazzmatazz

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 said:
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 said:
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?
 
S

Syed Imran Akhter

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?

:

Previous Posts In This Thread:

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?

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...

:

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?

:

EggHeadCafe - Software Developer Portal of Choice
Analyzing the .NET Framework 2.0 with NDepend and CQL
http://www.eggheadcafe.com/tutorial...2e-e974e6d5cc8e/analyzing-the-net-framew.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top