Print consecutive page numbers across multiple worksheets
This article explains how to print multiple worksheets so the page numbers are in sequence across all selected worksheets.
Instructions:
- Go to tab "Insert" on the ribbon
- Click "Header and Footer" button
- Click "Go to Footer" button
- Click "Page number" button
- Repeat step 1 to 4 for each sheet
- Select the first sheet
- Hold "Ctrl" key and select the second sheet
- Go to "print preview"
- Check that page numbers are ok in preview window
- Click Print button
Weekly Blog EMAIL
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
This article describes how to create a button and place it on an Excel worksheet then assign a macro to […]
Print screen the entire worksheet
I recently discovered something quite useful. Allow me to explain, sometimes you need to take a screenshot of your worksheet […]
Remove print preview lines (Page Breaks)
Have you ever wondered how these lines got there on a worksheet? They show where pages will break, in other […]
Repeat headers on every page you print
If you want each page to have the same row(s) or column(s) to be repeated at every page you print. […]
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
