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.
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.
And all columns are 8.43 inches by default.
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.
After selecting Row Height, a dialog box will pop up where you can insert a new value depending on your requirement.
Now I Inserted the value 60 and clicked OK.
When the Row Height = 60 the whole text is visible.
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.
Set the Row Height = 8. It decreased the height of the row.
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.
Now the Row is Autofitted and the whole text is visible.
4) Change or Increase the Row Height with Double Click
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.
Now the height is increased automatically to fit the data. Now the entire text is visible to read.
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.
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.
# Decreasing the Row Height by Dragging the Mouse Key or Touchpad
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.
It will also show the decreased height with pixels.
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.
When you will press ALT + H + O one after another it will open the Format option
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.
# 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
As I inserted Row Height = 5 and it shrank the row. You can use the value as per your need.
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.
You can change the options to adjust the row height in inches, centimeters, or millimeters.
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.