How to Print Page Number in Excel (5 Easy Ways)

When you print an Excel sheet, you may want to print the sheet with page numbers. In this article, I’ll introduce you to 5 easy ways to print the page number in Excel.

Suppose, you have the following dataset where you want to print the page number.

Print Page Number in Excel: 5 Easy Ways

1. Print Page Number from Insert Tab

The easiest way to print a page number is to add a page number from the Insert tab. First,

➤ Go to Insert > Text and select Header & Footer.

It will add an extra tab in your Excel file named Header & Footer and your Excel datasheet will be shown in the Page Layout view. You can see, one of the header sections is automatically selected. Now,

➤ Click on Page Number from the Header & Footer tab.

It will add the code for page number- &[Page] in the selected header section.

➤ Click somewhere else in the Excel sheet.

You will see a page number will appear in the place of the code for the page number.

➤ Scroll down.

You will see page number is also printed on the other pages of your Excel spreadsheet.

2. Print Page Number in Excel Built-in Formats

There are a number of header and footer formats in Excel. You can print a page number in your Excel sheet from these built-in header and footer formats. First,

➤ Go to Insert > Text and Select Header & Footer.

It will add an extra tab in your Excel file named Header & Footer and your Excel datasheet will be shown in the Page Layout view. You can see, one of the header sections is automatically selected. Now,

➤ Click on Header from the Header & Footer tab.

As a result, a drop-down menu will appear where you can see different in-built header formats.

➤ Select one of the formats from the menu.

In this example, I’ve selected Page 1 of ? format.

You will see the page number is printed in that selected format.

You can also print the page number in the footer section.

➤ Click on Footer from the Header & Footer tab.

As a result, a drop-down menu will appear where you can see different in-built header formats.

➤ Select one of the formats from the menu.

In this example, I’ve selected the Page 1 format.

As a result, you will see Excel will print the page in that format at the footer section.

3. From Page Layout Tab

You can also print the page number of your Excel worksheet from the Page Layout tab. First,

➤ Go to the Page Layout tab and click on the little arrow icon from the bottom right corner of the Page Setup ribbon.

As a result, the Page Setup window will appear.

➤ Go to the Header/Footer tab, in the Page Setup window.

➤ Select a Header format from the box.

You can also select the format from the Footer box if you want to print the page number in the footer section. At last,

➤ Click OK on the Page Setup window.

As a result, the page number will be printed in your selected format in the header section of your worksheet. You can see the page number by selecting Page Layout from the View tab.

4. Insert Page Number While Printing

You can insert the page number just before printing the Excel sheet. So, when you will print the sheet, the sheet will be printed with the page number. First,

➤ Press CTRL+P to open the Print tab and click on Page Setup.