Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Linda
 
Posts: n/a
Default Printing Multiple Worksheets

Is there a way to print multiple worksheets at a time but have their
numbering stay true to the tab? Say you have 4 worksheets in a workbook.
The first worksheet is 5 pages, the second 4, the third 8. Right now if I
click ctrl and choose all the worksheets to print it totals all the pages and
in the footer it starts printing 1 of 17 etc. What I would like for it to do
is print 1 of 5, 2 of 5 etc for the first worksheet; 1 of 4, 2 of 4 etc for
the second worksheet.... Is there a way to make Excel do this?
  #2   Report Post  
SVC
 
Posts: n/a
Default

You will need to File Page Setup for each sheet. On the Page tab set First
page number to 1; on the Header/Footer tab select Custom Footer, put your
cursor in the appropriate location (Left, Middle, or Right) and click Page
number, then type a space and the word "of" and another space, then click the
Pages button, Click OK twice. Repeat for each tab and you should be ready
to go.

"Linda" wrote:

Is there a way to print multiple worksheets at a time but have their
numbering stay true to the tab? Say you have 4 worksheets in a workbook.
The first worksheet is 5 pages, the second 4, the third 8. Right now if I
click ctrl and choose all the worksheets to print it totals all the pages and
in the footer it starts printing 1 of 17 etc. What I would like for it to do
is print 1 of 5, 2 of 5 etc for the first worksheet; 1 of 4, 2 of 4 etc for
the second worksheet.... Is there a way to make Excel do this?

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
Adding multiple worksheets Craig Excel Worksheet Functions 1 July 6th 05 07:21 PM
Printing Landscaped and Portrait worksheets at same time...XP Tamela Excel Discussion (Misc queries) 0 June 7th 05 01:14 AM
Printing multiple worksheets on one page Ben :Dillon Excel Discussion (Misc queries) 1 April 6th 05 11:02 PM
Excel - printing multiple worksheets on one page BGA Excel Discussion (Misc queries) 1 February 18th 05 03:05 PM
Countif with multiple criteria and multiple worksheets JJ Excel Worksheet Functions 1 December 28th 04 07:37 PM


All times are GMT +1. The time now is 01:19 PM.

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"