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

Are you using this?

&[Page]




--
Regards,

Peo Sjoblom



"Positive" wrote in message
ups.com...
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

On Thu, 16 Aug 2007 19:26:17 -0000, Positive wrote:

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

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

"Positive" wrote:

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

On Aug 16, 8:49 pm, Duke Carey
wrote:
In the header/footer dialog box, use the icons to insert page # field rahter
than hard-coding a number.



"Positive" wrote:
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- Hide quoted text -

- 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

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



"Positive" wrote in message
ps.com...
On Aug 16, 8:49 pm, Duke Carey
wrote:
In the header/footer dialog box, use the icons to insert page # field
rahter
than hard-coding a number.



"Positive" wrote:
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- Hide quoted text -

- 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

FilePage SetupPage.
Enter the number 8 in "First page number"


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


File?Page SetupHeaders and FootersCustom Footer. Hit the # Icon right of the
large A icon to enter &[Page]


Gord Dibben MS Excel MVP


On Fri, 17 Aug 2007 13:59:27 -0000, Positive wrote:

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

On Aug 17, 11:00 am, "Peo Sjoblom" wrote:
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

"Positive" wrote in message

ps.com...



On Aug 16, 8:49 pm, Duke Carey
wrote:
In the header/footer dialog box, use the icons to insert page # field
rahter
than hard-coding a number.

"Positive" wrote:
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- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

On Aug 17, 7:29 pm, Gord Dibben <gorddibbATshawDOTca wrote:
FilePage SetupPage.
Enter the number 8 in "First page number"

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

File?Page SetupHeaders and FootersCustom Footer. Hit the # Icon right of the
large A icon to enter &[Page]

Gord Dibben MS Excel MVP



On Fri, 17 Aug 2007 13:59:27 -0000, Positive wrote:
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

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


On Mon, 20 Aug 2007 18:15:12 -0000, Positive wrote:

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.

On Aug 20, 5:05 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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



On Mon, 20 Aug 2007 18:15:12 -0000, Positive wrote:
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.- Hide quoted text -

- 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

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

On Tue, 21 Aug 2007 13:55:14 -0000, Positive wrote:

On Aug 20, 5:05 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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



On Mon, 20 Aug 2007 18:15:12 -0000, Positive wrote:
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.- Hide quoted text -

- 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