A multi-sheet Excel workbook prints to PDF and comes out with each worksheet producing pages of slightly different dimensions. Page three is a fraction of an inch wider than page two. Page seven has margins that do not match page five. Scrolling through the PDF, the page boundaries visibly jump from one sheet to the next. This happens because Excel assigns page size and margin settings independently to each worksheet, and those settings often drift apart during the workbook's life as different people edit different sheets. Understanding why the mismatched page sizes occur is the first step toward fixing the Excel to PDF output.
How Excel Determines Page Size for Each Worksheet
Every Excel worksheet maintains its own page setup configuration, stored separately from the cell data. This configuration includes the paper size, the orientation, the margin widths, the header and footer content, and the print area definition. When you print or export to PDF, Excel processes each worksheet independently and applies its own page setup. If Sheet1 is configured for Letter size with narrow margins and Sheet2 is configured for A4 with wide margins, the resulting PDF will contain a mix of page dimensions.
The page setup for each sheet is not visible in the normal cell grid view. You need to switch to Page Layout view or open the Page Setup dialog to see the current settings. This invisibility is why mismatched PDF Page Size settings often go unnoticed until the PDF is generated and someone notices the jumping page boundaries. A workbook that has been passed between colleagues in different countries is particularly vulnerable because one person may have set their sheets to A4 while another used Letter.
Checking and Standardizing Page Setup Across All Sheets
The most reliable way to identify mismatched page settings is to check each sheet individually before exporting. Right-click any sheet tab and choose Select All Sheets. This groups all sheets together so that any page setup change you make applies to every sheet simultaneously. With all sheets selected, open the Page Layout tab on the ribbon. Click the Size dropdown and confirm that all sheets use the same paper size. Click the Orientation dropdown and set all sheets to either Portrait or Landscape consistently. Click Margins and select the same margin preset for every sheet.
After standardizing the page setup with all sheets grouped, ungroup them by right-clicking a sheet tab and choosing Ungroup Sheets. Then scroll through each sheet in Page Layout view to visually confirm that the page breaks and margins look consistent. Pay particular attention to sheets with wide tables that may have been set to Landscape while the rest of the workbook uses Portrait. These intentional orientation differences are valid, but they will produce different page dimensions in the PDF output. If a consistent page size is more important than the optimal orientation for each sheet, standardize the orientation as well.
Using the Scaling Options to Fit Content to a Uniform Page
Standardizing the paper size and margins does not guarantee that the content will fit cleanly on each page. A wide table that previously printed across two sheets in Landscape orientation may now overflow the page boundaries in Portrait mode. Use the scaling options in the Page Setup dialog to adjust how each sheet's content maps to the standardized page. The Fit to option scales the entire sheet to fit within a specified number of pages wide by a specified number of pages tall.
Setting Fit to 1 page wide by leaving the tall field blank tells Excel to scale the width to fit a single page while allowing the height to expand across as many pages as needed. This prevents the common PDF Printing issue where a table with one extra column produces a mostly blank second page with a single narrow column of data. If the scaled text becomes too small to read, adjust the print area to exclude non-essential columns or set the scaling to a minimum readable percentage rather than forcing the entire sheet onto one page.
Setting the Print Area for Each Sheet
An undefined or inconsistent print area is another common source of unexpected page size variation. If one sheet has a defined print area of A1 through K45 and another sheet has no print area defined, Excel prints the entire used range of the second sheet, which may extend far beyond what you intended to include. Before exporting to PDF, set the print area for every sheet. Select the cells that should appear in the output, click the Page Layout tab, and choose Print Area, then Set Print Area.
After setting print areas on all sheets, use the Print Preview screen to verify each sheet's output before committing to PDF. The preview shows exactly what will appear in the PDF, including any page breaks that split tables across sheets. Resolve any awkward page breaks by adjusting row heights, column widths, or the print area boundaries. The extra minutes spent in Print Preview save the frustration of generating a PDF, discovering the layout problems, fixing them, and regenerating the file.
Exporting to PDF with Consistent Settings
With all sheets configured to the same page size, orientation, margins, and print area, export the workbook to PDF. In Excel, go to File, then Export, and choose Create PDF. In the export options dialog, under Publish what, select Entire Workbook rather than Active Sheets. This ensures all sheets are included. Click the Options button and verify that the publish settings match your standardization choices. Check that Document properties and Document structure tags for accessibility are enabled if the PDF will be distributed broadly.
After the PDF is generated, open it and scroll through every page. The page dimensions should now be consistent from sheet to sheet. If any sheet still produces different page dimensions, return to that sheet in Excel and check its individual page setup, which may have been excluded from the group selection if it was hidden or protected. WukongPDF can compress or merge the final PDF if the file size from a multi-sheet workbook exceeds email attachment limits, but standardizing the Excel page setup before export remains the most effective way to prevent mismatched page sizes.
Dealing with Excel Workbooks Created on Different Operating Systems
Excel workbooks edited on both Windows and Mac computers are especially prone to page size inconsistencies because the two operating systems use different default paper sizes and printer drivers. Windows defaults to the Letter paper size of 8.5 by 11 inches. macOS defaults to US Letter as well, but the printer subsystem on Mac maps page dimensions through the CUPS printing system, which may interpret margins and scaling slightly differently than the Windows GDI printing subsystem.
These operating system differences can produce page size variations of a few tenths of an inch, which are subtle enough to go unnoticed on screen but obvious when the printed pages are stacked together or when the PDF is viewed in a two-page spread where facing pages should align perfectly. When a workbook will be edited on multiple operating systems before PDF export, designate one system as the final export machine and perform all page setup standardization on that machine before creating the PDF.
Before the final export, use WukongPDF to merge any supplementary pages or to compress the output if the multi-sheet PDF exceeds email attachment limits. Standardizing the Excel page setup prevents the mismatched sizes, and a dedicated PDF tool handles the post-export file management.
Hidden rows and columns in Excel can cause unexpected page size behavior in PDF output. If a worksheet contains hidden columns that extend beyond the visible print area, Excel may include the hidden content in its page width calculation. Before exporting, unhide all rows and columns temporarily to see the full extent of the data, then either delete the hidden content or adjust the print area to explicitly exclude it.
The printer driver selected in Excel can affect PDF page dimensions because Excel queries the printer for its supported paper sizes and default margins. If the selected printer is a physical device with non-standard paper handling, the PDF output may inherit unexpected page size settings. For consistent PDF output, set the default printer to Microsoft Print to PDF before opening the Excel file.
Excel for Mac and Excel for Windows handle certain page setup features differently, particularly headers and footers that include graphics. A worksheet with a company logo in the header may render at slightly different dimensions on each operating system because the image scaling algorithms differ. If the workbook will be exported to PDF on both platforms, test the output on each and identify which platform produces the preferred result for the final distribution copy.
When distributing the PDF to recipients who may print it on different paper sizes than you used for export, include a note in the email or document header indicating the intended paper size. A PDF formatted for A4 paper that is printed on Letter by a recipient in North America may have slightly cropped margins. Setting the PDF page size to match the most common paper size among your recipients minimizes this issue.