Footer - Page Number problem

[Guest]

I have a workbook I maintain with MANY worksheets showing price lists for
different accounts. Each worksheet has several pages. I want the footer to
print the page # for the worksheet, not the page # of the workbook. In other
words, pages 1,2,3 on worksheet 2 should also read 1,2,3 not 4,5,6. When I
print each sheet individually the page #s are correct but when we print the
entire workbook, it shows the wrong #s. Is there an Easy way of doing this?
Other people in the office are doing the printing (the easy way) and sending
out mailings with bad page #s. Help?

 

[RagDyer]

All you have to do is go to,
<File> <PageSetup> <Page> tab,
And change the "First Page Number" from Auto to 1.

You can group all your sheets and make this change at one time.

One glitch *may* be ... if you use the total print job number per sheet:
Page n of n

That second n will display the total pages for the *entire* print job, not
just the number of pages per sheet.

 

[Guest]

Fantastic... Thanks so much

All you have to do is go to,
<File> <PageSetup> <Page> tab,
And change the "First Page Number" from Auto to 1.

You can group all your sheets and make this change at one time.

One glitch *may* be ... if you use the total print job number per sheet:
Page n of n

That second n will display the total pages for the *entire* print job, not
just the number of pages per sheet.

 

[RagDyeR]

You're welcome, and appreciate the feed-back.