PDFs - Making PDF copies of Spreadsheets

One of the easiest ways to make a PDF copy of a spreadsheet is to use the Convert EXCEL to PDF function at www.ilovepdf.com

Although www.ilovepdf.com is very easy to use, using it results in your data being processed outside the United Kingdom where different standards of data protection may apply. If you are concerned about this then an alternative method is to use Microsoft Excel to do the conversion as explained below.


1. Open the spreadsheet using Microsoft Excel.

2. Select File – Print to go to the Print dialogue.

 

3. Select a printer of Microsoft Print to PDF or Save to PDF


4. Under Settings, choose Print Entire Workbook if you are creating a single PDF containing all the sheets in the workbook.


5. Choose an Orientation. This will normally be Landscape so as to minimise the page size which is necessary to accommodate all columns on a single sheet.


6. For Scaling, choose Fit All Columns on One Page



7. Click Page Setup and select appropriate options to aid readability. For example, you will nearly always want to select the Print Gridlines and Row and column headings options on the Sheet tab. 


8. Click the Print button and, when prompted, navigate to the appropriate target folder and enter the appropriate new name – e.g.

 

        2011-04-01    Spreadsheet Budget 2011


9. Click Save.


10. Open the PDF file and check that it is correctly formatted and do spot checks on selected pages to ensure that it contains all the data from the spreadsheet.

 

Disclaimer

Every reasonable effort has been made to ensure that the information is accurate and up to date at the time it was written but no responsibility for its accuracy, or for any consequences of relying on it, is assumed by me. You should satisfy yourself, before using any of the techniques, software or services described, that the techniques are appropriate for your purposes and that the software or service is reliable.

This page was lasted updated in November 2016. Disclaimer