View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
 
Posts: 248
Default Save as PDF not same size as Print and Print Preview in Excel

Click on View and then on 'Page Break Preview'...

You will see that print area includes column W also... drag the right corner
back to Col V and your problem should be fixed.
In print you must be getting a blank page... you can test by putting
anything in Col W and then printing..

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"Jack_Sprat" wrote:

When I create a small one page speadsheet in Excel 2007, and print it, it
prints fine - all on one page. However, if I save this document as a PDF
file, the last column gets clipped and put onto a second page. The print
area is set to include the entire worksheet. The PDF processor is that
downloaded from the MS site for Office 2007.

Is there any way of producing the PDF file so that it will fit onto only one
page, in a similar manner as saving and printing from Excel? I cannot find
any PDF options to fit to page.

The document in question can be seen on my skydrive at:
http://cid-8f2c74bf2c0b9544.skydrive...0Mar%2007.xlsx