Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

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

  1. Understand what the Wrap Text feature does in Excel
  2. How to apply the Wrap Text feature to your text/cells in Excel

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

Note: a NEW lesson 12 VIDEO is coming soon – sorry for the inconvenience

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 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

Or go back to:

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

78 thoughts on “Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?”

  1. I loved it all! You made your video extremely simple to follow and super helpful. Somehow I keep forgetting about the wrap text feature. I’ve used it so many times but forget to wrap my text. You just reminded me how important and fast it is to do, and how it’s visually going to make keeping track of my columns and rows easier.

    The thing about the wrap text is that I don’t have to change the with of each column, and instead I can use the wrap text to replace that option. Thank you for sharing!

    Reply
    • Excellent Michael – you have learnt a lot by watching my tutorial lesson on wrap text. Everything you have said is what I’ve discussed in the lesson. Well done 🙂

      Habib (ICT Tutor)

      Reply
  2. Thank you again Habib! Great post.

    This is becoming the go to for people learning Excel. It is such a great reference point and makes it so easy to learn.

    Will share with some friends. Keep up the great work,

    Kev

    Reply
    • You are welcome again Kev – always happy to help you out. Please do share with your friends and family and let them benefit too 🙂

      Habib (ICT Tutor)

      Reply
  3. That was one of the problems I had with excel, I couldn’t type enter and make a sentence go to the next line… So it was “wrap text” that I needed to do! Great tip! Now my report won’t look that shabby anymore

    Reply
    • Hi Kevin – this is the job of the wrap text feature, and this will stop your text going in a straight line in Excel. Your reports will look very professional now 🙂

      Habib (ICT Tutor)

      Reply
  4. That was one of the problems I had with excel, I couldn’t type enter and make a sentence go to a next line… So it was wrap text that I needed to do! Great tip! Now my report wont look that shabby anymore

    Reply
  5. Wrap text feature is very important to balance the table.
    This article is very easy to understand and easy for me.
    Keep up the great work.

    All the best

    Reply
  6. Another great tip! It’s so simple when you explain this. Normally I’m trying to figure it out myself using the HELP feature and that confuses me. Thanks again for sharing such each and effective tips!

    Reply
    • Happy to help Jamie – isn’t it great, when someone shows you how to do something so easily, like this wrap text feature in Excel Good work and don’t forget to complete all the lessons here.

      How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

      Reply
  7. Wow, that is a really neat feature! I really enjoy watching these tutorials they are easy to follow along with, so thanks for taking the time to make them. The things you can do in Excel is amazing compared to years ago, I can’t wait to see what you teach next.

    Reply
    • Hi Melissa, very happy to hear how much you are learning, in particular in this lesson about the wrap text featire in excel. The next tutorial is lesson 13lesson 13lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel? Go ahead and watch it.

      How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

      Reply
  8. These tips are so helpful! There are so many people who are so daunted by excel and have no idea where to start and see the potential of excel. Great post!

    Reply
    • Yes, and it is my job to make it simple for everyone. Excel is not daunting as one might think. Complete my free lessons starting from lesson 1, and you will become quite a pro very soon.

      Habib (ICT Tutor)

      Reply
  9. Thanks a million times for this tutorial.
    It is very easy to understand.
    I like the way you simplify the excel.

    I have found it very confusing.

    You have made it easy and I will definitely come back to your lessons.
    Thank you

    Reply
  10. Hello and thank you about this article, I used a lot of excel in my last work of 11 years and wrap a text is certainly one of the features that I used a lot until nowadays.

    I liked how you outlined the tutorials into small, detailed steps and with videos too.

    Reply
    • Its a lovely little feature wrap text isn’t it Lemuel.
      My tutorials are always going to be in small manageable chunks, so everyone can fully understand one skill at a time. Take care

      Habib (ICT Tutor)

      Reply
  11. Hi Habib, Thanks for the video. Exactly what I was looking for and easily explained. In nosing around your site, I’ve noticed all of the other informative training lessons that you have listed. Great!. I’ve passed this link on to my kids as a resource for any of their Excel creation needs. Thanks for making our lives easier, it’s nice to have things like this in one central location.
    Kerry

    Reply
    • That’s brilliant Kerry – now I’m helping your whole family, that’s a nice feeling. I will be doing many more tutorials for anyone of any age and skill level, who can follow and complete my tutorials easily. So I look forward to you and your family checking out all my lessons. I do recommend you start from lesson 1 to make the most of my tutorials.

      Habib (ICT Tutor)

      Reply
    • That’s brilliant Kerry – now I’m helping your whole family, that’s a nice feeling. I will be doing many more tutorials for anyone of any age and skill level, who can follow and complete my tutorials easily. So I look forward to you and your family checking out all my lessons. I do recommend you start from lesson 1 to make the most of my tutorials.

      Habib (ICT Tutor)

      Reply
  12. Hi Habib,
    I appreciate how you break everything down into simple steps by different function so it is not overwhelming for beginners to use Excel. I could learn a few things myself.

    Best regards,
    Sonia

    Reply
  13. I really learned a lot about Excel since starting to be a regular visitor to your blog, I was wondering is wrap text the best type of text to be using for my own blog? how does one get Excel, and if it expensive?

    Jeff

    Reply
    • Hi Jeff – your are welcome. I don’t think wrap text is available for the wordpress blog posts. You can get Excel from the Microsoft website, or any computer shop near you. The price can range quite a bit these days depending on which package you for. I hope I have answered your questions. Take care

      Habib (ICT Tutor)

      Reply
  14. You have an excellent website.

    I worked as a Data Analyst before entering the big world of Affiliate Marketing, so I spent a lot of time using Excel.

    The content is really interesting and engaging, and I like the layout, it made it really easy to read and the structure is great.

    I will definitely be returning for tips in the future.

    Thanks for the information and all the best.

    Reply
    • You are very welcome Adam and thank you for lovely feedback. All my ict tutorials are very engaging, everyone should feel as though they are in a class with me completing the task with ease. I recommends everyone to start with lesson 1 though, to make the most of these tutorials. Take care

      Habib (ICT Tutor)

      Reply
  15. Hi,
    I really like this video, so useful for people who don’t know how to use Excel.
    I will check the rest of your videos.
    Thank you .

    Reply
  16. Thank you for your clear explanation of the Wrap Text creature. I am normally struggling with the Excel program and I am giving my girlfriend very stupid questions about it.-:)

    After your clear explanation, I will much more skilled. And since now I know that if I need to find out something about Excel, I can always get to your website and see the solution there.
    Thank you for that!

    Reply
    • LOL – you wont have to give your girlfriend anymore answers you’re not quite sure of yourself. Bookmark my site, and everything will be here for your needs. The wrap text feature in Excel is an amazing button. Take care

      Habib (ICT Tutor)

      Reply
  17. Wow, great post on how to work with Excel. I’m bookmarking your YouTube channel, this is great info and I need this training. Thank you so much for showing us how easy it is in your video. I will be sharing this with my daughter and she is also sharing your YouTube channel.

    Reply
  18. Hello Habib, good post your have here, and good idea to have put a video to explain it. I find it easier to understand when there is a video.
    Thank you that.

    take care
    Lyne

    Reply
  19. This is great and you make it easy to follow. I’m so glad you have so many tutorials here. I’m heading back to the work force soon so I will bookmark your site for a refresher on Excel. Thank you!

    Reply
  20. I use excel a ton, and it is always great to learn something new about the platform that I didn’t before!

    I found your tutorial very easy to follow and interesting to me.

    Thank you for sharing!
    -Joseph

    Reply
  21. I’ve been working in the IT industry since 2004, more on an enterprise level and with VM servers. I have done a lot of desktop support also, but Excel has never been one of my forte’s. This is a well thought out and intuitive lesson. Nice work.

    Reply
    • Thank you, lovely compliment from somebody who has been working in desktop support for many years. I think my tutorials are most definitely benefitting everybody – that is my ultimate aim. Take care

      Habib (ICT Tutor)

      Reply
  22. Thank you so much for this helpful article! I just started using the Wrap Text function in Excel, and it definitely makes the document much easier to read. I appreciate you showing us how to wrap text, step by step. I’m a visual learner, so the video made the process much easier to understand. God bless you!

    Reply
    • You’re welcome. Visual learning is the nature of humans. When it is video tutorials, then it is even more easier. I’m happy you found my lesson on wrap text easy to follow and you’ve learnt from it.

      Habib (ICT Tutor)

      Reply
  23. Often the English terminology is confusing for me. Especially when it is about text and text features. Wrapping for me is like putting a nice paper around a present 🙂
    But now I know. Thanks.
    Do you have any idea if everything from Excel works the same in Google spreadsheets? Because I don’t have Excel!

    Reply
    • LOL – you made me laugh (so thanks, I needed that) – Google spreadsheets is little bit similar but nowhere near as good as Microsoft Excel. So I recommend you stick to Microsoft. Hope this helps. Take care

      Habib (ICT Tutor)

      Reply
  24. So glad I’ve found this walkthrough. I was tasked to do a project in excel for work and no idea how to use this product.

    Thanks to you I look like a an excel pro (well kind of) but seriously thank you for this easy to understand no-nonsense or technical jargon

    Reply
    • It is my pleasure Steven – Excel can be easy if explained correctly to somebody. My aim is to make excel as easy as possible for all my visitors. I am sure you’re quite a pro after completing all my tutorials on our site 🙂

      Habib (ICT Tutor)

      Reply
    • You’re welcome Angelique – lol no you don’t. I’m happy to be of help and make you understand about the wrap text button.

      Habib (ICT Tutor)

      Reply
  25. Thanks for sharing! I love Excel, but there’s so much I still need to learn. I’ll have to check out your other lessons too.
    I need to learn more about using different formulas for keeping up with rent from my rental properties.

    Reply
    • I recommend you start from Lesson 1, and complete all the lessons in this series. You will then become quite an expert. Any form of book keeping, excel is the package to use. Take care

      Habib (ICT Tutor)

      Reply
  26. Hi Habib – Great lesson on the Wrap Text. The video is easy to follow along with good illustration. I learned something new, I didn’t realize the “wrap text” button in the “Home” tab. I’ve been using the “format cell” and then selecting alignment – wrap text. Much faster to just hit the “wrap text” button! Thanks for sharing this post, I will be back to check out the other tutorials. All the best.

    Reply
    • your are very welcome Jeff – if we don’t know something, then we somehow find another long way solution. This is why it is best to learn from a qualified tutor like myself. Keep visiting our site and I will help you put right any other self taught methods you may have that is the long way round 🙂 You have a great day.

      Habib (ICT Tutor)

      Reply
  27. Hi Habib, thank you for the info. What if I have a lot of text on excel that needs to have the wrap text feature? Is there a way to do all at once? I hope my question makes sense. Thank you!

    Reply
    • Nice question – the answer is: Firstly merge the cells that you have the text in (watch lesson 11), then use the wrap text feature and the job will be done very easily and efficiently. Hope you find this very helpful. Let me know if you have any further question.

      Habib (ICT Tutor)

      Reply
  28. Thank you for this informative and helpful post.
    That will help me improve my skills in using Excel.
    All the best.

    Reply
  29. Thanks for sharing this site. As I am always working on excel. This will help me to speed up my workflow and spend less time on excel! Keep the knowledge coming, I am bookmarking the site now!

    Reply
    • Thank you for bookmarking our site – it will come very handy for you. I will be making many more video tutorials for your benefit, so keep on coming and watching them 🙂

      Habib (ICT Tutor)

      Reply
  30. I like videos that explain how to do excel functions. It so much easier for me to follow and this video explained everything I needed to know about the wrap text feature. The wrap text definitely makes cells that have a lot of text in them look better. Thanks for sharing this tutorial.

    Reply
    • You’re welcome Justin. Happy to help. The wrap text is a great feature because it is not like Microsoft Word, where by pressing enter you can go down to the next line – it takes you to another cell. Therefore the wrapping text is of great benefit. Take care

      Habib (ICT Tutor)

      Reply
  31. Hi Habib,

    This is a very good website, I really appreciate your effort on teaching people how to use Excel from the very basics to the more advanced levels.

    I’ve already bookmarked your website, so I’ll be checking it in the future to get some more useful tips.

    Thank you for sharing.

    Have a great day,
    Andrea

    Reply
    • Thank for your encouraging words – it is in my nature and profession to help and teach others. Thank you for bookmarking our site, now it’ll be easier for you to find my tutorials when you need them.

      Habib (ICT Tutor)

      Reply
  32. Hi Habibrani ,
    Thanks so much for adding another tools of knowledge to my Beth. I’m a novice to excel and struggle using it but you make it really easy. Now I know how to use the wrap text. I will share this with my wife and friends to learn how to use excel which I think is going to be an asset for me as I’m starting my own business.
    Great post

    Reply