numbering pages in footer

In the old excel, 1997, we could start a new page with a different page
number rather than 1. I have many pages in one worksheet and many worksheets.
I want the numbering footer to continue with each worksheet I prepare, and
print them out at different times. I will finish one worksheet and print, and
use this while working on a new worksheet, but want the next page to start
where the last worksheet ended. I know you can do this by added all the
worksheets together on a single worksheet and group them, however I work them
at different times. On the 1997 version, you would simple put the page number
in a box and it would start numbering from that number. Please advise

StarZ_Keeper

StarZ_Keeper wrote:
In the old excel, 1997, we could start a new page with a different page
number rather than 1. I have many pages in one worksheet and many worksheets.
I want the numbering footer to continue with each worksheet I prepare, and
print them out at different times. I will finish one worksheet and print, and
use this while working on a new worksheet, but want the next page to start
where the last worksheet ended. I know you can do this by added all the
worksheets together on a single worksheet and group them, however I work them
at different times. On the 1997 version, you would simple put the page number
in a box and it would start numbering from that number. Please advise

StarZ_Keeper


You refer to the "old" Excel as 1997, but what do you consider the "new" Excel?

In 2003, I see this in the help file:


Change the page number for the first page

1. Click the worksheet.

2. On the File menu, click Page Setup, and then click the Page tab.

3. In the First page number box, type the page number you want to appear on the
first page of the worksheet.

To have Microsoft Excel automatically number the pages of the worksheet, type
the word Auto in the First page number box.