View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Positive Positive is offline
external usenet poster
 
Posts: 37
Default Custom header/footer with many pages in one worksheet

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