Comments on: How to change and AutoFit row height in Excel

By default, all rows on a new workbook are set to the same height. However, Microsoft Excel allows you to resize rows in different ways such as changing row height by using the mouse, auto fitting rows and wrapping text. Continue reading →

Table of contents

Comments page 2. Total comments: 38

  1. yes svetlana!! I am also wait if new article publish on this site. I always keen get new learning in excel. You are awesome

    1. Thank you for your feedback, Rohan! I am delighted to hear that our articles are helpful.

  2. Oh, Svetlana,it is pretty good. I check everyday this site for new post, when found its being pleasure for me.Thanks for ur selfless effort.
    Question: is it possible to setup row/column height in pixel?& how?

    1. Hi Imran,

      Thank you for your comment!

      You can setup the row height /column width in pixels by dragging the boundary of the row/column heading. As you do this, Excel will display the row height both in points and pixels (please see the very first screenshot in this tutorial). If you want to resize multiple or all rows/columns at a time, select them, and then drag any heading boundary in the selection.

      1. Yeh,I know what have u described.But I was actually want to know, is it possible to setup row/column height in fractional pixel. Suppose, 1.3 pixel?

        1. Hi Imran,

          A pixel is a minute area of illumination on a screen, which is why it's not possible to use fractional pixels. According to the information from this Microsoft forum, when you set the row height in points, Excel actually sets it in pixels using this calculation:
          1 pixel = 72 / 96 points= 0.75 points

          Meaning, you can only change the row height in increments of 0.75 points. For more details, please see the above link.

          1. Thank's Svetlana,for your cooperation.may God bless you.

  3. I love you, You are good professional in Excel

    1. Thank you for your kind words, Zeeshan! It's a pleasure to share my findings and a joy to hear that my work is helpful.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)