Excel to PDF
Convert Excel files to PDF while preserving the formatting.
Why spreadsheets get cut off
A spreadsheet doesn't have "pages"—it's a grid that can contain hundreds of columns. When you create a PDF, Excel divides the grid across pages based on the file's page setup. If the columns are wider than the page, they spill onto additional pages, splitting the table across the PDF: the first columns might appear on pages 1, 2, and 3, and the rest on pages 4, 5, and 6.
The fix is always the same: tell Excel how to fit the spreadsheet on the page before creating the PDF.
In Excel: three settings fix most issues
- Switch to landscape orientation. On the Page Layout tab, click Orientation › Landscape. A page turned sideways can fit many more columns.
- Fit the columns to one page. Still on the Page Layout tab, under Scale to Fit, set Width: 1 page and leave Height: Automatic. This fits all columns across the page while allowing rows to continue onto following pages.
- Set the print area. Select only the range you need, then choose Print Area › Set Print Area. This keeps helper columns and forgotten cells far off to the side out of your PDF.
Check the result in File › Print, where you'll see a preview. Then save as a PDF using File › Save As (or Export) › PDF.
Other useful Excel options
- Page Break Preview (View tab): shows the blue lines that separate pages. Drag them to choose where each page ends.
- Print Titles (Page Layout): repeats the header row at the top of every page, so readers know what each column means on page 3.
- Narrow margins: Go to Page Layout › Margins to gain a little extra width.
- Center on page: In Page Setup › Margins, select Center horizontally so the table isn’t stuck to the left.
In Google Sheets and LibreOffice
- Google Sheets: Go to File › Download › PDF. A settings screen will open: choose Landscape, select Fit to width under Scale, and export only the current selection if you want. Click Export.
- LibreOffice Calc: Go to Format › Page (or Page Style), open the Sheet tab, and select the scale mode Fit print range(s) to width/height with the width set to 1. Then go to File › Export as PDF.
Convert without Excel installed
If you don’t have Excel on your device, Excel to PDF converts .xlsx, .xls, .ods, or .csv files. The conversion runs on a server using LibreOffice: your file is uploaded over an encrypted connection and deleted shortly afterward. Since converters use the page settings saved in the spreadsheet, it’s best to adjust the orientation and scaling in the file first—even if you use a spreadsheet app on your phone.
If your PDF has pages in unusual sizes, Resize PDF to A4 standardizes the pages without distorting the content. If a page is landscape when it should be portrait (or vice versa), fix it with Rotate PDF.
When the spreadsheet is too large for one page
Forcing a 40-column spreadsheet onto an A4 page makes the text unreadable. In that case, consider:
- Hide columns readers don’t need (right-click the column header › Hide).
- Split the data into two tables with different topics.
- Use A3 paper if the PDF will be printed at a print shop.
- Include the original spreadsheet for anyone who needs the details.
Frequently asked questions
I set it to fit on one page, but now everything is tiny. What should I do?
Set the width to 1 page and leave the height automatic. Fitting both the width and height at the same time squeezes the entire spreadsheet onto one page. If it’s still too small, hide columns or switch to landscape.
Why are there blank pages at the end of the PDF?
There are probably formatted cells or spaces farther down or to the right. Set the print area to include only the table range.
How do I repeat the header on every PDF page?
In Excel, go to Page Layout › Print Titles and specify the header row under Rows to repeat at top.
Can I save multiple tabs in the same PDF?
Yes. In Excel, go to File › Print and select Print Entire Workbook before saving as a PDF. Each tab uses its own page settings.