How to Add Page Number in Excel

HomeExcel BasicsHow to Add Page Number in Excel

Like other Microsoft Office applications such as Word or PowerPoint, Excel also has the feature to insert page numbers while printing the Excel worksheets.

Users can insert page numbers per sheet or to multiple sheets at once in Excel and can also customize the same.

We have mentioned some quick and easy steps for you to add or remove the page numbers in Excel.

Add Page Numbers Using Header & Footer

  1. First, go to the “View” tab and then click on the “Page Layout” icon under the “Workbook views” group.
    1-page-layout-icon
  2. After that scroll down the sheet and click within the “Footer” column (Left, Center, Right) based on which side of the page you want to display the page numbers.
    2-footer-column
  3. Now, go to the “Design” tab and click on the “Page number” or “Number of pages” icon to add the page numbers.
  4. Or click on the “Footer” icon and select the page number printing style you want to add.
    3-page-numbers-icon
  5. Once you select the page number option which you want to add and print, Excel adds that page number to the worksheet in the form of codes.
    4-page-numbers-code1
  6. In the end, click anywhere outside the “Footer” to display the page numbers.
    5-display-page-numbers

To come back to the normal view after adding the page numbers using Header & Footer option, click on the “normal view” icon on the below status bar on the Excel sheet.

excel-status-bar

Add Page Numbers Using Page Setup Dialog Box

When users have data in multiple sheets within a workbook and want to print that data in a continuous series, they can add page numbers to all the sheets in one go with the help of the “Page Setup Dialog Box” option.

  1. First, open the workbook and select the sheets which you want to print (select multiple sheets)
    7-select-multiple-sheets
  2. After that, go to the “Page Layout” tab and click on the “page setup” dialogue launcher.
    8-page-layout-tab
  3. Now, select the “Header/Footer” tab in the “Page Setup” window.
  4. In the end, click on the Footer drop-down arrow and select the page number printing style which you want to display, and click OK.
  5. To view the Preview, click on the “Print Preview” button.
    9-page-setup-window
  6. Once you click OK, all the selected sheets will get the page numbers in series starting from the first sheet first page

Customize the Starting Page Number

In Excel by default, the page number starts with page 1, but users have the option to change the starting number of the first page.

  1. First, go to the “Page Layout” tab and click on the “page setup” dialogue launcher.
    10-page-setup-dialouge-launcher
  2. After that, select the “Page” tab in the “Page Setup” window.
  3. Now, enter the number in the “First-page number” column from which you want to start your first-page number and click OK.
    11-customize-page-number

Add Different Page number Style for Odd and Even Pages

  1. First, go to the “View” tab and then click on the “Page Layout” icon under the “Workbook views” group.
    12-view-tab-page-layout
  2. After that scroll down the sheet and click within in the “Footer” column of the first sheet.
  3. Now go to the “Design” tab and tick mark the “Different Odd and Even Pages” icon on the ribbon
  4. In the end, select the page number printing style you want to display for odd number pages.
    13-footer-dropdown
  5. At this moment, your page numbers with the page number printing style you selected are added for odd number pages.
    14-odd-page-number
  6. Again, scroll the sheet to the next page i.e page number 2, and select the “Footer” column of that sheet.
  7. After that, repeat the same process, you just did on the first page “Footer” column for the odd page number pages.
  8. At this moment, your page numbers with the page number printing style you selected are added for even number pages.
    15-even-page-number
  9. Once you are done on both the odd and even footers, your odd and even numbers would get printed in two different styles based on the print page number styles you have selected.

Remove the Page numbers Using Header & Footer

  • First, open the “Header and Footer” options.
  • After that scroll down the Excel sheet and click in the “Footer” column where you have the page number code added.
  • Now, select the entire page number code and press delete.
remove-the-page-number

Remove the Page numbers Using Page Setup Dialog Box

  1. First, go to the “Page Layout” tab and click on the “page setup” dialogue launcher.
  2. After that, select the “Header/Footer” tab and click on the “Custom Footer” option.
    17-custom-footer-option
  3. Now select the “Odd Page Footer” or “Even Page Footer”, if you have different page number styles added for odd and even pages.
  4. In the end, select the entire page number code and press delete, and click OK.
    18-odd-even-page-footer