Custom header/footer with many pages in one worksheet

  • Thread starter Thread starter Positive
  • Start date Start date
P

Positive

How do I custom header/footer the pages when i have more than 1 pages
in a tab/ worksheet? For example : When I number one worksheet as
page 1. When I print it out it has 3 pages and they all have "page 1"
on each page.
Please help
Many thanks

Lan
 
You are printing one worksheet with multiple printed pages in one print job?

Setting a custom header/footer with &[Page] will give you Page 1 followed by
Page 2 etc.

If not doing it this way, how are you doing it?


Gord Dibben MS Excel MVP
 
In the header/footer dialog box, use the icons to insert page # field rahter
than hard-coding a number.
 
In the header/footer dialog box, use the icons to insert page # field rahter
than hard-coding a number.






- Show quoted text -
Click to expand...

It does not work when I want to mark that first page as Page 8 and
want the folowing pages to be Page 9 and Page 10 in one work sheet.
What should I do? Many thanks-

Btw, what Duke means by use the icons to insert page#field rather than
hard coding? Can you please explain in more detail ? I would like to
try what you suggest.
Thanks

Lan
 
What do you mean by mark first page as 8. Describe all the steps you do, are
you printing multiple copies of the same page?
 
File>Page Setup>Page.
Enter the number 8 in "First page number"


For second part..................


File?Page Setup>Headers and Footers>Custom Footer. Hit the # Icon right of the
large A icon to enter &[Page]


Gord Dibben MS Excel MVP
 
What do you mean by mark first page as 8. Describe all the steps you do, are
you printing multiple copies of the same page?

--
Regards,

Peo Sjoblom









- Show quoted text -
Click to expand...
 
File>Page Setup>Page.
Enter the number 8 in "First page number"

For second part..................

File?Page Setup>Headers and Footers>Custom Footer. Hit the # Icon right of the
large A icon to enter &[Page]

Gord Dibben MS Excel MVP



It does not work when I want to mark that first page as Page 8 and
want the folowing pages to be Page 9 and Page 10 in one work sheet.
What should I do? Many thanks-
Click to expand...
Btw, what Duke means by use the icons to insert page#field rather than
hard coding? Can you please explain in more detail ? I would like to
try what you suggest.
Thanks- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Gord,
Thank you so much. It works. Now I have another question

If I have a zip file of 200 pages (word and excel). Is there a way to
number the pages when I print them out without having to manually go
to Page Setup to custom every single page?
Again thanks a bunch.
L
 
A Zip file of Excel and Word "pages"?

What do you mean by that?

Are these Excel workbooks and Word documents zipped up?

Are they *.prn files zipped up?

I wouldn't know where to start answering.


Gord
 
A Zip file of Excel and Word "pages"?

What do you mean by that?

Are these Excel workbooks and Word documents zipped up?

Are they *.prn files zipped up?

I wouldn't know where to start answering.

Gord






- Show quoted text -
Click to expand...

Sorry for not very clear. It is a zip file ( .zip) of excel workbooks
and word documents. How do i number the pages?
Thanks
Lan
 
I have no idea how to produce incremented consecutive page numbers when printing
multiple documents from a zip file.

I believe you would need a third-party application(if there is one) which could
do this through the Windows OS.


Gord
 
Back
Top