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

--
Message posted via http://www.officekb.com

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?
--
David Biddulph

"chicken" wrote in message
...
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.

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.

"David Biddulph" wrote:

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?
--
David Biddulph

"chicken" wrote in message
...
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.