Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel

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

  1. Widen columns in Excel
  2. Adjust the height of rows in Excel

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 24: How to SORT data in ASCENDING order in Excel

Or go back to:

Lesson 22: How to RENAME a worksheet in Excel

Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

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

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

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

20 thoughts on “Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel”

  1. Thank you for sharing the best techniques to widen columns and how to adjust the height of rows. I just have realised how my excel skills had improved with your help!

  2. Hi there,

    Fantastic lesson. I like the simple way you explain everything. It is so easy to follow.

    Keep them coming because you are going to help a lot of people.

    • Thank you Oana, I will carry on helping others, that is in may nature as a tutor, this is why I love my profession so much 🙂

      Habib (ICT tutor)

  3. Hello Habib, thank you for sharing these cool tips for widening rows and columns in excel.
    I only knew about one of the methods you spoke about. They’ll definitely speed up my workflow whenever I’m using excel. Thanks again for your insights.

    • You’re very welcome Mikhail. All new skills will improve productivity, especially if you understand the skill, this is why I always explain the feature before telling you how to do it 🙂

      Habib (ICT tutor)

  4. Hi Habib,

    thanks for this informative video on Excel tips and tricks. I am certain that this content helps beginners to get to know some details about Excel. Also, I really like that you created a video as I think it is much easier to follow as a user 🙂


    • Yes Fabian, video lessons are a lot better as it is visual and you can follow it step by step, pause and practice etc. I hope you learnt everything in this lesson about the techniques to widen columns and row height 🙂

      Habib (ICT tutor)

  5. Great looking web site with lots of interesting information. It puzzles me how diverse the information is, which I like. It seems very interesting. It feels different from most other sites I come across with a lot going on. For some reason, it does not feel like ‘too much’ for this site! Ha ha. I guess there is always an exception!

    Great site

    • Thank you very much Tyler for your constructive feedback. We have planned and executed the design and contents of our site very carefully. The results is showing to be positive and effective to our aims of the site. Carry on learning from all our posts, and also visit our YouTube channel and see what you think – I think you will love the channel too 🙂

      Habib (ICT tutor)

  6. Great work in your helpful video explaining how to widen columns and adjust the height of rows in Excel spreadsheets/worksheets.
    I have often struggled with understanding how they operate, but with a little bit of teaching and understanding they are a useful tool!

  7. Hi Habib,
    Great tutorial, and thanks for adding to my excel knowledge bank. Until now, I used the last method of dragging you discouraged, but now that you mentioned the downside and the other methods, I definitely think that everybody should adopt these new methods and let go of the 3rd one.
    Thanks again for you always deliver.


    • You’re very welcome Benson. A lot of people use the last method I mentioned, nothing wrong with it except you have to be careful and it is a slower method too. Well done for taking on board what I have taught in this lesson. Take care 🙂

      Habib (ICT tutor)


Leave a comment

1 Share
Share via
Copy link
Powered by Social Snap