Short answer: to get one combined PDF where each sheet starts on its own page, group all the sheet tabs before you export so Excel treats them as one job but paginates each separately — or use a tool that renders each sheet as its own section and stitches them in order. CrazySmartPDF renders per sheet and lets you pick which sheets go in and how each one prints.
Doing it by hand in Excel
- Group the sheets: click the first sheet tab, then Ctrl-click (or Shift-click) the others so several tabs are selected at once.
- File → Print → Print Entire Workbook → Save as PDF, or File → Save As → PDF → Options… → Publish: Entire workbook. Each sheet paginates on its own — sheets don’t get mashed together onto one page.
- Remember to ungroup afterwards (right-click a tab → Ungroup Sheets), or edits you make will apply to all of them.
The honest catch: grouping is finicky and easy to forget to undo, and it doesn’t fix layout — a wide sheet still cuts off and a tall one still splits rows within its own section.
How CrazySmartPDF handles it
Per-sheet handling is the default, not a workaround:
- You choose which sheets render and in what order — one sheet, several, or the whole workbook. Each sheet becomes its own section (its own page, or pages if it’s long), paginated with row-atomic breaks and repeating headers.
- Mix engines per sheet: mark specific sheets — a cover, a pivot — to print through Excel natively instead of the smart layout engine, so their rendering is exact. Pivot tables are detected and sent native automatically. Paper size, margins, and orientation are adjustable for the run.
The honest caveats
Renders through your installed Excel on Windows (2016+); no Mac or purely-online path today (the browser upload surface is a separate beta). Which sheets are “smart” versus “native” is a list you control — the shipping defaults reflect the billing workbook the engine grew up on, so you’ll want to point it at your own sheet names. Your original workbook is only ever read, never changed.