Save as PDF not same size as Print and Print Preview in Excel


J

Jack_Sprat

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.live.com/self.aspx/.Public/Excel/Sudoku High-5 Mar 07.xlsx
 
Ad

Advertisements

S

Sheeloo

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

Jack_Sprat

Thanks for the reply.. I had wanted to have some white space on each side of
the page, therefore added blank columns A and W. The PDF problem was fixed
by reducing the A and W columns by half. Now it saves correctly as PDF.

btw.. printing the document worked fine.. no extra blank page. That's what
was making it so weird to me.. printing worked fine, but not saving as PDF.

Anyway, it is now working correctly. Thanks!
 
Ad

Advertisements

S

Sheeloo

Glad it worked out...

Pages printed on different printers come out slightly different especially
margins.
 

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