How to Insert Page Numbers?

It is very easy for you to insert page number in Excel. We are going to do it together.

How to insert text?

You would follow us as we insert a page number.

Click on insert

ribbon insert Page Number

Click on text on the right side.

ribbon text Page Number

Adding a footer

Choose "Header and Footer", after clicking on the arrow beneath the text in step two.

header and footer Page Number

Click on Number of pages

ribbon pages number

Note: Click on number of pages if you'd have multiple pages.

Click on an empty cell in any of the columns.

empty cell Page Number

Note: The 0 was showing &[pages] prior to clicking on an empty cell.

The View Ribbon menu

Alternative method is to start from View menu in the Ribbon.

The full path would be: View > Page Layout.

The next step is to scroll down. At the bottom of the page select Click to add footer option.

From the Design Ribbon menu pick Page Number and Number of Pages options this time.

In the footer you should see &[Page]&[Pages] now. My proposal is to format it. I prefer &[Page] out of &[Pages].

At this point you can add more information to the Footer such as:

  • Current Date
  • Current Time
  • File Path
  • File Name
  • Sheet Name
  • Picture

After you are done go to the Ribbon again and swith the view by clicking View > Normal.