convert xls pdf
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Convert xls to pdf

Convert xls to pdf

resolvedResolved · Urgent Priority · Version 2007

replyReply Wed 21 Jul 2010, 14:18Delegate Ludovic said...

Ludovic has attended:
Excel Intermediate course

Convert xls to pdf

Hi there,

I need to make sure that a document maintains the same values. In the past, on 2003 xl, I have been able to convert to pdf from the menu at the top of the xl doc. Now I have 2007, and the ribbon only allows me to email as a pdf attachement, or lock the .xls as final. If I lock it as final I believe the links in there are still able to change so I need to convert it to pdf.

Is there a way I can convert to pdf this without sending it as an attachment (just for our own record keeping).

Many thanks

For upcoming training course dates see: Pricing & availability

replyReply Wed 21 Jul 2010, 16:23Trainer Newson said...

RE: Convert xls to pdf

Hi Ludovic


If you go to the Microsoft Office button and move your mouse down to Save As

Another menu will appear opposite allowing you to save the spreadsheet in another format. The second to last option allows you to save a copy of the spreadsheet as a PDF/XPS.

Click on that option and you will be taken to the publish as PDF or XPS dialog box

Two boxes will be displayed on this towards the bottom of this dialog box

File name

Save As type - you need to ensure this states pdf opposite


Click on the publish button and the pdf will be created.

I hope that helps

Thanks

Newson

 

Please browse our web site to find out more about
advanced excel seminar training and other Microsoft training courses.

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard