How to Insert Page Numbers in Excel Worksheets

If your work involves printing your excel worksheets, it’s a good idea to insert page numbers in it.

Inserting page numbers in Excel takes a little more work as compared with other Microsoft applications such as Word or PowerPoint.

Watch Video – How to Insert Page Numbers in Excel

How to Insert Page Numbers in Excel

In this tutorial, you’ll learn how to insert page numbers in Excel worksheets.

  • How to Insert Page Numbers in Excel using the using the Page Layout View.
  • Insert Page Numbers in Excel Using the Page Setup Dialogue Box.
  • Start Page Numbering with the Desired Number.
  • Change the Order in which pages are numbered.
  • Remove Page Numbers from the Excel Worksheets.

Insert Page Numbers in Excel: Page Layout View

If you want to insert page numbers in all the pages of a worksheet, using the page layout view is the fastest way to do it.

Here is how to do this:

  • Go to View –> Workbook Views and select Page Layout.
    • You would notice that the way Excel spreadsheets is displayed has changed.How to Insert page Numbers in Excel Worksheets - View Pagelayout
  • Scroll Down to the end of the page where is says Click to add footer.How to Insert Page Numbers in Excel Worksheets - Click to Add Footer
  • There are three boxes in the footer. Click on the one where you want to insert the page number.How to Insert Page Numbers in Excel Worksheets - select box
  • As soon as you click on any of the boxes, the Header and Footer Tools Design tab appears.How to Insert Page Numbers in Excel Worksheets - Header Footer Tab
  • Go to Design –> Page Number.How to Insert Page Numbers in Excel Worksheets - Page Numbers
  • This will insert a code &[Page] in the box.How to Insert Page Numbers in Excel Worksheets - Page Number Code
  • Enter the word ‘of’ in front of the code and click on Design –> Number of pages. This will insert the code &[Pages].How to Insert Page Numbers in Excel Worksheets - Page Number with of
  • Click anywhere in the worksheet. Now the page numbers would be visible at the bottom of each page.

Note that these page numbers are visible only in the Page Layout view. You would not see it when you go back to the normal view. If you print the worksheet, the page numbers also get printed.

Have a Different First Page Footer

You may want to have a different text in the footer on the first page, and regular page numbers of other pages. For example, on the first page, you may want to have Company’s name/website or copyright info along with the page number.

Here is how to do this:

  • While in the Page Layout view, select the footer box in the first page where you want to insert the text.
  • With the box selected, go to Design –> Options and check the Different First Page option.How to Insert Page Numbers in Excel Worksheets - Different First Page
  • Enter the text that you want to display on the first page only. Let’s say, I want to show my website name in this case.How to Insert Page Numbers in Excel Worksheets - Different First Page Text
  • Click anywhere in the worksheet.

Now, whatever you have entered in the first page would only be visible on the first page and rest all the pages would show page numbers.

Have Different Odd and Even Pages Footer

If you want to have different page numbers for odd and even pages, you can easily do this using the inbuilt settings.

For example, you may not want to show page numbers on even pages.

Here is how to do this:

  • Go to View and select Page Layout view.How to Insert page Numbers in Excel Worksheets - View Pagelayout
  • Scroll down and select the footer where you want to insert the page numbers in Excel.How to Insert Page Numbers in Excel Worksheets - Click to Add Footer
  • Click on the box where you want to insert the page number.How to Insert Page Numbers in Excel Worksheets - select box
  • Go to Design –> Options and check Different Odd and Even Pages.How to Insert Page Numbers in Excel Worksheets - Different Odd and Even
  • Now when you click on the box on odd pages, in the bottom left, it would show Odd Page Footer. Enter the format in which you want the page numbers on odd pages. Similarly, enter the page number format on even pages, or leave it blank if you don’t want page numbers on even pages.

Insert Page Numbers in Excel: Page Setup Dialogue Box

You can also insert page numbers in Excel using the page setup dialogue box.

Here is how to do this:

  • Go to Page Layout tab –> Page Setup. Within the Page Setup Group, click on the dialogue launcher.
    • This will open the Page Set dialogue box.How to Insert Page Numbers in Excel Worksheets - Page setup DB Launcher
  • In the Page Setup dialogue box, select the Header/Footer tab.How to Insert Page Numbers in Excel Worksheets - PS Header Tab
  • In the Footer drop-down, select Page 1 of ? option. You will see the output format right below the drop-down.How to Insert Page Numbers in Excel Worksheets - PS Page 1 of
  • Click OK.

This will instantly insert page numbers in Excel. If you want to insert page numbers in on the active worksheet only, follow the above steps. If you want to insert page numbers in multiple worksheets, select all the worksheets (hold the SHIFT key and select the worksheet tabs) and then follow the above steps.

Start Page Numbering with the Desired Number

If you are printing a report which is a continuation of some other report, or which is a part of some the overall report, you may want to begin page numbers with a different numbers (instead of 1).

To do this:

  • Go to Page Layout tab –> Page Setup. Within the Page Setup Group, click on the dialogue launcher.
    • This will open the Page Set dialogue box.How to Insert Page Numbers in Excel Worksheets - Page setup DB Launcher
  • In the Page Setup dialogue box, within the Page tab, change the First Page Number field from Auto to the number that you want to show/print.How to Insert Page Numbers in Excel Worksheets - Start diff page

Change the Page Order while Numbering

If you have a large data set, by default, Excel would first insert page numbers to the all the sheets going down, and then move to the right and then number those sheets.

If you want to change the order, you can do this by following the below steps:

  • Go to Page Layout tab –> Page Setup. Within the Page Setup Group, click on the dialogue launcher.
    • This will open the Page Set dialogue box.How to Insert Page Numbers in Excel Worksheets - Page setup DB Launcher
  • In the Page Setup dialogue box, select the Sheet tab and change the page order from Down, then over to Over, the down.How to Insert Page Numbers in Excel Worksheets - Change Order

Remove Page Numbers

To remove page numbers:

  • Go to View and select Page Layout view.
  • Scroll down and select the footer where you see the page numbers.
  • You would notice that as soon as you click on the box with the page number, it would change into a code. Delete that code.
  • Click anywhere else on the worksheet.

Related Tutorials:
  • Sergio Mathias says:

    How to insert the page number & number of pages directelly in the worksheet?

  • >