How do I switch headers within a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Enter your footer as:

Page &[Page] of &[Pages]

Or use the page setup/headerfooter menu
 
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?
 
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.
 
Back
Top