How to Number Pages in Excel

 NOTE: Download Now 70+ Basic and Advanced Excel Exercises

The Excel tool is different from Word. In Word, you will have separate pages that make it easier to track content, but in Excel, it's a continuous spreadsheet. To distinguish separate text pages in Excel, you will need to mark pages in Excel, especially when printing documents. This is a fairly basic operation, but it can also be difficult for those who are not familiar with this tool or for those who are just getting acquainted with Excel.

How to Number Pages in Excel 2016, 2013, 2010, 2007, 2003

Have you ever thought about numbering pages in an Excel spreadsheet? Perhaps you've overlooked this and found that in many cases, you don't need to number pages. However, there are situations where numbering pages is necessary, especially when you want to print financial statements. Consider this scenario: you print a document set, and due to some oversight, the pages get mixed up without order. If these pages aren't numbered, it will take you a considerable amount of time to rearrange the document accurately. However, Excel also allows you to number pages, similar to numbering pages in Word. Let's follow these steps.

How to Number Pages in an Excel Spreadsheet

For Excel 2010, 2013, 2016

The interface of Excel 2010, 2013, 2016 versions is entirely the same. You can perform similar actions. This article will use Excel 2016 for demonstration.

Step 1: On the Ribbon, select the Page Layout tab, then click the arrow in the bottom corner of the Page Setup section.

Step 3: Another dialog box appears. You can choose to number pages on the left, center, or right side of the worksheet. Enter the page number and click the Insert Page Number button, then click Ok to confirm. You can do the same for Custom Header page numbering.

For Excel 2007

Step 1: Choose Page Layout --> click on the arrow in the top-left corner.

Step 2: A dialog box appears. In the Header/Footer tab, you can choose to number pages in the header or footer section. I choose to number pages in the footer, so you will click on Customer Footer.

Step 3: Another dialog box appears. You can choose to number pages on the left, center, or right. Enter the page number as shown below.

Step 4: Then click on the icon as shown below. You will see the result as shown below, then press Ok.

Result:

For Excel 2003

Step 1: Choose File --> Page Setup

Step 2: A dialog box appears. In the Header/Footer tab, you can choose to number pages in the header or footer section. I choose to number pages in the footer, so you will click on Customer Footer.

Step 3: A dialog box appears. You can choose to number pages on the left, center, or right. Enter the page number as shown below.

Step 4: Then click on the icon as shown below. You will see the result as shown below, then press Ok

Result:

 Note

You can number pages in the header or footer, or you can number pages in different positions like left, center, or right. You can choose according to your preference.

So, here is the complete guide on how to number pages in Excel that you can apply to your documents in case you 'forget' how to perform this skill. Additionally, numbering columns automatically in Excel is one of the basic operations when working with lists for easy reference. If the list is short, numbering each number 1, 2, 3... until the end is quite simple. However, for Excel lists with thousands of rows, you cannot use this method and must use the available functions in Excel, so the article on how to automatically number columns in Excel will be a quick solution to help you automatically number columns in Excel.