3 Ways to Insert Excel Sheet Name Code in Footer

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:


Where Is Header and Footer in Excel?

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.

Applying the Insert option to find the Excel header and footer

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.

Applying the page setup option to find the Excel header and footer

  • 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.


Learn to Insert Sheet Name Code in Footer in Excel with These 3 Approaches

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.

Dataset of Excel sheet name code in the footer

APPROACH

1. Using Header and Footer Option from Insert Tab

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.

Using the Insert tab to Excel sheet name code in the footer

  • 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.

Applying Header & Footer tab to the Excel sheet name code in the footer

  • Then click anywhere on that sheet.
  • Finally, you will see that your sheet name (Approach 1) has been added to the footer.

Result of using the Insert tab to Excel sheet name code in the footer

Undoubtedly, this is a very handy procedure to Excel sheet name code in the footer.

APPROACH

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.

Using the page setup feature to Excel sheet name code in the footer

  • Now you will get a dialogue box name Page Setup.
  • Click on Custom Footer.

Page setup dialogue box

  • 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.

Result of using page setup feature to Excel sheet name code in the footer

Indeed, this is a very easy way to Excel sheet name code in footer.

APPROACH

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.

View code option to sheet name in the footer

  • 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

VBA code to add sheet name in the footer

  • Now you will see a picture like below.

  • Fifthly, press Ctrl+P.
  • Eventually, you will find the required result.

Result of using VBA code to insert sheet name in the footer

Truly, this is a very easy approach to Excel sheet name code in the footer.


How to Exit Header and Footer in Excel

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.

Using the page setup option to remove the header and footer in Excel

  • 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.

(Visited 37 times, 1 visits today)
Jonayed

Jonayed

Hello! My name is Jonayed. I've completed my graduation from BUET in Naval Architecture & Marine Engineering. As Excel is very interesting to me, I like to do various types of research regarding Excel. My inquisitive nature drives me to find solutions to different types of problems with Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo