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.
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.
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.
- First, go to the View tab at the top of your screen.
- Then, select Page Layout to shift to the 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.
- 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.
Read More: How to Insert a 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.
- At this point, go to Header/Footer > Custom Footer…
- Here, put your left, center, and right footers in the left, center, and right sections respectively.
- After that, click on the OK
- Finally, click the OK button one more time and you will be done editing your footer.
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.
'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
- Finally, press F5 to run the code and you have your footer edited.
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.
- 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.
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.
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.
Steps:
- First, press ESC on your keyboard.
- Next, switch to Normal view by clicking the Normal view button at the bottom right.
Download Practice Workbook
You can download the practice workbook from the link below.
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.