Solved

Create a pdf from xls file

Posted on 2014-04-25
4
297 Views
Last Modified: 2014-04-25
Hello
I have an excel file and I wish to convert this to a pdf file.
I am using office 2007.
In Office 2007 when I Save As pdf, the file is saved as three separate portrait pages and I would like it to show as one horizontal page as the original xls file.

Can anyone say how this can be carried out please?

Many thanks
John
0
Comment
Question by:johnhardy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 9

Expert Comment

by:Red-King
ID: 40022370
Am I right to assume what you are trying to print is all in one Excel sheet?
Go into Page setup and set the orientation to Landscape.
Under Scaling choose the "Fit to:" option and set it to "1 pages wide by 1 pages tall".

Now try saving as a PDF again.
0
 
LVL 14

Accepted Solution

by:
BlueCompute earned 500 total points
ID: 40022429
If you are unable to get the desired formatting using Excel's Save As > PDF, you may wish to try using one of the free PDF converters, such as:
PrimoPDF
CutePDF

These install as a virtual printer in Windows, so to create the PDF you just go to File > Print in Excel and print to the PDF Printer created by the converter.  You'll then get a dialogue box where you can adjust the parameters for the PDF creation.
0
 

Author Comment

by:johnhardy
ID: 40022451
Thank you
I had not selected print, I had selected Save as PDF
0
 

Author Closing Comment

by:johnhardy
ID: 40022491
Many thanks I used Cute ftp and it works very well.

Regards

John
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question