Excel cuts off bottom of page in Print Preview

L

Lazzmatazz

I posted this question on 10/03/08 but received no useful suggestions. Does
anyone else out there recognize this problem and have an answer, especially
at Microsoft?

Thank you.

------------------------------------------------------------------------------

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

Sheeloo

Can you pl. send a couple of files to my email address so that I can take a
look?
Excel version?

Also I use free pdf writers which simply give me a pdf similar to what I
would get if I print it first and then scan it (meaning without any
interactive features)...

Lazzmatazz said:
I posted this question on 10/03/08 but received no useful suggestions. Does
anyone else out there recognize this problem and have an answer, especially
at Microsoft?

Thank you.

------------------------------------------------------------------------------

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

Lazzmatazz

Sure - as it so happens, I was just working on a sheet that needs to be
converted to PDF and exhibits the cut-off problem. I use Adobe Acrobat
Professional, V7.1.0. The problem is not really with Adobe - it is with the
Print Preview function, as you will see when you receive my email. I must use
electronic PDF creation (rather than scannning) to keep the PDF document
searchable. Scanning invariably produces errors.

The document is on its way.

Thank you.

Sheeloo said:
Can you pl. send a couple of files to my email address so that I can take a
look?
Excel version?

Also I use free pdf writers which simply give me a pdf similar to what I
would get if I print it first and then scan it (meaning without any
interactive features)...

Lazzmatazz said:
I posted this question on 10/03/08 but received no useful suggestions. Does
anyone else out there recognize this problem and have an answer, especially
at Microsoft?

Thank you.

------------------------------------------------------------------------------

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

:

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?
 

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