[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

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
0
Plunki
Asked:
Plunki
1 Solution
 
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now