Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.

Start page number at 2 (or different number) in Excel

Excel Productivity Tools

Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial

Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial



Start page number at 2 (or different number) 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.


Related articles:


Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for you.

  • Designed for 1500+ work scenarios, helps you solve 80% Excel problems.
  • Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  • Being used by 110,000 elites and 300+ well-known companies.

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.