Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Page numbers when printing multiple sheets

Thank you... Problem solved.

M


"MyVeryOwnSelf" wrote in message
...
I am trying to get my whole workbook to print out as a single
document. I select all 30 of the worksheets, and print. It works
fantastically, except the page numbering. It usually prints on about
125 pages, Sheet1 prints on two pages, so the page numbering in the
footer goes: Page 1 of 125, Page 2 of 125, then... Page 1 of 125 again
...
Is there a way of getting it to print consecutive numbers from 1 to
125 throughout the printout?


.
Maybe this will help. Select all tabs at once and use:
File Page setup Page

Then, where it says "First page number," type in:
Auto


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
Printing documents with page numbers Craig Perkins Excel Discussion (Misc queries) 1 April 6th 07 10:46 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
Printing Multiple sheets light_life_love Excel Discussion (Misc queries) 0 August 25th 05 08:52 PM
Printing Multiple sheets on ONE? onesidered Excel Discussion (Misc queries) 2 August 10th 05 06:58 PM


All times are GMT +1. The time now is 08:31 AM.

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

About Us

"It's about Microsoft Excel"