How To Add Page Numbers In Excel

Follow the steps – insert a footer, choose the ‘Page’ option from the ‘Header & Footer Elements’ section, and format the page number as needed.

In today’s digital age, Excel has become an essential tool for analyzing and organizing data. Whether you’re creating a financial report, inventory list, or a simple to-do list, it’s crucial to keep your Excel sheets properly organized. One common element that is often overlooked is page numbering. Adding page numbers to your Excel workbook can not only enhance its professionalism but also make it easier to keep track of your data. In this blog post, we will guide you through the process of adding page numbers in Excel, so you can better manage and present your Excel sheets. So let’s dive in and unlock the power of page numbering in Excel!

How To Add Page Numbers In Excel: Step-by-Step


Step 1: Open Excel Sheet,

To add page numbers to an Excel document, open the desired file and navigate to the header or footer section. From there, utilize the page number feature to insert page numbers accordingly.

Next Step

Step 2: Go to the Print Preview,

To locate and access the print menu in the application, simply navigate to the “File” tab situated at the top left of the screen, then select “Print” from the dropdown options that appear.

Next Step

Step 3: Navigate to Page Setup,

In the Print screen, locate and click on the “Page Setup” link located at the bottom of the screen. This option allows you to customize the page layout and printing settings for a more tailored output.

Next Step

Step 4: Open the Header/Footer tab,

In the Page Setup dialog box, navigate to the Header/Footer tab to customize header and footer content for your document.

Next Step

Step 5: Choose a Header or Footer,

In the custom header or footer option, you have the flexibility to design your own header or footer and add the desired page numbers. This allows you to create personalized headers or footers that align with your specific document requirements.

Next Step

Step 6: Click on the Page Number icon,

Once you are in the custom header or footer section, you can choose between three sections: left, center, and right. To determine where you want the page number, simply click on the desired section in the dialog box. Next, locate the Page Number icon, which resembles a piece of paper with a “#” symbol, and click on it.

Next Step

Step 7: Click OK,

When prompted, click “OK” to finalize the inclusion of page numbers. Additionally, you have the freedom to insert additional customized text that accompanies the page number, providing further context or description about the content on the page.

Next Step

Step 8: Verify,

After making the necessary changes, you will be directed back to the print screen where you can conveniently preview the document, now including the newly inserted page numbers. This allows you to ensure the document is complete and organized before finalizing the printing process.

Next Step

Step 9: Print/Saving the Excel Sheet,

Once you have verified the accuracy, feel free to print or save your document with this selected setting for consistent use whenever you access it in the future.


In conclusion, knowing how to add page numbers in Excel can greatly enhance the organization and readability of your spreadsheets. Whether you’re creating a lengthy report or a simple list, page numbers provide a quick reference for navigating through your data. By following the steps outlined in this tutorial, you can easily insert and customize page numbers to suit your specific needs. So, go ahead and take advantage of this simple yet powerful feature to make your Excel worksheets more professional and user-friendly. With a little practice, you’ll be a master at adding page numbers in no time!

Table of Contents