Solved

Create a pdf from xls file

Posted on 2014-04-25
4
290 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
  • 2
4 Comments
 
LVL 9

Expert Comment

by:Red-King
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you
I had not selected print, I had selected Save as PDF
0
 

Author Closing Comment

by:johnhardy
Comment Utility
Many thanks I used Cute ftp and it works very well.

Regards

John
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now