How to Show Page Number in Excel Background (2 Ways)

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.

how to show 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.

Steps:

  • Firstly, go to the View tab from the Ribbon.
  • Following that, click on the Page Layout option from the Workbook Views group.

Using the Page Layout Option from View Tab to Show Page Number

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.

Selecting page number option to show page number in Excel background

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.

Final output to show only page number in Excel background


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:

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

Selecting the Number of Pages option to show page number in Excel background

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.

Final output to show page number with total pages in Excel background

Read More: How to Insert Page Number in Excel (7 Easy Methods)


Similar Readings


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.

Steps:

  • Firstly, from your worksheet use the keyboard shortcut ALT + P + SP to open the Page Setup dialogue box as shown in the following image.

Utilizing the Page Setup Dialogue Box Show Page Number 

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

Final output to show page number in Excel background


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:

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

Final output to show the page number with total pages in Excel background

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.

How to Add Page Number from the Desired Number in Excel

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

Choosing 2nd option to show page number in Excel background

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!


Related Articles

Zahid

Zahid

Hello and welcome! Thank you for visiting my profile. I am currently employed as an Excel & VBA Content Creator at ExcelDemy. My most recent academic qualification is a BSc (Eng) from the Bangladesh University of Engineering and Technology. Industrial and Production Engineering was my major. I constantly attempt to think creatively and find a simple answer.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo