Forum Discussion

Alicia Harper's avatar
Alicia Harper
Copper Contributor
Jan 31, 2018

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...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Feb 05, 2018
I assumed you did not want to include the first page in the page count, hence the two "-1" in the footer I proposed :-)
jb567's avatar
jb567
Copper Contributor
Jan 02, 2019

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!

 

  • mossi786's avatar
    mossi786
    Copper Contributor
    Jul 07, 2019

    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 :)

    .

     

     

    • SIBgd365's avatar
      SIBgd365
      Copper Contributor
      Apr 15, 2020

      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.

       

      • Khanh_Mai's avatar
        Khanh_Mai
        Copper Contributor
        Jun 09, 2020

        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

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 07, 2019
    Not that I know of, other than reserving cells on each page to manually enter the page count, which is rather cumbersome. Word is by far the better application for things like this.

Resources