Insert Page Numbers on Worksheet in Excel 2007

[Stratuser]

In Excel 2003, if you wanted to put page numbers on multiple worksheets in a
workbook, you grouped the worksheets and then added a header or footer, using
the page number function. All of your grouped worksheets would shows its own
page number.

But in Excel 2007, only my first worksheet is numbered when I do this (as
Page 1). What's the problem? Do I actually have to put a page number, one
by one, on each worksheet?

 

[Gord Dibben]

I cannot replicate your problem with 2007.

Grouped sheets behave exactly as 2003 did.

After grouping and adding a header of Page 1 did you do a print preview
with the grouped sheets?

Only Page 1 was showing? None of the other pages had a header?


Gord Dibben MS Excel MVP

 

[Stratuser]

Yes, I did a print preview with the grouped sheets, and no page except the
first page had a header. So that put me in the position of having to do an
individual header for each of 15 worksheets (Page 1, Page 2, ...Page 15),
which I don't want to do.

 

[Stratuser]

I found a way of getting around the problem. I went to Page Layout, and then
to Print Titles, and there I put in the header. For some reason, it worked,
although it hadn't worked when I tried going into Print Preview and putting
in the header from there.

 

[Gord Dibben]

Have you tried the same operation on a new workbook?

Open a new book and group the sheets.

Enter something in A1 and copy down to A100.

Setup the header and preview.

Same thing?

As I stated in first reply............I cannot replicate your problem in
2007 so not much help.


Gord

 

[Gord Dibben]

I see.

I always go through Print Titles or File>Page Setup............never tried
through Print Preview.

Same behaviour in Excel 2003. Only adds Page number(s) to first worksheet
when seet up from Print Preview.

Just never noticed.

Thanks for posting back with resolution.


Gord

 

[Stratuser]

The same thing happened with a new workbook. If I insert a page header in
Print Preview, it shows up only on the first grouped worksheet (although in
this case the worksheet spills over onto two pages and I get a "Page 2").
But if I insert the page header in Print Titles, the page numbers show up on
every grouped worksheet. Well, it's a bug, but at least I know a workaround
now.