Insert a footer on first page only

This tutorial shows how to insert a footer on first page only in a specific sheet using Excel and VBA

EXCEL METHOD 1. Insert a footer on first page only

EXCEL

Insert tab > Text group > Header & Footer > Select footer area > Design tab > Options group > Check Different First Page checkbox > Enter footer > 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. Scroll to the bottom of the page and select a footer area.
Note: In this example we have selected the center footer area. 		Select footer area
5. Select the Design tab.
6. Check the Different First Page checkbox in the Options group. 		Select Design tab, click Different First Page in Options group
7. Enter a footer in the footer area.
8. Click anywhere on the sheet.
Note: In this example we have entered a footer of "Exceldome" in the center footer area. Therefore, in this example only the first page will display this footer. 		Enter first page footer

VBA METHOD 1. Insert a footer on first page only using VBA

VBA

Sub Insert_footer_first_page()
'declare a variable

Dim ws As Worksheet

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

.DifferentFirstPageHeaderFooter = True
.FirstPage.CenterFooter.Text = "Exceldome"

End With

End Sub

NOTES
Note 1: This VBA code will insert a footer of "Exceldome" in the center footer area of only the first page 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 a footer in all sheets How to insert a footer in all sheets
Insert a header and footer How to insert a header and footer at once in a specific sheet
Insert a header on first page only How to insert a header on first page only in a specific sheet