- To post as a guest, your comment is unpublished.· 1 years agoHi Darren,
When I insert the headers as &[Page] of &[Pages], and configure the page number starts at 2, the total number of pages is correct.
More information about this problem can help us solve it. Thanks!
How to start page number at 2 (or different number) in Excel?
The page numbers begin at 1 by default in Excel. However, for example, there has already been a cover page, and you want to start the page number at 2 in your worksheet, how could you solve it? In this article, I will introduce the solution to insert page numbers starting at 2 or any different numbers in Excel.
This method will guide you to insert page numbers which are starting at 2 or any different number in a worksheet. Please do as follows:
1. Enable the specified worksheet you will insert page numbers, and click Insert > Header & Footer. See screenshot:
2. Go ahead to click Design > Page Number. See screenshot:
Now the page numbers are inserted at the header.
3. Click out the header box, and then click the anchor at the bottom-right corner of the Page Setup group on the Page Layout tab. See screenshot:
4. In the popping Page Setup dialog box, under Page tab, please type 2 or any different number in the First page number box, and click the OK button. See screenshot:
Now you will see the page numbers start at 2 or any different number as you specified in the specified worksheet.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 1 years agoThis works just fine and thanks for the guide. However, I always number my pages as X of Y and when I do this the Y number is always 1 higher than the actual total. Any suggestions?