convert xls pdf

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

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

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:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips


Server loaded in 0.19 secs.