numbering pages in footer


S

StarZ_Keeper

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
 
Ad

Advertisements

G

Glenn

StarZ_Keeper said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top