Prantick Bala
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.
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.
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 Keep Header in Excel When Printing (3 Ways)
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 Page 1 format.
As a result, you will see Excel will print the page in that format at the footer section.
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.
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.
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.
Related Content: How to Adjust Print Settings in Excel (8 Suitable Tricks)
Similar Readings
- Excel VBA: Set Print Area for Multiple Ranges (5 Examples)
- Print Titles in Excel Is Disabled, How to Enable It?
- Excel Button to Print Specific Sheets (With Easy Steps)
- How to Print Horizontally in Excel (4 Methods)
- How to Print Gridlines with Empty Cells in Excel (2 Methods)
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.
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.
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 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.
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.
