Excel PDF Export Splits One Table Across Pages: Fix

When you export an Excel worksheet to PDF, a single table often breaks across two or more pages. This makes the data hard to read and print. The root cause is that Excel’s default page layout does not match the table dimensions. This article shows you how to prevent table splitting by adjusting page breaks, scaling options, and print area settings.

Why Excel Splits Tables When Exporting to PDF

Excel’s PDF export engine follows the same page layout rules as printing. By default, each page is 8.5 inches wide by 11 inches tall. If your table is wider than 8.5 inches or taller than 11 inches, Excel automatically breaks it at the nearest row or column boundary. The software does not try to shrink the table to fit — it simply splits it. This behavior is controlled by the scaling option under Page Layout. When scaling is set to “No Scaling,” the table keeps its original size and breaks occur. The same happens if the print area includes empty rows or columns that push part of the table to a second page.

Steps to Stop Table Splitting in PDF Export

The following steps apply to Excel for Microsoft 365, Excel 2021, and Excel 2019. The interface is nearly identical in Excel 2016.

1. Select the entire table
   Click any cell inside the table. Press Ctrl+A once to select the data region around the cell. Press Ctrl+A a second time to include the entire worksheet if needed. For a named table, click anywhere in the table and then press Ctrl+A twice.
2. Set the Print Area to the table only
   Go to the Page Layout tab on the ribbon. In the Page Setup group, click Print Area and select Set Print Area. This tells Excel to export only the selected range. Empty rows or columns outside the table will not cause splitting.
3. Open Page Setup dialog
   On the Page Layout tab, click the small arrow icon at the bottom-right corner of the Page Setup group. The Page Setup dialog opens.
4. Adjust scaling to fit the table on one page
   In the Page Setup dialog, go to the Page tab. Under Scaling, select Fit to. Enter 1 page wide and 1 page tall. This forces Excel to shrink the table proportionally so it fits on a single PDF page. Click OK.
5. Check page breaks in Page Break Preview
   Go to the View tab and click Page Break Preview. Blue dashed lines show where Excel will break pages. If the table still spans multiple pages, drag the dashed line to the right or bottom edge of the table. This manually adjusts the page break.
6. Insert manual page breaks if needed
   If the table is too large to fit on one page even after scaling, you can keep the table together by inserting a page break before the table. Click the row above the table. Go to Page Layout > Breaks > Insert Page Break. The table now starts on a new page and will not be split mid-table.
7. Export to PDF
   Go to File > Save As (or Save a Copy in newer Excel versions). Choose PDF from the file type dropdown. Click Options. In the PDF Options dialog, under Publish what, select Active sheet(s). Check the box for Fit to paper size. Click OK, then Save.

If the Table Still Splits After Scaling

Table width exceeds page width even at minimum scale

Excel’s scaling minimum is 10 percent of the original size. If the table is extremely wide, even 10 percent may not fit on one page. In that case, change the page orientation to Landscape. Go to Page Layout > Orientation > Landscape. This gives you 11 inches of width instead of 8.5 inches. Then repeat the scaling steps.

Table has merged cells that cause unpredictable breaks

Merged cells can confuse Excel’s page break logic. Unmerge any merged cells in the table. Select the merged area, go to Home > Merge & Center and click Unmerge Cells. Then reapply the print area and scaling.

PDF export adds a gap or extra blank page

This often happens when there is a manual page break or empty rows below the table. Remove all manual page breaks by going to Page Layout > Breaks > Reset All Page Breaks. Then set the print area again to cover only the table rows.

Fit to One Page vs Manual Page Breaks: Key Differences

Item	Fit to One Page (Scaling)	Manual Page Breaks
Description	Shrinks the table to fit within one page	Inserts a break before the table so it starts on a new page
Effect on table size	Reduces font and column width proportionally	Keeps original table size; table may still split if too tall
Best for	Wide tables that barely exceed one page	Tall tables where you need the table to start at the top of a page
Limitation	Text may become too small to read below 50% scale	Does not prevent splitting if the table is taller than one page

You can now export any Excel table as a single-page PDF without unwanted splits. Start by setting the print area to the table range. Then apply scaling or manual page breaks depending on the table size. For wide tables, use Landscape orientation before scaling. As an advanced tip, create a named range for the table and reference it in the Print Area setting — this makes future exports faster because you do not need to reselect the table each time.