Custom header/footer with many pages in one worksheet

[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

 

[Peo Sjoblom]

Are you using this?

&[Page]

 

[Gord Dibben]

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

 

[Guest]

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

 

[Positive]

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






- Show quoted text -

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

 

[Peo Sjoblom]

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?

 

[Gord Dibben]

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

 

[Positive]

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 -

 

[Positive]

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-

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 -

- Show quoted text -

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

 

[Gord Dibben]

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

 

[Positive]

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 -

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

 

[Gord Dibben]

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