Export or print multiple sheets
Want a single document exported or printed from multiple sheets? Here's how to get consistent page numbering.This tip helps you produce professional-looking PDF files and printouts.
The Quick Tip shows how to get page numbering right when exporting multiple sheets.
The Bonus Tip lets you export a subset of worksheets or charts while keeping consistent numbering.
Extending this tip using the Expert Tip shows you how to include a non-numbered page such as an index or contents page.
We hope you find these tips useful.
Excel Quicker!
How to make a single PDF or print from multiple sheets
When you need to print or export several sheets or a whole workbook, it can be tricky to get the page numbers to look right. Here’s how to do it:
Time needed: 2 minutes
How to print or export multiple worksheets to PDF:
- Add the page number to the header or footer
Ensure it will update automatically.
(For example, you might use a common “Page X of Y” format). - Select all the sheets you want to print
Hold [Ctrl] or [Shift] to select multiple tabs.
(This can include worksheets and/or charts). - Print or export as normal
You can still preview first.
Let’s examine the first step in more detail.
Add the page number to the header or footer
In the Page Setup dialog, click the “Header/Footer” tab.
You can then select “Page 1 of ?” from the dropdown list of presets for either the header or footer.
To customize the page numbers further, click “Customize Header” or “Customize Footer”.
The syntax to get the above page number format in the customize dialog is:
Page &[Page] of &[Pages]
Where:
&[Page]
represents the page number of the current page; and
&[Pages]
represents the total page numbers in the print or export.
You can reach the Page Setup dialog from the Page Layout tab of the ribbon toolbar.
How to make the page numbers look correct
The trick with page numbers is to make sure you select all of the relevant sheets before you print or export.
If you just try one sheet at a time, then a page number format “Page X of Y” will always show the Y value the same as the X value.
After you print or export, don’t forget to select just a single sheet again. Otherwise any changes you make will apply to all selected sheets, which can ruin your workbook if done accidentally!
Don’t have a login?
Get a login for free on our standard plan, and get a new tip each week.
All logins also get access to the bonus tip each week.
Get even more
Get even more with one of our reasonably priced paid plans, with access to features like:
- Quicksheet PDF summaries
- Example files
- VBA syntax
- Additional expert tips each week
- Advance publication
View our plans to see what else you are missing, or join for free on our Standard plan.
Delayed schedule
This tip is on the Delayed Schedule. It works just like normal, but it’s old news.
To view the current Tip of the week, log in with an account that has access to our Advance Publication schedule.
Don’t have a login?
For more information about publication schedules and access to tips, see our plans.