How to export an Excel spreadsheet to a clean PDF
A spreadsheet printed straight to PDF often splits columns across pages. This guide prepares the sheet, converts the workbook and finishes the PDF with page numbers and a smaller size.
The converter follows the print settings saved in the workbook. It has no options of its own, so the layout is decided in the spreadsheet.
Step by step
Set the print area
In your spreadsheet program, select the area you want and set it as the print area. Choose fit to one page wide, so no column spills onto the next page.
Convert the workbook
Open the Excel to PDF tool and choose an XLSX, XLS or ODS file. All sheets are converted, each following its saved print setup.
Check the pages
Open the PDF and look for cut columns. If any spill over, go back to the spreadsheet, adjust the settings and convert again.
Add page numbers
Open the page numbers tool and use a format like Page {page} of {total} so readers can refer to a page.
Shrink the file
Run the compress tool if the PDF is too large for email. Balanced is a good start.
Tools used in this guide
Questions about this task
- Why are my columns cut off?
- The saved print setup lets them run past the page width. Set fit to one page wide in the spreadsheet and convert again.
- Are all sheets converted?
- Yes, every sheet in the workbook is included.
- Is my file uploaded?
- The conversion runs on a secure server. The file is sent once over an encrypted connection and deleted after the result is sent.
PDF terms explained
- Print areaA print area is the range of cells a spreadsheet sends to the printer or to a PDF. Learn how page breaks, scaling and hidden columns decide what appears on each page.
- Page breaksA page break marks where one page ends and the next begins. Learn how breaks are decided when Word, spreadsheet and web files become PDF, why tables and headings get cut in the wrong place and how to fix it.
- Workbook sheetsA workbook is a spreadsheet file made of several sheets. Learn how sheets, print areas and page breaks decide what a PDF contains, and how tables from a PDF come back as one sheet per page.
- Ledger exportA ledger export is a list of accounting entries taken out of your software. Learn how to turn it into a tidy, numbered PDF for an accountant or a file.
- Price listA price list sets out what each product or service costs and on which terms. Learn how to turn a spreadsheet into a tidy PDF that you can share with confidence.
- Size chartA size chart lists the measurements of a garment in each size. Learn how it is used with factories and shoppers, and how to share it as a clear numbered PDF.
- Cargo manifestA cargo manifest lists all the cargo carried on a vessel for one voyage. See what it contains and how to prepare a long manifest as one numbered PDF.
- Membership rollA membership roll is a congregation's list of its members and the dates they joined. See what it holds and how to assemble a long roll as one numbered PDF.
- Finish scheduleA finish schedule lists the materials and finishes for each room of a building. Learn what it contains and how to prepare and share it as a PDF.