inserting specific page number into footer

  • Thread starter Thread starter Cate
  • Start date Start date
C

Cate

I am looking for a formula that will allow me to insert
specific page numbers into the footer of my worksheet. I
have a start number 1-21898 and I need this number to be
inserted into the footer and continue sequentially for 178
pages. How does this get accomplished? I need this
answer asap, Thanks.
 
See answer to your post in another group.

Please don't post the same message to multiple groups. It just fragments
your answers and potentially wastes the time of those replying to a
question that has already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm
 
Hi
how do you want to sequence??
1-21898
2-21898
....

or
1-21898
1-21899
....

In both case just go into 'File - Pagesetup - Header/Footer'. And
insert either
&[page] - 21898
or
1 - &[page]

for the second one you also have to change the starting page number in
the first tab of the pagesetup dialog (starting number)
 
Back
Top