Forum Discussion
Page numbering for multiple worksheets
jb567 I may have a solution for you. So to get each sheet to start over as a new item all you need to do is right click on one of the sheets click select all sheets then:
Page Layout>Page Setup>Small Arrow>Page tab
Under the item First page number as default it would say "auto" change that to 1.
In the same menu but under the tab header/footer
Custom footer>Choose a section of the footer you want to add your numbering>Click insert number (looks like a single page with a # on it) >Click the item next to it insert number of pages>OK
Now all your sheets will start from page 1 as an independent file and be numbered independently as e.g Sheet 1 - 1 of 5, Sheet 2 - 1 of 6 etc.
Hope this helps :)
.
Hi mossi786 ,
I have the same issue as jb567, but your reply didn't work for me.
When following your instructions the only thing that changes is that now every time a new sheet starts it will start with 1 and continue numbering from there keeping the document total number of pages.
For an example, if a Worksheet has 2 sheets with total of 15 pages, and the second sheet has 5 pages, the numbering of the second sheet displays - Page 1 of 15 until Page 5 of 15 instead displaying Page 1 of 5.
Hope jb567 found some other solution to his problem which doesn't include printing every sheet separately, or maybe I misunderstood your instructions.
Thanks.
