How to Change the Row Height in Excel (7 Easy Ways)

Excel worksheet cells are a combination of rows and columns. By default, it remains the same for all cells, but Microsoft allows us to resize it depending on the content of cells. We need to change rows height and columns width depending on our needs. It can be larger or shorter. In this article, you will know how to change the row height in Excel.

Download Sample Datasheet

In my sample datasheet, there are 3 columns which are Sales Rep, Location, and Product including some contents here my focus is to show how to increase the Row Height when the text values are larger than the cell.

How to change row height in excel

Download the workbook from the link below.

Introduction Of Cell Height and Width Limit

The default size of row height is 15.00 inches with a Calibri font size of 11 points.

default row height in excel

And all columns are 8.43 inches by default.

default column width in excel

While changing or resizing a row or column you need to maintain a limit.

For Rows, it is (0 to 255), 0 means Hidden.

For Columns, it is (0 to 409)

Methods to Change Row Height in Excel

How to change row height in Excel (7 Ways)

1) Increasing the Row Height from Ribbon

In the default row cell when we write something larger than 15 inches then it becomes unable to read. Here in the D13 cell, the whole text is not visible because the text is larger than the default row height. The text is Newly Released Smartwatch.

To change the row height to see the whole text using ribbons option First, from the Home tab, in the Cells group Select Format then select the Row Height option.

Row Height Command in Excel

After selecting Row Height, a dialog box will pop up where you can insert a new value depending on your requirement.

default row height in excel

Now I Inserted the value 60 and clicked OK.

Changing the row height in excel

When the Row Height = 60 the whole text is visible.

How to change row height in excel

Read more: How to Increase Row Height in Excel (Top 4 Methods)

2) Decreasing The Row Height From Ribbon

In the Row Height dialog box type lesser than the default value, it will decrease the Row Height.

How to change row height in excel

Set the Row Height = 8. It decreased the height of the row.

How to change row height in excel

3) Resizing the Row Height Using “AutoFit Row Height” Command

To change the row height automatically select the row which height you want to change.  First, from the Home tab, in the Cells group select Format then select the AutoFit Row Height option.

How to change row height in excel

Now the Row is Autofitted and the whole text is visible.

How to change row height in excel

Read more: Auto Row Height Not Working in Excel (2 Quick Solutions)

4) Change or Increase the Row Height with Double Click

How to change row height in excel

To automatically fit that text in the cell first go to the 13 number row then place the Cursor at the bottom edge of that row header when the cursor changes into a Plus icon then double click on that icon.

How to change row height in excel

Now the height is increased automatically to fit the data. Now the entire text is visible to read.

How to change row height in excel

Read More: How to Change & Restore Default Row Height in Excel


5) Change the Row Height by Dragging the Mouse Key or Touchpad

# Increasing the Row Height by Dragging the Mouse Key or Touchpad

To increase Row Height first go to the number row 13 and select the Row. 

How to change row height in excel

Then place the cursor at the bottom edge of that row header. When the cursor changes into a Plus icon, then by pressing the left mouse key/left touchpad and dragging it down you can increase the Row Height. It will also show the increased height with pixels.

How to change row height in excel

# Decreasing the Row Height by Dragging the Mouse Key or Touchpad

How to change row height in excel

In case you want to decrease the row height you can do it by pressing the left mouse key/left touchpad and dragging it up.

How to change row height in excel

It will also show the decreased height with pixels.

How to change row height in excel

6) Keyboard Shortcut to Specify the Row Height

# Increasing The Row Height Using Keyboard Shortcut

Some users are super friendly with using keyboard shortcuts. If you are one of them this way is just for you.

First, select the cells of the row for which you want to change the height.

You can directly open the Row Height dialog box by pressing the key ALT+H+O+H.

How to change row height in excel

When you will press ALT + H + O one after another it will open the Format option

How to change row height in excel

Then by pressing H again, the Row Height dialog box will open, and you can insert any value and increase the Row Height. I inserted the value 60.

How to change row height in excel

# Decreasing The Row Height Using Keyboard Shortcut

Again, press the ALT + H + O + H key one after another then the Row Height Dialog box will open. Insert the decreased value. I inserted Row Height = 5

How to change row height in excel

As I inserted Row Height = 5 and it shrank the row. You can use the value as per your need.

How to change row height in excel

7) How to adjust row height in inches, centimeters, or millimeters

First, click on File and it will take you Home from that select Options.

Now a new Excel Options window will appear. Then select Advanced from that and go to Display in touchpad there you will find Ruler units.

How to change row height in excel

You can change the options to adjust the row height in inches, centimeters, or millimeters.

Read More: How to Adjust Row Height to Fit Text in Excel (6 Suitable Methods)

Conclusion

In this article, I tried to explain all possible ways of increasing the Row Height along with decreasing it. I hope this explanation will help you to solve your problems. I would appreciate any kind of feedback, suggestions, ideas, or even drawbacks. Just feel free to let me know.


Further Readings

Shamima

Shamima

Hello! Welcome to my Profile. I am Shamima Sultana Rita. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Computer Science and Engineering from East West University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. I love to learn new things. Data Analysis is one of my favorite fields as I love to extract patterns based on problems. Here, I'm trying to provide enriched quality content regarding Excel basics to Advanced. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo