How to convert Excel to PDF and fit to page

I am using acrobat 8 and excel 2002 SP3 on Windows XP.

Attached are two PDF files of one of my excel sheets (removed all data, only left borders). The first is a scan of my printer output with the correct output. The second is the squished output I get when I go to  File > Print and print to the adobe PDF printer.

Why does printing as PDF change the ratio of height to width? It should just fill the page and create the same (or at least very similar) sized output to the regular printer.

I have tried for several hours every possible combination of options on the PDF printer, the excel margins, excel page setup, fit to page or adjust to % options. I have tried numerous other free PDF software (PDF995, PDFCreator, AlltoPDF, etc). Nothing works. I have never been this boggled by a computer problem.

I'm hoping someone has seen something similar to this and knows what to do to get the proper output.


Scan-of-printer-output.PDF
PDF-output-incorrect.pdf
PlunkiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

richardcardinCommented:
Any chance you could post a copy of the xls file with some data changed for security, for me to test with? Thanks
0
drewha1969Commented:
OK, this may not be the best answer as related to excel, but, you can export to pdf in OpenOffice.

To try, you would just need to install OpenOffice, open your spreadsheet and
file->export as pdf.

Just a thought if nobody else can get something to work in excel...
0
tilsantCommented:
check out the "Paper Size" while printing a pdf, i guess that should solve your issue.


Tils
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

PlunkiAuthor Commented:
richardcardin:
Here is the excel file. I have removed all of the sheets except the example one I posted earlier.

drewha1969: I will give open office a shot it is downloading right now!

tilsant: paper size is set to letter. I have tried fooling with all the settings, changing DPI settings, paper sizes, you name it, no luck! :)
blank.xls
0
tilsantCommented:
its kinda coming ok in my case here.
Im using dopdf (http://www.dopdf.com/download.php).


blank.pdf
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PlunkiAuthor Commented:
tilsant:

THANK YOU
THIS WORKS PERFECTLY!!!

I did not think I would find such an easy solution...

I tried the following PDF creators:
- Regular Acrobat 8 Adobe PDF
- AlltoPDF
- PDF995
- PDF Creator

 don't know why they all failed and this DoPDF worked!!! (first time, no config required!)
0
tilsantCommented:
i have been using dopdf past 4 yrs and it has never disappointed me......
=)


Cheers,
Tils.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Acrobat

From novice to tech pro — start learning today.