Set Row Height In Excel

The post demonstrates how to set row height manually in excel.

Suppose you have some numeric value to set row height in excel, how would you make certain rows in excel of the same height.

We could enter manually the height of any row or rows in excel of what we desire.


As you could see above in the pic, select any row or rows for which you want to set the height manually, right click and click option Row Height.

You will get a box in which you can enter the height of your choice as shown below, I have manually set up the row height as 15.


Click OK after entering the dimension, Row height is set to that particular dimension now.

Hope this helped.

Share The Knowledge

Random Posts

  • Generate Sample Data In Excel

    Let’s understand how we could generate some sample data to carry out some further analysis in excel. We have certain […]

    Share The Knowledge
  • Create Comma Separated Values From Excel Range

    create comma separated values from a range in excel, create comma separated string from a column in excel, VBA to create comma delimited values from a range or column

    Share The Knowledge
  • Area Function In Excel

    Area function is a very significant function when it comes to determine how many references have been selected in the […]

    Share The Knowledge
  • Check Duplicates By Combinations Of Cells In Excel

    In this post we will see how we could find if there are duplicates by combinations of cells in excel. […]

    Share The Knowledge

Leave a Reply