How to Insert Page Number in Excel Cell Not in Header

Method 1 – Inserting Page Number in Excel Cell

Step 1: Open VBA Window

VBA has its own separate window. You must insert the code in this window, too.

To open the VBA window, click the Developers tab on your ribbon and select Visual Basic from the Code group.

Step 2: Insert Module

VBA modules hold the code in the Visual Basic Editor and have a .bcf file extension. You can create or edit one through the VBA editor window.

To insert a module for the code, go to the Insert tab on the VBA editor and click on Module from the drop-down menu.

A new module will be created.

Step 3: Insert VBA Code

Select the module if it hasn’t already been selected. Write down the following code in it.

Sub Page_Count()
    Dim xVCount As Integer
    Dim xHCount As Integer
    Dim xVBreak As VPageBreak
    Dim xHBreak As HPageBreak
    Dim xNumPage As Integer

    xHCount = 1
    xVCount = 1

    If ActiveSheet.PageSetup.Order = xlDownThenOver Then
        xHCount = ActiveSheet.HPageBreaks.Count + 1
    Else
        xVCount = ActiveSheet.VPageBreaks.Count + 1
    End If

    xNumPage = 1

    For Each xVBreak In ActiveSheet.VPageBreaks
        If xVBreak.Location.Column > ActiveCell.Column Then Exit For
        xNumPage = xNumPage + xHCount
    Next

    For Each xHBreak In ActiveSheet.HPageBreaks
        If xHBreak.Location.Row > ActiveCell.Row Then Exit For
        xNumPage = xNumPage + xVCount
    Next

    ActiveCell = "Page " & xNumPage & " of " & Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")

End Sub

Close the VBA window.

Step 4: Turn on Page Layout View

After you have inserted the code, turn on the page layout view before running the code.

The sheet will look like this.

Step 5: Run VBA Code

Select the cell where you want to put the page number in. We selected cell F34 for this.

Go to the Developer tab again. Select Macros from the Code group.

Select the Macro name you have just entered. The macro name was Page_Count.

Click on Run.

The page number will appear on the cell.

Method 2 – Inserting Page Number in Footer

2.1 Inserting Page Number from Page Layout View

Follow these steps to insert page numbers in Excel footers using the Page Layout view feature.

Steps:

• Go to the View tab on your ribbon.
• Select Page Layout from the Workbook Views group.

• The dataset will look like this.

• Select the place on the footer where you want to insert your page number.

• Tthe Header & Footer tab will appear on the ribbon. Select Page Number from the Header & Footer Elements.

The footer will now look like this.

• Click on another cell to have the page number in the Excel footer.

2.2 Inserting Page Number Using Page Setup Dialog Box

Steps:

• Go to the Page Layout
• Select the dialog box launcher on the bottom right of the Page Setup group, as the figure below.

• The Page Setup box will appear. Now select the Header/Footer tab in it.
• Select the style of how you want your page number to show on footers from the drop-down of the Footer section.

• Click on OK.
• If you are not in the Page Layout view, go to the View tab and select Page Layout from the Workbook Views.

This will also insert the page number in the Excel footer for all pages.

2.3 Inserting Page Number from Header & Footer Command

Steps:

• Go to the Insert tab on your ribbon.
• Go to the Text group.
• Select Header & Footer.

• The Page Layout view will automatically pop up.

• Select the footer position where you want to insert the page number.

• The Header & Footer tab will appear on the ribbon.
• Select Page Number from the Header & Footer Elements from the tab.

It will look like this.

• Click on a cell on the spreadsheet and you will see the page number on the Excel footer.

Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.

Related Articles

• How to Print Page Number in Excel
• How Start Page Numbers at Different Number in Excel
• How to Remove Page Number from Page Break Preview in Excel
• How to Insert Page Number Using VBA in Excel 

<< Go Back to Page Number  | Page Setup | Print in Excel | Learn Excel