How To Insert Page Numbers In Excel

Inserting page numbers in Excel involves accessing the header and footer section, selecting the desired location for the page numbers, and using the formula or inserting the &P code to display the page numbers correctly.

In today’s digitally-driven world, Excel has become an indispensable tool for businesses and individuals alike. But when it comes to organizing and presenting data, one often overlooked aspect is the inclusion of page numbers. Whether you’re creating a report, a financial statement, or a large spreadsheet, adding page numbers can provide clarity and structure to your workbook. In this blog post, we’ll explore various methods and shortcuts to help you master the art of inserting page numbers in Excel.

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


Step 1: Open Excel Workbook,

First, open the Excel workbook document you wish to add page numbers to. Navigate to the desired location within the document where you want the page numbers to appear.

Next Step

Step 2: Go to Page Layout,

Once you have opened your workbook, navigate to the ‘Page Layout’ option in the Ribbon toolbar at the top of the Excel window to access various tools and settings for formatting and arranging your spreadsheet.

Next Step

Step 3: Click on Print Titles,

In the Page Layout toolbar, locate and click on the ‘Print Titles’ option to access additional settings for customizing the appearance and content layout during printing.

Next Step

Step 4: Navigate to Header/Footer tab,

Once the Page Setup dialogue box is open, navigate to the ‘Header/Footer’ tab located in the second row. Here, you can customize the header and footer settings for your document.

Next Step

Step 5: Insert Page Number,

Under the Header/Footer tab, locate the ‘Footer’ section and click on either ‘Custom Header’ or ‘Custom Footer’. Choose the placement of page numbers – right, center, or left. Insert the desired page number(s) using the “insert page number” icon.

Next Step

Step 6: Close Setup,

Once you click OK, the page numbers will automatically be added to each page. You can then close the Page Setup dialogue box.

Next Step

Step 7: Confirm & Save,

You can conveniently verify page numbers by accessing Print Preview, ensuring all pages display them correctly. Once confirmed, save the changes in your Excel file to have consistent page numbers appear whenever the document is printed.


In conclusion, knowing how to insert page numbers in Excel can greatly improve the organization and professionalism of your spreadsheets. Whether you’re working on a large project or simply want to make your document easier to navigate, page numbers provide a clear reference point for your data. By following the step-by-step instructions outlined in this blog post, you can confidently add page numbers to your Excel sheets, enhancing the overall user experience for yourself and anyone else who may be accessing your workbook. So, go ahead, give it a try, and enjoy the benefits of a well-structured and easily navigable Excel workbook.

Table of Contents