Multi-sheet Excel
Combine multiple Excel sheets into a single PDF
A workbook with 6 tabs and 6 different layouts. You need one PDF that flows naturally between them. Here's the manual approach and where it falls short.
Excel's built-in option: Print Active Sheets
File → Print → Print Active Sheets → set to "Entire Workbook". This generates a single PDF with all sheets included in their tab order. The catch: every sheet keeps its own page setup, so if one is landscape and another portrait, the PDF will be mixed.
Pre-export consistency checklist
- Group all sheets (Ctrl+click each tab), then set page setup once, applies to all.
- Set Print Titles per sheet (since they're not shared across the group).
- Add a unified footer with workbook name + sheet name + page numbers.
- Verify each sheet's print area is set correctly, Page Layout → Print Area → Set.
Automated multi-sheet handling
fitforpdf reads multi-sheet XLSX files and produces a single PDF with an overview page listing every sheet and a section per sheet. Each section gets its own sectioning logic based on the sheet's width, so a narrow summary tab stays portrait, a wide detail tab gets sectioned automatically.
Frequently asked questions
How do I export multiple Excel sheets to one PDF?
File → Print → choose "Print Entire Workbook" instead of "Print Active Sheets", then Save as PDF. Make sure every sheet has the same page setup (orientation, margins) for visual consistency.
Why do my multi-sheet PDFs have inconsistent formatting?
Because each sheet has its own page setup. Use sheet grouping (Ctrl+click tabs) to apply settings once, or hard-set Page Layout per tab before exporting.
Does fitforpdf preserve sheet names in the multi-sheet PDF?
Yes, each sheet becomes a section with its tab name as the section title, and the overview page lists every sheet with page references.
Multi-sheet workbook → one structured PDF.
Upload your XLSX (any number of sheets). Get a single PDF with an overview + section per sheet. 3 free exports.
Combine your workbook, free