Page Numbering in a Workbook (2002)

[kroderick]

I have read the postings on- consecutive page numbers for multiple worksheets (2000) Post: 138938. I am still having trouble (and perhaps it is not possible) getting consecutive page numbers to print when I print multiple worksheets.

I have selected the sheets manually and get 1 of 21, 2 of 21, 3 of 21 and then back to 1 of 21 for the next worksheet when I print.

Any suggestions??? Thanks!

[JohnBF]

Kathy, are you selecting (Control-Clicking the Tab is easiest) all the sheets to be printed and then printing them all in one run?

[kroderick]

Hi ,

Yes I am. It starts out great 1 of 21, 2 of 21, 3 of 21 and then back to 1 of 21...

[SammyB]

Kathy, don't have 2002, so this may not work, but try this:
1) Select the tab of the first sheet, then control-click to select the rest of the sheets
2) File | Page Setup | Header/Footer | Custom Header (or Footer)
3) Click in the section where you want the page number and then press the page number button ( the one with the #) and press OK
4) Click on the Page tab and set First page number to auto.

[BrookBoy]

Well, something that is kind of klunky but works for me is to use Views and Report Manager. You can store your print areas in Views, then create print reports in Report Manager to print them. Report Manager allows you to select consecutive page numbers.

If you're not familiar with this approach, click on your View menu. You should see the command Custom Views. If you don't see Report Manager you will have to enable it in Tools Add-ins.

What you do is create a print area, adjust your settings in the Page Setup dialog, then store it as a View. You can store multiple print areas from the same worksheet as different Views, if you wish, or just store one print area per worksheet. (When you name the Views it's a good idea to use the sheet name as part or all of the View name.)

Then, after you've created the Views, open Report Manager and add the Views to your print report. (You can also add Scenarios to a print report if you have any.) Once you've created the print report you want, you then use Report Manager to print rather than the File menu.

As I said, it's kind of awkward, but it works.

HTH,

[kroderick]

Hi Sam,

Thanks for the fix, it worked great!