Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

convert xls pdf

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

Convert xls to pdf

ResolvedVersion 2007

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

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

RE: Convert xls to pdf

Hi, Hi Ludovic.

As for me, I have seldom tried to convert to pdf from the menu at the top of the xl doc. I wonder have you ever worked it out? Do I need another 3rd party manual toolkit? When it comes to PDF converting process, I have another question, I wonder have you ever tried to convert pdf to other image files before? As for myself, I am testing the related PDF to JPG converting, PDF to PNG converting, and PDF to BMP converting programs these days. Do you have experience about it? Any suggestion will be appreciated. Thanks in advance.



Best regards,
Lee

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.16 secs.