Footer - Page Number problem
Fantastic... Thanks so much
"RagDyer" wrote:
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.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nicci" wrote in message
...
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?
|