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
Alicia Harper's avatar
Alicia Harper
Copper Contributor
Feb 04, 2018

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?

JKPieterse's avatar
JKPieterse
Silver Contributor
Feb 05, 2018
You must also select all worksheets you wish to combine into the print, before printing.
  • Alicia Harper's avatar
    Alicia Harper
    Copper Contributor
    Feb 05, 2018

    I've got it working a little better although the first page says 0 of 6. Shouldn't it be 1 of 6?

    • 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!

         

Resources