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.
Read More: How to Use Formula for Page Number in Excel
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.
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.
Now, In the print preview, you will see the page number has been printed at the top of the page.
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.
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.
➤ Click somewhere else in the Excel sheet.
You will see a page number 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.
Read More: How to Insert Page Number Using VBA in Excel
Download Practice Workbook
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.