If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
numbering pages in footer
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. |
Thread Tools | |
Display Modes | |
|
|