How to change starting page number in Excel 2010

This post is in reply to the query posted by a reader that

My footer is starting with zero. Why?
I want it to start with one.

Excel 2010 footer page number by default starts with number 1and you can change the starting page number using the Page Setup option.

Step 1: Click the File menu and navigate to Print option.

image

Step 2: In the Print screen, click the Page Setup link available at the bottom.

Step 3: This would display the following Page Setup window.

image

Enter the starting page number for you footer in the First page number field. If you want to have the default behavior then keep the value as auto.

Step 4: Click OK button to confirm and save the changes.

By this way you can customize the starting page number in Excel 2010.


Comments

7 responses to “How to change starting page number in Excel 2010”

  1. Gerard Stancey Avatar
    Gerard Stancey

    thanks for beneficial recommendations and just excellent information

  2. Roy Devani Avatar
    Roy Devani

    Excellent help – simple and straight to the point. I have spent hours earlier looking for the answer using Microsoft help, but to no avail.

  3. thanks for help.

  4. Thanks for the tip, very helpful. As an aside, to get to the setup page a little easier go to the Page Layout tab and click on the little square with an arrow in the right bottom corner of the Page Setup group.

    1. Ravi Shankar Avatar
      Ravi Shankar

      Thank you

  5. SeisaT Avatar
    SeisaT

    This works fine if you only want to assign a page number only – i.e Page 4. However, if you want to insert the total number of pages as well – i.e. Page 4 of 8, it reflects the page numbers as Page 4 of 4; Page 5 of 4; Page 6 of 4 etc. How do you get it to increment the page numbers appropriately?

  6. Ernie Laughlin Avatar
    Ernie Laughlin

    I follow the procedure but no numbers show up on my preview or printed sheets. What I really want to do is have SC-15 be the first page number, then SC-16, etc. for a 6-page document, using either page numbers or footers. Any ideas?

Leave a Reply

Your email address will not be published. Required fields are marked *