Ever wanted to add a footer to your Excel spreadsheet? You can add a custom footer using Excel Macros!

Make sure your Excel has the Developer Tab enabled following this tutorial.

I explain how you can do this below step by step!

What does it do?

Adds a custom footer with your text

Copy Source Code:

Sub AddCustomFooter()

Dim inputText As String
inputText = InputBox("Enter your text for the custom footer", "Custom Footer")

'Add your custom text to the right footer
With ActiveSheet.PageSetup
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = inputText
End With

End Sub

Final Result: 

Add Custom Footer

Exercise Workbook:


STEP 1: Go to Developer > Code > Visual Basic

Add Custom Footer


STEP 2: Paste in your code and Select Save. Close the window afterwards.

Add Custom Footer


STEP 3: Let us test it out!

Go to Developer > Code > Macros

Add Custom Footer

Make sure your macro is selected. Click Run.

Add Custom Footer


STEP 4: Type in your custom footer, click OK.

Add Custom Footer

To check if the footer did get added, go to File > Print:

Add Custom Footer

Now you should be able to see your text on your footer!

Add Custom Footer


How to Add Custom Footer Using Macros In Excel


Free Excel Macros & VBA Webinar Training

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn