Insert page numbers into footer

This tutorial shows how to insert page numbers into a footer in a specific sheet using Excel and VBA

EXCEL METHOD 1. Insert page numbers into footer

EXCEL

Insert tab > Text group > Header & Footer > Select footer area > Design tab > Header & Footer Elements group > Page Number > Click anywhere on the sheet
1. Select the Insert tab. Select Insert tab
2. Select the Text group.
3. Click on Header & Footer. 		Select the Text group and click on Header & Footer
4. Select footer area in which you want to show the page number.
Note: In this example we have selected the center footer area. 		Select header area
5. Select the Design tab.
6. Click on Page Number in the Header & Footer Elements group. 		Select Design tab and click Page Number in Header & Footer Elements group
7. This will insert &[Page] in the selected footer area which will show the page number when you are working in the sheet.
8. Click anywhere on the sheet. 		Insert Page Number

VBA METHOD 1. Insert page numbers into footer using VBA

VBA

Sub Insert_Page_Numbers_Footer()
'declare a variable

Dim ws As Worksheet

Set ws = Worksheets("Sheet1")
With ws.PageSetup

.CenterFooter = "&P"

End With

End Sub

NOTES
Note 1: This VBA code will insert page numbers into the center footer area of "Sheet1".

RELATED TOPICS
Related Topic Description Related Topic and Description
Insert a header How to insert a header
Insert a footer How to insert a footer in a specific sheet
Insert page numbers into header How to insert page numbers into a header in a specific sheet