View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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