How to Convert an Excel Spreadsheet to PDF
The classic mistake when saving a spreadsheet as PDF is letting a wide sheet spill across a dozen pages. The fix is to treat the conversion as a print layout, not a data dump.
Spreadsheets are boundless grids; PDF pages are fixed rectangles. Converting one to the other without preparation produces the familiar mess of columns marching off the right edge onto page after page, with headers stranded away from their data. A little print setup turns that into a clean, professional PDF.
This guide covers the settings that make a spreadsheet fit the page and stay readable.
Set the print area first
Excel will try to export everything, including stray content far off to the side and empty columns you forgot about. Define the print area to exactly the range you want in the PDF, so the export includes your table and nothing else. This alone eliminates most surprise pages.
While you are there, decide orientation. Wide tables usually belong in landscape; tall, narrow ones in portrait. Choosing the right orientation before scaling reduces how much you have to shrink the content.
Scale to fit the page
- Fit to width. Set the sheet to fit all columns on one page wide, so no column spills onto a separate page. This is the setting that fixes the most common complaint.
- Repeat header rows. Configure the header row to print on every page, so a multi-page table stays readable rather than leaving later pages headerless.
- Adjust margins. Narrow margins buy room for more columns before Excel shrinks the text too far.
- Check the preview. Use print preview to confirm the layout before exporting; it shows exactly where the page breaks land.
Make the output readable and complete
After setting fit-to-width, glance at the resulting text size. If fitting everything onto one page wide has shrunk the numbers to an unreadable size, the table is genuinely too wide for one page; split it into logical sections, each on its own page, rather than shipping something no one can read.
Decide what else belongs in the PDF: gridlines can aid readability for dense tables, and headers and footers can carry a title, date, and page numbers. Confirm that formulas show their results, not the formula text, and that any cells set to hide overflow are not silently cutting off content.
Doing it in Atlas
The Atlas PDF studio produces clean PDFs from spreadsheet content with the page layout under your control, so tables fit the page and headers stay with their data. Because the PDF can be attached to the report, deal, or project the numbers came from, turning a working sheet into a shareable document keeps it in context. More at /all-in-one.