In this lesson, I’m going to be showing you how to:
- Understand what a header is in Excel
- How to insert a header in Excel
- What is an automatic filename
- 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
Hello Habib,
I did not find any link to download this lesson… 🙁
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)
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.
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)
This is a great video! Your videos are very informative and easy to follow. I am going to share them and bookmark them to save for later. Thanks!
Thank you for your feedback Melissa – great idea to bookmark our site, and oh yeah here is our YouTube channel – feel free to subscribe, we have all video tutorials and many more there too: https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg
Habib (ICT Tutor)
Thank you for this video tutorial Habib, I’ve been struggling to get a header into my spreadsheets on excel and this explained it perfectly!
Happy to hear it and happy to help – if you need to know anything else you know where our site is. Please start from lesson 1 to make the most of my lessons.
Habib (ICT Tutor)
This is great. As a beginner to Excel,
This article and especially the video helped me heaps.
I am going to use these tips to insert headers on my own work now in EXcel.
Awesome post. Thank you
Good to know Ritchie – it is always a nice feeling helping someone out. This was one of the main reasons we created our website and YouTube channel: https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg
I will be creating many more tutorials so check them out.
Habib (ICT Tutor)
Happy to hear it and happy to help – if you need to know anything else you know where our site is. Please start from lesson 1 to make the most of my lessons.
Habib (ICT Tutor)
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.
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)
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.
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)
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)
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!
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)