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?

Yes, I can definitely help you with that! Here are the steps to format the page numbers in the footer to start at a specific page number:

1. Open your Excel file and go to the first worksheet that you want to start numbering from.
2. Click on the "Page Layout" tab in the ribbon at the top of the screen.
3. Click on the "Page Setup" button in the lower right-hand corner of the "Page Setup" section.
4. In the "Page Setup" dialog box, click on the "Header/Footer" tab.
5. In the "Footer" section, click on the "Page Number" button.
6. Select the "Format Page Numbers" option from the drop-down menu.
7. In the "Page Number Format" dialog box, select the "Start at" option and enter "1" in the box next to it.
8. Click "OK" to close the "Page Number Format" dialog box.
9. Click "OK" again to close the "Page Setup" dialog box.

Now, the first three worksheets will not have page numbers, and the numbering will start at 1 on the fourth worksheet. When you print the worksheets as a group, the numbering should start at 1 as well.

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.
--
Sincerely, Michael Colvin


"straitctrydncr" wrote:

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?

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

"Michael" wrote:

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.
--
Sincerely, Michael Colvin


"straitctrydncr" wrote:

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?

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.

"straitctrydncr" wrote:

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?