I see.

I always go through Print Titles or FilePage 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

On Thu, 28 Jan 2010 09:27:01 -0800, Stratuser
wrote:

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.

"Stratuser" wrote:

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.

"Gord Dibben" wrote:

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

On Wed, 27 Jan 2010 14:50:02 -0800, Stratuser
wrote:

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?

.