Forum Discussion
Page numbering for multiple worksheets
I am creating a quote/estimate document for our customers and have several different worksheets, some of which have more than 1 page. What I want to do is number all worksheets, except for the 1st on...
This takes some steps.
1. Select all sheets in question, starting from the left (control-click on their tabs)
2. On the ribbon, on the page layout tab, in the page setup group, click on the tiny arrow in the bottom-right corner.
3. Click the Header/footer tab
4. Check the box "Different first page"
5. Click custom Footer
6. On the first tab ("Footer"), enter this into the box where you wish the page numers to appear:
"&[Page]-1 of &[Pages]-1 "
enter without those quotes. Please note there is a deliberate space after the last 1!!!
7. Click the first page footer and enter whatever footer you wish to have on the first page
1. Select all sheets in question, starting from the left (control-click on their tabs)
2. On the ribbon, on the page layout tab, in the page setup group, click on the tiny arrow in the bottom-right corner.
3. Click the Header/footer tab
4. Check the box "Different first page"
5. Click custom Footer
6. On the first tab ("Footer"), enter this into the box where you wish the page numers to appear:
"&[Page]-1 of &[Pages]-1 "
enter without those quotes. Please note there is a deliberate space after the last 1!!!
7. Click the first page footer and enter whatever footer you wish to have on the first page
Hi Jan,
This didn't quite work for me. It's still treating each worksheet as a separate document. So, for example my third worksheet has two pages but those are showing 0 of 1 and 1 of 1. They are not taking into account that I have two worksheets before it and accounting for those pages.
Any ideas why this could be?
- You must also select all worksheets you wish to combine into the print, before printing.
I've got it working a little better although the first page says 0 of 6. Shouldn't it be 1 of 6?
