How to Export Excel Spreadsheets to PDF Without Tables Getting Cut Off

You export an Excel spreadsheet to PDF, open it up — and the table is sliced across three pages, with the right-hand columns banished to a separate sheet. On screen everything looked fine. Sound familiar? The issue is that Excel's default print settings use actual size on portrait A4, so any table wider than the page gets cut. In this guide you'll learn five Page Layout settings that produce a clean, uncut PDF every time.

Why does Excel cut tables when saving as PDF?

Excel's default print configuration is portrait A4 at 100% scale. The application doesn't know which cells you actually want — it just starts printing from A1 and breaks the page wherever the paper edge falls. If your table has more columns than fit in ~19 cm (portrait A4 printable width), the overflow wraps to the next page. Rows that exceed one page height spill downward in the same way.

The fix is to tell Excel exactly what to print and how to scale it. All five settings live under the Page Layout tab.

Step-by-step: fitting the table on one page

1. Set the print area — select only the data you need
   Drag to select the cells you want in the PDF, then go to Page Layout → Print Area → Set Print Area. Excluding empty rows and columns avoids unnecessary whitespace that can push your table onto extra pages.
2. Fit width to 1 page
   In the Page Layout → Scale to Fit group, set Width to "1 page" and leave Height on "Automatic". Excel will shrink columns proportionally so everything fits horizontally. If rows are few enough, this alone may give you a single-page PDF. Avoid setting both Width and Height to 1 page if you have many rows — the text can become unreadably small.
3. Switch to landscape orientation
   Go to Page Layout → Orientation → Landscape. Landscape A4 is roughly 297 mm wide versus 210 mm for portrait — about 40% more printable width — so more columns fit without scaling down.
4. Check Page Break Preview
   Go to View → Page Break Preview. Solid blue lines are fixed page breaks; dashed blue lines are automatic ones. Drag a dashed line to reposition it manually. When you're done, return to View → Normal.
5. Repeat header rows on every page
   If the table spans multiple pages, readers on page 2+ won't see the column headers. Fix this at Page Layout → Print Titles → Rows to repeat at top and enter your header row (e.g. $1:$1). Excel will stamp it at the top of every printed page automatically.

Orientation and title tips at a glance

Saving as PDF

Once the layout is set, you have two options.

Option 1 — Export directly from Excel

Go to File → Export → Create PDF/XPS Document. In the publish options dialog, confirm that "Print Area" is selected, then save. Alternatively, use File → Save As (F12) and choose PDF as the file type. Either route applies your Page Layout settings to the output.

Option 2 — FreeSign online converter

If you don't have Excel installed, or you're on a shared computer, upload the .xls or .xlsx file to FreeSign PDF converter. No account or installation required — the file is converted and ready to download within seconds.

Related tools

Need to go the other way? FreeSign PDF → Excel extracts table data from a PDF back into an editable .xlsx file. If you also work with Word documents, Word → PDF handles .doc and .docx files with the same drag-and-drop simplicity.

Frequently asked questions

Q. Won't "Fit to 1 page wide" make the text too small to read?
It depends on how many columns you have. Fitting only the width (leaving height on Automatic) minimises shrinkage. If the result is still too small, try landscape orientation first — that often resolves the problem without any scaling. You can also manually narrow a few wide columns before exporting.

Q. Does this work in Excel for Mac?
Yes. The menu names and locations are essentially the same: Page Layout tab → Scale to Fit → Width: 1 page. Some option labels may appear in English depending on your version, but the workflow is identical.

Q. Can I do the same thing in Google Sheets?
Yes. In Google Sheets go to File → Print. The right-hand panel lets you choose paper orientation and a scaling option such as "Fit to page" or "Fit to width". The underlying principle is the same as in Excel.

Q. Will FreeSign preserve my table formatting — colours, borders, fonts?
Most formatting is retained: cell background colours, borders, and fonts. Macros and VBA code are not carried into a PDF (by design), and complex conditional formatting may occasionally render differently.