How to Add Page Numbers in Excel: Step-by-Step (2024)

Yes! You heard that right.

In this guide, we will be telling you how to add page numbers to Excel. It might sound new to you if you haven’t done that before. But it’s going to be interesting📝

So, let’s not wait any more, and jump right into the guide below.

Insert page numbers in Excel

To insert page numbers in Excel, follow the steps below.

  1. Go to the sheet where the page numbers are to be inserted.
  2. Go to the View tab > Page Layout View.
Page layout view from page setup group

This will mess up your entire Excel sheet suddenly😝

Applying the page layout tab

But keep your calm, Excel has only divided the sheet into pages (as they would be when you print it).

Note that after each page, there comes a footer. This footer is divided into three portions where you can add the page number🧐

  1. Click on any part of the footer (1st, 2nd, or 3rd). We will add the page number to the center part so we are activating the same.
add footer / custom footer
  1. Go to the Header & Footer Tab > Page Number.
Page number in the footer elements group

Clicking on this will add the Page number in the selected portion of the footer. You’d see it added as the code &[Page].

Clicking on the Page number button will only add the page number of the current page to the footer💡

Kasper Langmann, Microsoft Office Specialist
  1. Hit Enter to see the page number added.
starting Page number added

To add the page number in the style “1 of 11” where the current page number and the total page numbers, both are displayed, follow these steps📊

  1. Go to the footer.
  2. Press the Page Number Button. This will add the current page number to the footer.
  1. Hold down the Control key and go to the Header & Footer Tab > Number of Pages.

This will add the total page numbers in the sheet to the Footer. You’d see it added as the code &[Pages]🎯

  1. Manually add space between the code and write “of” in between the page numbers.

The code should now look like below.

&[Page] of &[Pages]

Code for sheet tab / page tab
  1. Hit Enter, and here’s what the Page number looks like.
Page setup dialog box 1 of 2
  1. Let me take a moment to show you how the page numbers appear when you print the Excel sheet.
Print Preview for normal view

That’s how you can number different pages in your Excel sheet in one go🚴‍♂️

Pro Tip!

After you’ve added the page number to the footer on the first page, make sure you have page numbers in the same format added to all the pages in your sheet:

Go to the footer > Go to the Header & Footer tab > Uncheck the option Different First Page.

That’s it – Now what?

That’s all about adding page numbers to an Excel worksheet, folks. The above guide discusses how to add footers to a page in Excel that will be applied to all the pages in Excel😎

And when printed, you’d find these page numbers printed on each page.

With that, why only page numbers? Excel has a variety of other tools, functions, and features that’ll equally inspire you.

Some of my favorite Excel functions include the VLOOKUP, SUMIF, and IF functions.

My 30-minute free email course will help you learn these (and many more) functions in no time. So enroll now and go learning.

Other resources

Want to learn how to insert and remove page breaks in Excel? Hop on here to read our blog on it.