Plunki
asked on
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
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
Any chance you could post a copy of the xls file with some data changed for security, for me to test with? Thanks
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...
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...
check out the "Paper Size" while printing a pdf, i guess that should solve your issue.
Tils
Tils
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!)
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!)
i have been using dopdf past 4 yrs and it has never disappointed me......
=)
Cheers,
Tils.
=)
Cheers,
Tils.