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
I will try to explain again, I did not do a very good job last time. I have
a workbook that has several tabs. Under these tabs there may be several pages of information. I would like to be able to number the pages and have the number change as additional pages are added. Also I would like to be able to print the entire workbook and have all the pages numbered. This would be a different number than just numbering the pages under a tab. Hope this helps explain what I would like to do. Thanks |
#2
|
|||
|
|||
Red
You're right. This does make more sense. Page numbers can be printed in the Header or Footer of printed pages. Select a tab and right-click "Select all sheets" then FilePage SetupHeaders and Footers. I'll use Footer for example. In the built-in Footers you have Page 1 of ? Select that and OK your way out. UnGroup the sheets. Now, if you print one tab with 10 pages you will get Page 1 of 10, Page 2 of 10 etc. If you print the entire workbook, you will get Page 1 of 50, etc. Gord Dibben Excel MVP On Wed, 2 Mar 2005 13:09:09 -0800, Red wrote: I will try to explain again, I did not do a very good job last time. I have a workbook that has several tabs. Under these tabs there may be several pages of information. I would like to be able to number the pages and have the number change as additional pages are added. Also I would like to be able to print the entire workbook and have all the pages numbered. This would be a different number than just numbering the pages under a tab. Hope this helps explain what I would like to do. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
numbering all pages in worksheet | Lyn Familant via OfficeKB.com | General Discussion | 1 | February 12th, 2005 02:26 AM |
Printing Selected Pages from a Document Containing Multiple Page Numbering Schemes | Don | Formatting Long Documents | 7 | January 14th, 2005 03:07 AM |
Printing Selected Pages from a Document Containing Multiple Page Numbering Schemes | Don | Page Layout | 5 | January 14th, 2005 03:07 AM |
NUMBERING the pages | Bob | New Users | 7 | June 14th, 2004 12:20 AM |