View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Excel cuts off bottom of page in Print Preview

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:

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?