Jan 31 2018 12:58 AM
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 one which is a cover letter and has a different footer. I also want the numbering to show as 1/total pages.
So far I have managed to number my worksheets but both are showing up with page 1 on them. This will not make sense when we print out the entire document.
Thanks in advance.
Jan 31 2018 01:37 AM
Feb 04 2018 02:21 AM
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?
Feb 05 2018 12:47 AM
Feb 05 2018 01:11 AM
I've got it working a little better although the first page says 0 of 6. Shouldn't it be 1 of 6?
Feb 05 2018 01:58 AM
Jan 02 2019 09:33 AM
Jan,
I have sort of the opposite issue-I would like to treat each sheet as an independently numbered exhibit within a large PDF containing multiple exhibits. So exhibit A containing 3 sheets would say "1 (or 2, etc.) of 3" and exhibit 2 containing 5 sheets would be numbered "1 (or 2, etc.) of 5". It seems that by definition when I indicate that I want to print (or save as PDF) all worksheets, excel counts all the printed sheets, and the header says "1 of 8". Is there a solution to this?
Thanks!
Jan 07 2019 01:26 AM
Jul 07 2019 11:07 PM
@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 :)
.
Apr 15 2020 05:58 AM
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.
Jun 09 2020 08:59 PM
Hello @SIBgd365,
I also have the same issues as yours. I want to export multiple works sheets to PDF with the page number at footer shown as a separate sheets by selecting the sheets and export at the same time.
Have you found the solution to this?
Thank you. Khanh Mai
Mar 29 2021 05:59 PM