Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Printing Landscaped and Portrait worksheets at same time...XP | Excel Discussion (Misc queries) | |||
Printing multiple worksheets on one page | Excel Discussion (Misc queries) | |||
Excel - printing multiple worksheets on one page | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |