Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
numbering tabs and printing in footer dysart316 Excel Discussion (Misc queries) 0 October 29th 07 09:45 PM
numbering pages sbabybluiz Excel Worksheet Functions 1 May 3rd 06 02:23 PM
Numbering pages Red Excel Worksheet Functions 1 March 2nd 05 11:01 PM
numbering all pages in worksheet Lyn Familant via OfficeKB.com Excel Discussion (Misc queries) 1 February 12th 05 02:26 AM
Printing/Page Numbering in Footer Abi Excel Discussion (Misc queries) 1 January 12th 05 01:12 AM


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"