Insert Page Numbers on Worksheet in Excel 2007
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?
|