Sometimes we need to execute the Excel sheet name code in footer. In this article, we will show you how to implement the Excel sheet name code in the footer with 3 easy approaches. We have also included some relevant concerns at the end of this article. So, let’s get started.
📂 Download Excel File
Download free workbook from here:
If you want to find the header and footer in Excel then you can need to see this part. You just follow the given steps.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, go to the Insert tab.
- Secondly, tap on Text.
- After that, you will find the Header & Footer options.
There is another way to find the header and footer in Excel.
- Firstly, select the Page Layout option.
- Secondly, tap on the Page Setup option.
- Now you will get a dialogue box name Page Setup.
- Here you will find Header as well as Footer options.
Truly, you can easily search for header and footer in Excel with these procedures.
While writing this article, “Excel Sheet Name Code in Footer”, we considered a dataset containing approximately 5 columns and 12 rows. In this dataset, we added Name, Client ID, City, and Country to make you better understand. But if you want, you can change the entities and put your own values.
Applying the INSERT tab in Excel is a very easy and simple procedure to add footer. You can easily do it if you follow the given steps carefully.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, go to the Insert tab.
- Secondly, click on Text.
- Thirdly, tap on Header & Footer option.
- Now you will see the worksheet below.
- Fourthly, scroll down on the page and click on the Footer.
- Now go to the Header & Footer tab.
- Click on Sheet Name option on the top ribbon.
- Then click anywhere on that sheet.
- Finally, you will see that your sheet name (Approach 1) has been added to the footer.
Undoubtedly, this is a very handy procedure to Excel sheet name code in the footer.
2. Using Page Setup Feature
You can also achieve the process by using the page setup feature in Excel. To do this you just need to maintain the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, select the Page Layout tab.
- Secondly, click on the Page Setup option.
- Now you will get a dialogue box name Page Setup.
- Click on Custom Footer.
- Then you will get a dialogue box name Footer.
- Select Insert Sheet Name and then click on the OK button.
- Now tap on the Print Preview button.
- Consequently, you will get the sheet name as footer.
Indeed, this is a very easy way to Excel sheet name code in footer.
3. Using VBA Code
Applying VBA code is a very useful technique for Excel sheet name code in the footer. Follow the given steps and you will obtain the process.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, go to the Approach 3 sheet.
- Secondly, right-click on the sheet name.
- Thirdly, tap on View Code.
- Now you find a VBA window there.
- Fourthly, paste the below code there.
Code
Sub apply_vba()
Dim Myworksheet1 As Worksheet
Set Myworksheet1 = Worksheets("Approach 3")
With Myworksheet1.PageSetup
.CenterFooter = "&A"
End With
End Sub
- Now you will see a picture like below.
- Fifthly, press Ctrl+P.
- Eventually, you will find the required result.
Truly, this is a very easy approach to Excel sheet name code in the footer.
If you want to exit or remove the header and footer in Excel, then this portion is for you. It is not a difficult task. You can easily achieve the process by maintaining the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, go to the Excel worksheet.
- Secondly, select Page Layout and then Page Setup.
- Now you will get a dialogue box name Page Setup.
- Select (none) in the Header option box.
- Then select (none) in the Footer option.
- Thirdly, press the OK button.
- Finally, the desired result will appear to you.
Undoubtedly, this is a very easy way to exit or remove the header and footer in Excel.
📄 Important Notes
You should be aware of the following things while performing the processes mentioned above:
🖊️ You need to be careful while decorating the page setup in Excel.
🖊️ While using the VBA code you should be conscious.
📝 Takeaways from This Article
You should be aware of the following things while performing the processes mentioned above:
📌 Primarily, we have used the Insert tab to Excel sheet name code in the footer.
📌 Secondly, we tried to decorate the page setup in Excel.
📌 Belatedly, we applied the VBA code to add a footer in Excel.
📌 Finally, we tried to show you how to exit or remove the header and footer in Excel.
Conclusion
We wish that you would be able to implement the Excel sheet name code in the footer using this article. As several methods have been shown here, you can easily follow which one is best suited for you. If there is any skepticism in your mind, feel free to ask me in the comment. In the end, to learn more about Excel tactics, we recommend you to visit our website www.ExcelDen.com.