printing page # on sheets
 

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

printing page # on sheets
 

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

On Mon, 9 Feb 2009 16:53:01 -0800, D wrote:

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