Page numbering in Excel 2016/2013/2010/2007

When doing word processing or working on Microsoft Office spreadsheets , one of the most important and necessary things is page numbering. Not only helps users easily manipulate, but the number of Excel pages also helps us manage and work more effectively.

We already know how to number pages in Word from the beginning or any page and on Excel spreadsheets can do the same. If you do not know how to do it, you can follow the quick guide below.

Number the Excel page

Microsoft Excel for Android Microsoft Excel for iOS Excel 2016

Step 1: From the interface manipulating Microsoft Excel spreadsheets, select the Page Layout tab , then click the left mouse button on the arrow icon in the bottom corner.

Step 2 : The Page Setup dialog box appears, select the Header / Footer tab , with two options corresponding to the two positions where we want to set the page number:

• Custome Header : Put page numbers at the top
• Customer Footer : Put page numbers at the end

Step 3 : For example, we choose to put the page number below ( Footer ), a corresponding dialog box will appear as below. At this time, we can also choose 3 different positions to number the page as we like, specifically:

• Left section : Sets the page number to the left
• Center section : Sets the page number in the center
• Right section : Set the page number to the right

Step 4 : Want to put the page number where, select it and then click on the Insert Page Number icon .

Immediately you will see & [Page] of & [Pages] or & [Page] appear at that location.

Click OK to confirm the operation, then go to Print / Print Priview to preview the print and check the position we just numbered the page in Excel.

That's how we insert page numbers on a spreadsheet. If you want to make effective use of this office tool, this is one of the Excel tricks not to be missed.