Guide

Excel to PDF: How to Get Each Worksheet on Its Own Page

If your Excel file has multiple worksheets and the PDF is coming out with missing sheets or wrong page breaks, the print settings are usually the cause. Here's how to fix it.

Check what "Print" is set to in Excel

In Excel, go to File > Print. The settings panel shows what will be printed. By default, Excel prints only the active sheet (the one you've selected). If you have multiple worksheets and want all of them in the PDF, you need to change this setting. Click the "No sheets selected" dropdown (or similar) and choose "Entire workbook". This tells Excel to print all worksheets, each as its own section.

Set the page layout for each worksheet

Each worksheet can have its own page size, orientation, and margins. If one sheet is in landscape and another in portrait, they will appear as separate pages in the PDF. To check, select each sheet and go to Layout > Page Setup. Make sure the settings match what you want in the final PDF. If one sheet is set to "Fit to page" and another isn't, the page scaling will differ between sheets.

Watch for hidden rows and columns

Hidden rows and columns still print in Excel unless you tell them not to. If your PDF is showing columns that you thought were hidden, check that you've actually hidden them (right-click > Hide) and haven't just set the column width to zero. To print without hidden content, use the "Print" settings to check "Ignore print area" and verify which rows/columns will actually appear.

Use the browser-based converter for consistent results

Browser-based Excel-to-PDF conversion renders each worksheet independently, using professional document rendering that produces consistent output regardless of local Excel version or settings. Each worksheet becomes a separate page in the PDF. No uploads the file stays in your browser.

Convert Excel to PDF

Written by

Emre Polat

Founder of PDFtopia · Istanbul, Türkiye

I write everything you read on this blog. I run PDFtopia on my own and use these tools every day for client work, contracts, and print prep. If a guide misses something or a tool falls short, send me an email.