printing page # on sheets

D

D

I have a workbook with several tabs that consist of several sheets each. I
would like to print all the sheets (which I know how) but I need each sheet
to start over with the page # of pages footer restarting at 1.
Thanks in advance
 
G

Gord Dibben

You have a workbook with multiple worksheets?

Each worksheet has multiple pages to print?

Don't select more than one worksheet at a time when printing.

That way your page numbers will be correct.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning page-count to a cell 2
Page Numbers for an index 1
formatting sheets in a workbook 4
Scroll Lock for selected multiple sheets 2
Sumproduct function multiple sheets 4
Worksheet page numbering 3
All sheets in workbook have same rows to repeat at top 1
Continuation of Page number in footer 2

Top