View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?