5 Quick Ways to Number Pages in Excel for Every Version

The numbering of pages in Word is probably familiar to many people, but how to number pages in Excel is not known to everyone. This article will guide you in detail on 5 quick ways to number pages in Excel in just a “moment”.

How to number pages in Excel

Numbering pages in Excel is really simple and there are many ways to help you do this.

1. Numbering pages in Excel from Page Setup

Step 1: Open the Excel file you want to number > Select Page Layout > Click on the drop-down arrow to open the Page Setup dialog box.

Step 2: In the Page Setup window, click on Header/Footer.

• Choose Custom Footer: If you want the page number to be at the bottom of the page.
• Choose Custom Header: If you want the page number to be at the top of the page.

In this example, I will choose Custom Footer.

Step 3: Next, click on the icon with the # symbol (as illustrated) and then click on one of the three positions:

• Left section: To number the page on the left side of the page.
• Center section: To number the page in the middle of the page.
• Right section: To number the page on the right side of the page.

Then click OK.

Step 4: Return to the Page Setup dialog box, click OK.

So your Excel file has been successfully numbered.

2. Numbering pages in Excel as desired

Step 1: Open the Excel file you want to number > Select Page Layout and click on the drop-down arrow to open the Page Setup dialog box.

Step 2: In the Page section, enter the desired page number in First Page Number.

Step 3: Next, switch to the Header/Footer section > Choose Custom Footer or Custom Header.

Step 4: Choose the position where you want to place the page number: Left Section (left side of the page) or Right Section (right side of the page) or Center Section (center of the page) and then click OK.

Step 5: Go back to the Page Setup dialog box, click OK.

3. Numbering pages in Excel by adding Header/Footer through the Insert tab

Another way to number pages in Excel is to use the Insert tab. Follow these steps:

Step 1: Open the Excel file you want to number > Select the Insert tab on the menu bar > Choose Text > Choose Header/Footer to insert the page number.

Step 2: Select the Design tab on the menu bar > Choose Page Number.

Then, you will choose the position where you want to number the page: left, right, or center, and then enter the page number there.

Just place the mouse pointer in any cell and the page number will be displayed, resulting in the following:

4. Numbering pages in Excel by using Page Layout view and adding Header/Footer

Through the View tab, you can also number pages in Excel. The steps are as follows:

Step 1: Open the Excel file > Select the View tab on the menu bar > Choose Page Layout in the Workbook Views section.

Step 2: If you want to number the page at the beginning, select Add Header, if you want to number the page at the end, scroll down and select Add Footer.

Step 3: Select the Design tab > Choose Page Number.

Place the mouse pointer where you want to number the page and enter the desired page number.

5. How to number pages 1/2 in Excel

In the above 4 methods, the page number is in the form of natural numbers 1, 2, 3,… However, in this 5th method, the Excel page number will be in the format “1/?”, “2/?” and end with “?/?” (with ? being the last page number in your document). For example, if your document has 10 pages, the numbering will be 1/10, 2/10, …, 10/10. This is a great trick that allows you to have precise control over your documents after printing.

The steps are as follows:

Step 1: Open the Excel file you want to number > Select Page Layout > Click on the drop-down arrow to open the Page Setup dialog box.

Step 2: In the Page Setup dialog box, select Header/Footer > Choose Custom Header or Custom Footer.

Step 3: Place the cursor where you want to number the page > Click on the number symbol next to the letter A (as shown in the illustration) > Enter a slash (/) > Click on the next symbol on the right (as shown in the picture). If the display matches the image, then click OK.

Step 4: Return to the Page Setup dialog box > Click OK.

The result will be as follows:

How to remove page numbering in Excel

For some reason, you may want to remove page numbering in Excel, and this can be done with a simple operation as follows:

Step 1: Open the Excel file with page numbering > Select Page Layout > Click on the drop-down arrow to open the Page Setup dialog box.

Step 2: In the Page Setup dialog box, select Header/Footer > Choose None in the Header or Footer section > Click OK. The page numbers will disappear.

Benefits of numbering pages in Excel

Numbering pages in Excel will first make your Excel file more professional and visually appealing. In addition, it helps viewers easily track and quickly find the information they need. With Excel files with multiple pages, it can be difficult to search, but if you know which page the content is on, you can quickly scroll to that page and find it.

In addition, numbering pages in Excel also makes it convenient for printing, preventing loss or confusion of documents. When each page has a sequential number, it becomes easier to organize without having to look at the content inside.

Sometimes, your Excel spreadsheet has multiple columns and needs to be divided into multiple pages. At this point, the page numbering trick will help you know the order of the pages, simplify your work, and save processing time.

Conclusion

Those are the ways to number pages in Excel, really simple, right? Apply one of these 5 methods to number the pages in your Excel file. I hope this sharing is helpful to you. Thank you for reading the article.