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.

dataset

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


Download Practice Workbook


5 Ways to Print Page Number in Excel

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.

insert tab

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.

header

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

header

➤ 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.

print page number in excel

➤ Scroll down.

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

print page number in excel

Read More: How to Print Selected Area in Excel (2 Examples)


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.

header and 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.

print page number in excel

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

print page number in excel

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

print page number in excel

➤ 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 Page 1 format.

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

print page number in excel

Related Content: How to Print Excel Sheet with Header on Every Page in Excel (3 Methods)


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.

print page number in excel

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 Header 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.

print page number in excel

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.

print page number in excel

Related Content: How to Adjust Print Settings in Excel (8 Suitable Tricks)


Similar Readings:


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.

print setup

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 Header 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.

page setup

Now, In the print preview, you will see the page number has been printed at the top of the page.

print page number in excel

Read More: How to Print Selected Cells in Excel (2 Easy Ways)


5. Print Page Number by Inserting Code

You can also print the page number of your Excel sheet by manually inserting a code for the page number. First,

➤ Go to the View tab and select Page Layout.

print page number in excel

As a result, you will see the header sections at the top of your sheet.

➤ Type the following code in one of the header sections,

=&[Page]

It will insert the page number in your Excel spreadsheet.

print page number in excel

➤ 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.

print page number in excel

➤ Scroll down.

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

print page number in excel

Related Content: How to Display Print Preview with Excel VBA (3 Macros)


Conclusion

I hope now you know how to print the page number in Excel. If you have any confusion, please feel free to leave a comment.


Related Articles

Prantick

Prantick

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo