Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Page x of x based on sheets.
I have a document with about 40 sheets. Is there a way to have the
Page x of x be displayed on all sheet. But Page 1 should be sheet 1. Page 2 should be Sheet 2 etc. Let's go one more step. Each sheet has 2 pages. Is it possible to have Sheet 1, Page 1 to display Page 1 of 80 Sheet 1, Page 2 to display Page 2 of 80 Sheet 2, Page 1 to display Page 3 of 80 Sheet 2, Page 2 to display Page 4 of 80 Etc. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Page x of x based on sheets.
Select Sheet1 then right-click and "select all sheets".
Set up your footer or header as Page 1 of ? on the activesheet. Then print the lot as one print job. Page numbers will be incremented as you ask. Gord Dibben MS Excel MVP On 11 Apr 2007 15:49:35 -0700, wrote: I have a document with about 40 sheets. Is there a way to have the Page x of x be displayed on all sheet. But Page 1 should be sheet 1. Page 2 should be Sheet 2 etc. Let's go one more step. Each sheet has 2 pages. Is it possible to have Sheet 1, Page 1 to display Page 1 of 80 Sheet 1, Page 2 to display Page 2 of 80 Sheet 2, Page 1 to display Page 3 of 80 Sheet 2, Page 2 to display Page 4 of 80 Etc. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Printing 2 sheets on 1 page | Excel Discussion (Misc queries) | |||
Print 3 sheets on the same page | Excel Discussion (Misc queries) | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Printing 3 or more sheets into 1 page | Excel Programming |