To save Excel as PDF without cutting off columns, set the sheet to landscape, choose the scaling option that fits all columns on one page, and check the print preview before you export. That is the core of any Excel to PDF fit to page fix. Once the PDF looks right, you can join it with other files using Merge PDF or shrink it for sending.
The problem usually is not the PDF export itself. Excel prints by pages, and if your sheet is wider than one page, the extra columns move to a second or third page. The PDF simply copies that page layout. So the fix happens inside Excel, before you save.
Why Excel cuts columns when you save as PDF
A spreadsheet has no natural page size. It can be 30 columns wide and 2,000 rows long. When you save it as a PDF, Excel has to split that grid into paper-sized pages, using the paper size, orientation, margins and scaling in the page setup.
With default settings (portrait, 100% scale, normal margins) only a few columns fit across. Everything to the right goes onto later pages. The result is a PDF where columns A to F sit on page 1 and the totals in column M sit alone on page 4, which is hard to read and easy to miss.
Other common causes:
- A wrong print area. If a print area was set earlier, Excel only exports that range, so new columns are left out completely.
- Hidden manual page breaks. Someone may have inserted a break that forces columns onto a new page.
- Very wide columns or merged cells. A single wide notes column can push everything else off the page.
Excel to PDF fit to page: step by step
Menu names differ a little between Windows, Mac and the web version, but these settings exist in all of them, in the page layout or print settings area.
- Open page break preview. Switch to the page break view so you can see blue lines showing where each page ends.
- Set the print area. Select the exact range you want in the PDF and set it as the print area. If an old print area exists, clear it first.
- Change orientation to landscape. Wide tables almost always look better in landscape. This alone often fixes small overflow problems.
- Choose fit-to-page scaling. In the scaling options, pick the one that fits all columns on one page wide. Leave the height automatic so long tables can still flow over several pages.
- Reduce margins. Narrow margins give you extra width without shrinking the text further.
- Repeat header rows. If the table runs over several pages, set the top row to print on every page, so readers know what each column means.
- Check print preview. Scroll through every page. Make sure the text is still readable, not tiny.
- Save or export as PDF. Use Save As or Export and choose PDF. Choose whether to save the active sheet, a selection or the whole workbook.
If your workbook has several sheets that each need different settings, set up each sheet separately. Then export them one by one and combine the files later with the PDFNova merge tool, where you can drag them into the right order.
Which scaling option should you choose?
Fitting everything on one page is not always the best idea. A 25-column sheet squeezed onto one A4 page can end up with text too small to read. Use this table to pick a setting.
| Your sheet | Best setting | Why |
|---|---|---|
| Up to about 10 columns | Portrait, fit all columns on one page | Text stays readable and pages stay normal. |
| 10 to 20 columns | Landscape, fit all columns on one page | Landscape gives more width so scaling is mild. |
| Very wide, 20+ columns | Landscape, larger paper size or hide unneeded columns | Shrinking too much makes numbers unreadable. |
| Small summary table | Fit sheet on one page | Whole table on a single page, easy to share. |
| Long list, few columns | Fit all columns, rows automatic, repeat header row | Avoids tiny text while keeping columns together. |
Troubleshooting cut-off columns
The PDF still shows only part of the sheet
An old print area is the usual cause. Clear the print area, then set it again for the full range you want.
The text is now too small to read
Switch to landscape, reduce margins, narrow very wide columns, hide helper columns the reader does not need, and wrap long text in cells. If it is still too small, split the table into two logical parts, for example by month or region.
There are blank pages in the PDF
Formatting or borders in empty cells far from your data can make Excel think the sheet is larger. Set a print area tightly around the real data. You can also remove stray blank pages afterwards with Delete Pages.
Each sheet came out as a separate file
That is fine. Put the files into Merge PDF, sort or drag them into order, and download one combined file.
After export: merge, shrink and finish the PDF
Many Excel PDFs are part of a larger pack: a report with a cover letter, an invoice with a statement, or a budget with supporting slides. If you also have a presentation in the pack, our guide on how to save a PowerPoint as PDF, with or without notes covers that part.
Spreadsheet PDFs with only text and numbers are usually small already. If your workbook includes charts, logos or pasted images, the file can get larger. Compress PDF lets you move a slider, compare the before and after size, and preview the result before downloading. Text-only PDFs shrink very little, because compression mainly reduces image quality.
For a long report, adding page numbers such as “Page 1 of 12” helps readers find their place. PDFNova processes files in your browser, so your documents are not uploaded to a server, which matters when the spreadsheet holds salaries or customer data.
Supporting documents often come from other sources too. If you need to add receipts or photos sent by colleagues, see how to convert WhatsApp images to PDF. For identity documents in an application pack, read how to scan a passport to PDF for online applications.
Quick checklist before you send
- Every column you need appears in the PDF, including the last one.
- Text and numbers are readable on a phone screen when zoomed.
- Header row repeats on every page of a long table.
- No blank or half-empty pages at the end.
- Sheets are in the right order if you merged several files.
- File size fits the limit shown on the upload page or email service you use.
Frequently asked questions
How do I fit all columns on one page in Excel PDF?
Use landscape orientation and choose the scaling option that fits all columns on one page, with rows left automatic. Check the print preview, then save as PDF.
Why is my Excel PDF printing on multiple pages?
Your sheet is wider or longer than one page at the current scale, or there are manual page breaks. Page break preview shows exactly where Excel splits the pages.
Can I save multiple Excel sheets into one PDF?
Excel can export the whole workbook, but each sheet keeps its own page setup. For full control, export each sheet separately and combine them with a merge tool.
Does PDFNova convert Excel to PDF directly?
Not yet. Use the Save as PDF or Export option inside Excel, then use PDFNova to merge, compress, number or protect the result.
Once your sheet exports cleanly with every column in place, bring all your files together with Merge PDF and send one tidy document. It is free, needs no sign-up and adds no watermark.