Format page number in excel footer to start at a specific page #

S

straitctrydncr

I have an excel file that has 26 different worksheets in it; I need to format
the page numbering so that the first three worksheets do not number; it
starts with 1 at the fourth page. When I print it as a group, it is starting
it at 4 instead of one; yet it prints as 1 when I print out the page only.
Can you help me format this so it works?
 
M

Michael

Hi straitctrydncr. Hopefully a guru will supplie you with an event macro, I
can't, but as a temporay work around, why not just print the first three
sheets before setting the page number and then print the rest of the sheets.
 
S

straitctrydncr

Hi Michael,
Thanks for the response, but unfortunately it won't work for me - I have to
email this to the higher ups all over the country and they want it set up so
that all they have to do is tell it to print all and it all comes out in the
right order and with page numbers in order. Therein lies my problem. Thanks
for trying.
Jo-Ann
 
M

Manoj

What you could do is to put the actual page number in the header or footer as
the case may be instead of the formula for the page number. I mean hard-code
the page number for each sheet. this will be a one-time exercise but will
save you all the trouble.

If a sheet prints on multiple sheets then use a formula like this:
say a particular sheet prints 3 pages starting with page number 8. then use
the formula for the page number and add "+7" -->> e.g., the footer for this
page will contain the formula "&[Page]+7". so this will start printing from
page number 8 as the formula "&[Page]" will give the result of "1" by default.

Try this and see if this works.
 
Top