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