Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
D D is offline
external usenet poster
 
Posts: 121
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page numbers when printing multiple sheets Michelle Excel Discussion (Misc queries) 2 September 6th 07 07:39 PM
Excel Printing --Borders are not printing on the same page as data Stup88 Excel Discussion (Misc queries) 1 August 7th 07 09:34 AM
Page Breaks- Printing selected rows on same page ToddEZ Excel Discussion (Misc queries) 1 July 18th 07 04:38 PM
Printing multiple page worksheets on 1 single page Hope Excel Discussion (Misc queries) 1 January 7th 07 03:56 AM
Printing 2 sheets on 1 page bparker Excel Discussion (Misc queries) 0 May 30th 06 03:43 PM


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"