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
This article describes how to create a button and place it on an Excel worksheet then assign a macro to […]
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 […]
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 […]
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.