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

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

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

Forum Discussion

Page numbering for multiple worksheets