How to Edit Footer in Excel (3 Quick Methods)

Footers are very important to keep track of your document. Sometimes, you might need to edit your footer in Excel to redo a mistake or for any other reason. This article demonstrates 3 methods of how to edit footer in Excel.


Download Practice Workbook

You can download the practice workbook from the link below.


3 Methods to Edit Footer in Excel

Suppose, you have a dataset of a school. Its’ Left Footer, Center Footer, and Right Footer indicate the Standard, School Name, and Date Published respectively. Now, you want to edit them and want “Standard 2”, “Mount School” and “06 June 2021” to be the new left, center, and right footers in that particular order. Here, I will show you 3 quick methods to do so.

how to edit footer dataset


1. Edit Footer from Page Layout View

With the help of Page Layout View, you can do this in one of the fastest ways possible. Now, follow the steps below to edit your footer.

Steps :

  • First, go to the View tab at the top of your screen.
  • Then, select Page Layout to shift to the Page Layout view.

using page layout view

  • Or, you can ignore the above steps and click the Page Layout button at the bottom right to directly shift to the Page Layout view.

using page layout view

  • Finally, scroll down to the footer of the page and edit it as you wish. In this case, Left Footer = Standard 2, Center Footer= Mount Elementary & Right Footer= 06 June,2021.

using page layout view

Read More: How to Insert a Footer in Excel (2 Suitable Ways)


2. Using Page Setup Dialog Box to Edit Footer in Excel

Another way to edit your footer is to use the Page Setup dialog box. Now, follow the steps below to edit your footer.

Steps:

  • First, select the Page Layout tab at the top of the page.
  • Next, click on the small Page Setup icon to open the dialog box.

using page setup dialog box

  • At this point, go to Header/Footer > Custom Footer…

how to edit footer in excel using page setup dialog box

  • Here, put your left, center and right footers in the left, center and right sections respectively.
  • After that, click on the OK

using page setup dialog box to edit footer in excel

  • Finally, click the OK button one more time and you will be done editing your footer.

using page setup dialog box

Read More: How to Edit Header in Excel (6 Easy Methods)


Similar Readings


3. Applying VBA Code to Edit Footer in Excel

Using VBA code is always a fun and handy option to perform any task in Excel. You can follow the steps below if you wish to edit your footer using VBA code.

Steps:

  • At the very beginning, press ALT + F11 to open the VBA
  • Then Right-Click on Sheet 4 or the sheet you are working on.
  • Next, select Insert > Module.

using vba code to add footer in excel

'This Code Will Help You to Edit Footer in Excel
Sub EditFooter()
'Change "Standard 2" to give your Left Footer
 ActiveSheet.PageSetup.LeftFooter = "&L Standard 2"
 'Change "Mount School" to give your Center Footer
 ActiveSheet.PageSetup.CenterFooter = "&C Mount School"
 'Change "06 June,2021"  to give your Right Footer
 ActiveSheet.PageSetup.RightFooter = "&R 06 June,2021"
End Sub

using vba to add footer in excel

  • Finally, press F5 to run the code and you have your footer edited.

Read More: How to Edit Macros in Excel (2 Methods)


How to Completely Remove Footer in Excel

Using the Page Setup dialog box you can completely remove the footer from your page in Excel. If you wish to do so, you may follow the steps below:

Steps:

  • First, select the Page Layout tab at the top of the page.
  • Next, click on the small Page Setup icon to open a Dialog Box.

using page setup dialog box

  • At this point, go to Header/Footer.
  • Then, click the down arrow on the Footer menu and select (none) from all the options.
  • Finally, click OK and this will remove the footer completely.

remove footer

Read More: How to Remove a Header in Excel (4 Methods)


Why Can’t I Access My Footer?

There are two reasons that might stop you from accessing your footer. The reasons and their solutions are as follows:

  • You are in the Normal view. To access your footer, you have to go to the Page Layout view.
  • Second, the margin of your page might not be set right. Go to Page Setup>Margins to edit your margins.

Why Can’t I Exit My Footer?

Sometimes, we might not figure out how to exit the footer option. So, if you are stuck at the footer like the figure below, follow the steps to get out of it.

exit footer

Steps

  • First, press ESC on your keyboard.
  • Next, switch to Normal view by clicking the Normal view button at the bottom right.

exit footer


Conclusion

Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. If you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo