How to put every Excel sheet on its own page(s) in one PDF

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

The native per-sheet and native-pivot rendering runs on Windows and needs Excel installed (2016+) — no Mac build. The free web converter on the home page runs the same smart engine on our server — your file is converted, then deleted (never stored) — and renders every sheet in order; the per-sheet selection and native-pivot control described here are what the Windows add-in and desktop app add. 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.