Zahid Hasan
While working in Excel, it is crucial to show page number in Excel background. By showing page number in Excel, we can visualize what contents will be on each page after we print the worksheet. In this article, we will learn about 2 simple methods to show page number in Excel background.
Download Practice Workbook
2 Simple Methods to Show Page Number in Excel Background
The procedure to show page number in Excel is a bit different than other office applications. But don’t worry! This article is here to help you to do this without facing any difficulties.
In the following dataset, we have a Loan Payment Chart. Our goal is to show the page number in Excel background.
1. Using the Page Layout Option from View Tab to Show Page Number
Using the Page Layout option from the View tab is one of the easiest methods to show page number in Excel background. Here, we are going to see 2 examples of each method to show the page number.
Example 1: Showing Only the Page Number
In the first example, we will show only the page number in Excel background. Let’s follow the steps mentioned below.
- Firstly, go to the View tab from the Ribbon.
- Following that, click on the Page Layout option from the Workbook Views group.
Consequently, you will see that options to Add header and to Add footer are available on your worksheet.
- Now, click on the Add footer option as we are going to add the page number at the bottom of the pages.
Note: You can choose Add header if you want to show the page number on top of the pages.
After clicking on the Add footer option, the Header & Footer tab will be visible on the Ribbon as marked in the following image.
- Subsequently, click on the Header & Footer tab.
- Next, select the Page Number option from the Header & Footer Elements group.
Consequently, you will see the following output on your screen.
- Finally, click on any cell of the worksheet and you will see the page number is added in Excel background as demonstrated in the following image.
Example 2: Displaying Page Number with Total Page Numbers
In the second example, we will show page numbers along with the total number of pages in the worksheet. To do this, let’s follow the steps discussed below.
Steps:
- Firstly, follow the steps mentioned in the previous example to get the following output.
- After that, type in of beside &[Page] in the footer box.
- Then, click on the Number of Pages option as marked in the picture given below.
Consequently, you will see the following output on your worksheet.
- Finally, to show the page number in Excel background, just click on any cell of the worksheet.
Read More: How to Insert Page Number in Excel (7 Easy Methods)
Similar Readings
- How to Insert Page Number Using VBA in Excel (3 Macros)
- How to Remove Page Number from Page Break Preview in Excel
2. Utilizing the Page Setup Dialogue Box to Show Page Number
Utilizing the Page Setup dialogue box is another efficient to show page number in Excel background. Again, we will see 2 variations to show the page number.
Example 1: Showing Only the Page Number
In the first example, we will see how we can show only the page number in Excel background. Let’s follow the procedure discussed below.
- Firstly, from your worksheet use the keyboard shortcut ALT + P + SP to open the Page Setup dialogue box as shown in the following image.
- Following that, go to the Header/Footer tab in the Page Setup dialogue box.
- Then click on the drop-down option as marked in the image given below.
- Subsequently, select the 1st option from the drop-down.
- Finally, click on OK.
As a result, the page number will be shown in Excel background as demonstrated in the following picture.
Example 2:Â Displaying Page Number with Total Page Numbers
In the last example, we will show the page number along with the total number of pages in the worksheet. It’s not a difficult thing to do. Just follow along.
Steps:
- Firstly, follow the steps mentioned in Example 1 of the 2nd Method to obtain the following output.
- Subsequently, choose the 2nd option from the drop-down as marked in the below-given image.
- Lastly, click OK.
Consequently, you will see that the page number is shown in Excel background like in the image below.
Read More: How to Insert Sequential Page Numbers Across Worksheets
How to Add Page Number from the Desired Number in Excel
By default, Excel adds page number from 1 in the worksheet. But sometimes we need to add page numbers from a different number than 1. Excel allows us to do this. In this portion of the article, we will learn some simple steps to add page number from the desired number in Excel.
Steps:
- Firstly, from your worksheet, use the keyboard shortcut ALT + P + SP and the Page Setup dialogue box will open as shown in the following image.
- Now, in the Page Setup dialogue box, insert your desired number in the box of the First page number. In this case, we have used the number 11.
- Following that, click on the Header/Footer tab as marked in the picture below.
As a result, the following options will be visible to you.
- Then, click on the drop-down icon and choose the 1st option from the drop-down.
- Finally, click OK.
There you go! In this way, you can add a page number from the desired number in Excel.
Read More: How to Insert Page Number in Excel Cell Not in Header
💡 Things to Remember
- One thing to keep in mind is that you can only see these page numbers in the Page Layout View. In Normal View, you will not be able to see the page numbers.
Conclusion
Finally, we have come to the end of the article. I sincerely hope that this article was able to guide you to show page number in Excel background. Please feel free to leave a comment if you have any queries or recommendations for improving the article’s quality. To learn more about Excel, you can visit our website, ExcelDemy. Happy learning!
