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.
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.
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.
thanks for beneficial recommendations and just excellent information
Excellent help – simple and straight to the point. I have spent hours earlier looking for the answer using Microsoft help, but to no avail.
thanks for help.
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.
Thank you
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?
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?