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

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

  1. Understand what the Merge & Center feature does in Excel
  2. How to apply the Merge & Center feature to your text/cells in Excel
  3. What is the difference between: Merge & Center | Merge Across | Merge Cells

Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.

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 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Or go back to:

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

24 thoughts on “Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells”

    • Thank you Hannie for your lovely feedback.

      I like to keep it short, so it’s more engaging and to the point for all the learners out there.

      Best Wishes

      Habib (ICT tutor)

  1. Thank you so much for this fantastic tutorial, Habib! I have never utilized the merge center feature before, but you do an excellent job of breaking the process down, step by step. I’m a visual learner and find it much easier to learn techniques when I see them done in front of me. You explain things very well (very clear and concise), and I know that many people will appreciate your efforts. God bless you!

    • Thank you very much. I appreciate your kind words. Most of us are visual learners including myself, and we like to be shown step by step to do a particular task or learning a new skill. My videos are very easy to follow as you have recognised already. I will be creating many more video tutorials, so bookmark our site. Thank you

      Habib (ICT Tutorial)

  2. Hello Habib
    Thanks a million for this!
    I wish I knew about your video tutorials when I was studying for my MA.

    I found excel a little challenging and still do.

    Your tutorial on Merge and Center is very easy to understand.

    You explained it in such a way, that made it easy for me to understand.
    I will definitely come back for more.
    Thank you

    • Now you have found me, so don’t forget to bookmark our site and keep referring to my tutorials. Merge and centre is simple and very elegant feature. Thank you for the compliment. Take care

      Habib (ICT Tutor)

  3. Hi there,

    What a great function, I use it all the time, but it’s good to see the shortcuts and benefits to using it. One thing I’ve wondered is if there’s a way to separate them, e.g. sometimes I need to merge cells but not centre them. Is this possible?

    Keep up the good work.

    • Yes it is possible Sharon – you select the cells you want to merge and then click on the drop down arrow of the merge & center button and simply select the option – merge cells across. This will solve your question. Hope you find this useful and helpful. Take care

      Habib (ICT Tutor)

  4. I’m just now getting the hang of using Excel for my blog, so I needed to know that feature especially now that I’m making tables for my articles. So easy and convenient, I’m glad I learned this great feature today. Keep up the good work!

    • I’m glad I helped you out just at the right time 🙂 Many more tutorials are coming, so don’t forget to bookmark our site.

      Habib (ICT Tutor)

  5. I like this feature and it’s easy to do. You’re video breaks it down and explains how to perform the Merge & Center function. Video is so much better for explaining excel related functions compared to a lengthy blog post. Thanks for sharing this on video!

    • I agree, video tutorials are more visual and practical to follow, hence I have created numerous video tutorial lessons here on my website. I recommend you start from lesson 1. Take care

      Habib (ICT Tutor)

  6. Hello and thank you for this article! Wow, your videos make excel easy as peanuts. It is very precise and well-detailed. I am sure you will help a lot of people with these tutorials in Excel.

    I really like how you presented this article through videos. I specially like the formula and math part as I used excel a lot in my last job.

    • Thank you, and I’m hoping to help all my visitors to my site with my tutorials and my knowledge of Business & ICT. I will always breakdown the formulas and functions of Excel to everyday language so everyone can understand it easily.

      Habib (ICT Tutor)

  7. Hi,
    This is a great website! I really enjoy the idea of short videos explaining Excel and all for free.I have recently paid for an Excel course. I am gutted I haven ‘t found your website forehand.

    Kind regards,

    • Hi Yoana – Yes it is FREE. Other sites charge thousands of pounds for such education. So bookmark our site and look forward to many more FREE ICT tutorials like this one. I hope you have understood, what the merge and center feature is in Excel. If you need anymore clarification, please let me know.

      Habib (ICT Tutor)

  8. Thank you for explaining the functions very clearly. Many tutorials and training just browse through functions like these taking the basic knowledge for granted. But you explain even the small steps clearly.
    Keep up the great work.

    • Explaining any skill to gain knowledge is to always focus on the basics to build the foundation – when one understands the skill, like in this tutorial Merge & Center in Excel, then one can very easily carry out that skill. I always tell my students to focus on understanding the skill first.

      Thank you for the kind words. Keep coming on my site as many more tutorials will be uploaded like this one. Take care


  9. This is a good instructional video about the merge function in excel You explain the function and how to use it in a very clear and precise manner. Easy to follow and the temp is perfect.
    I can see that you also cover a lot of the other basic excel stuff in your other video tutorials. I will forward your tutorials to anyone I know of who has questions about excel, because of the easy to understand manner you explain the functions and how to use them.

    • Thank you for the lovely complimentary comment. To make the most of my video tutorials, please start from Lesson 1.

      Feel free to pass on to family and friends and let them benefit too in this lockdown. Take care Roy

      Habib (ICT Tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap