Lesson 14: How to insert a HEADER in Excel | How to insert an AUTOMATIC FILENAME in the header

In this lesson, I’m going to be showing you how to:

  1. Understand what a header is in Excel
  2. How to insert a header in Excel
  3. What is an automatic filename
  4. How to insert an automatic filename in the header

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Or go back to:

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

18 thoughts on “Lesson 14: How to insert a HEADER in Excel | How to insert an AUTOMATIC FILENAME in the header”

    • Hello Syed – for this lesson a file will not be needed, hence I have not left a link for you. Follow the video lesson and you can add a header to any excel file, even a blank spreadsheet. All the best 🙂

      Habib (ICT tutor)

      Reply
  1. I always learn something new here. This is great to brush up on Excel!I used it years ago, and I am now beginning to use it again. These tutorials are really helping me.

    Reply
    • You are our regular user of our site Christine, and we welcome you always. Let me know if you have any questions you need help with. Headers and automatic filenames are great to use in excel. Take care

      Habib (ICT Tutor)

      Reply
  2. Hey there 🙂
    Very informative post I have to say. It is not often to come across videos and posts related to Ms-Office programs, especially Ms-Excel, since it is hard. I know because I use word and excel in our office and even though I know so little, I am better than everyone else 😛
    However, what you have provided here is something I didn’t know, and I thank you for that.

    Good luck!
    Azimi.

    Reply
    • You are very welcome. I recommend you show everyone at work in your office our site and YouTube channel, they can soon learn many skills of Excel, very easily as you have done – sharing is caring, lets get wiser together 🙂

      Habib (ICT Tutor)

      Reply
  3. This is a great article. The video is very informative for anyone wanting to learn about excel. I thought I knew quite a lot about excel, however, after watching your video, I realised there is so much I do not know. I look forward to more quality content.

    Reply
    • Happy to hear you thought it was a quality tutorial and you learnt about the Header in excel, and adding an automatic filename in the header of excel. I do recommend starting from lesson 1 though, to make the most of my lessons in Excel. I will be creating many more tutorials, covering all software of Microsoft Office. Take care

      Habib (ICT Tutor)

      Reply
    • Happy to hear you thought it was a quality tutorial and you learnt about the Header in excel, and adding an automatic filename in the header of excel. I do recommend starting from lesson 1 though, to make the most of my lessons in Excel. I will be creating many more tutorials, covering all software of Microsoft Office. Take care

      Habib (ICT Tutor)

      Reply
  4. Thank you so much for this highly informative article, Habib! You did an excellent job of breaking down the process of inserting a header and automatic filename in the header. I’m a very visual learner, and as such, I find that following along as someone demonstrates the process makes things easier for me to understand. I have saved your article and will definitely share it with my friends and family. God bless you!

    Reply
    • Thank you for your feedback – visually following someone demonstrating is the best way to learn. I will be creating many more tutorials and putting them up on our site and our YouTube channel. So don’t forget to bookmark and subscribe to our channel. The care

      Habib (ICT Tutorial)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap