How do I switch headers within a worksheet

C

chicken

I want to number pages consecutively. One worksheet has 5 pages but when I
put in the page # it places the same number on all five pages. I want to to
be able to place a number for each of the five pages. There are a total of
14 pages in workbook. All other worksheets have just one page so I am able
to change the page number.
 
C

Crowbar via OfficeKB.com

Enter your footer as:

Page &[Page] of &[Pages]

Or use the page setup/headerfooter menu
 
D

David Biddulph

In your header, did you put in the page number as a page number field, or
did you type in a specific number as text?
 
C

chicken

I did both because sheet 1 to 3 are separate worksheets of 1 page each that I
want numbered consecutively. Sheet 4 has 5 pages so when I enter the number
4 it puts that number on all 5 pages. I want to be able to number the 5
pages (4, 5 6 etc.) The remaining worksheets are 1 page each so I was able to
change the page number for each header.
 
Top