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

In this article, I will discuss how you can adjust the row height to fit text in Microsoft Excel. By default, Excel has a certain row height. So, when you type the text that exceeds the default row height,  the cell contents get shrunk. As a result, we cannot see the full text. On the other hand, sometimes row height is much greater than the required height, and spreadsheets do not look good. So, let’s explore the article to solve such problems.


Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.


6 Methods to Adjust Row Height to Fit Text in Excel

Let’s assume, we have a dataset containing several doctor’s information but rows 5 and 9 are not adjusted to the height of the text.

6 Methods to Adjust Row Height to Fit Text in Excel

Now, we can adjust the row height to fit the text in it by following several methods.

1. Adjust Excel Row Height Using Click and Drag to Fit Text

You can adjust row height by dragging the row border. This is a very easy and common technique to change the row height. Initially, I will change the height for a single row. Follow the below steps to perform the task.

Steps:

  • First, put the mouse cursor on the border of the row of which you want to change the height.
  • Then drag the bottom border of the row heading to get the expected height.

Adjust Excel Row Height Using Click and Drag to Fit Text

  • Consequently, you will get the below result. The row height is adjusted according to the text height and we can see the whole text now.

Adjust Excel Row Height Using Click and Drag to Fit Text

Note:

You can adjust the height of multiple rows too. The steps involved in this process are:

  • Select the rows which have insufficient height.
  • Then drag down the bottom border of any row heading from the selected rows.

Adjust Excel Row Height Using Click and Drag to Fit Text

  • As a result, you will get the below result.

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


2. Use Mouse to Set Row Height to Adjust Text

In this method, I will use the mouse again to adjust row height based on text height. I will simply double-click the boundary of the row header to adjust the row height.

Steps:

  • First, put the cursor on the lower border of the row header of which you want to change the height.
  • Next double click on it.

Use Mouse to Set Row Height to Adjust Text

  • As a consequence, Excel will adjust the row height based on the text in it.

Use Mouse to Set Row Height to Adjust Text

Note:

If you want to adjust the height of multiple rows, follow the below instructions:

  • Simply select corresponding rows and double click on the lower border of any of the row headers in the selection.

Use Mouse to Set Row Height to Adjust Text

  • As expected, we can see the height of all selected rows is adjusted according to the cell contents.

Read More: How to Copy Multiple Row Height in Excel (3 Quick Tricks)


3. Adjust Row to a Specific Height to Fit Text in Excel

You can set the height of the row manually too. See the following steps to do the operation.

Steps:

  • First, select the row in which you want to adjust the height.

Adjust Row to a Specific Height to Fit Text in Excel

  • Next, right-click on the selected row and select Row Height.

Adjust Row to a Specific Height to Fit Text in Excel

  • Consequently, the Row Height dialog appears. In the Row Height field, type the desired height and press OK.

Adjust Row to a Specific Height to Fit Text in Excel

  • Finally, you will get the below result. Row 5 is adjusted to fit the text located in it.

Adjust Row to a Specific Height to Fit Text in Excel

Note:

  • You can use the Home tab to set row height manually. To do that, select the row, and go to Home > Cells > Format > Row Height.

Read More: Row Height Units in Excel: How to Change?


4. Excel Home Tab to Autocorrect Row Height to Adjust Text

You can autocorrect row height using the Home tab. Follow the below steps to do the task.

Steps:

  • Initially, select the row or the cell that is not adjusted according to the text height.
  • Then from Excel Ribbon go to Home > Cells > Format > AutoFit Row Height.

Excel Home Tab to Autocorrect Row Height to Adjust Text

  • Consequently, Excel will adjust the row height to fit the text in it.

Read More: VBA to Customize Row Height in Excel (6 Methods)


5. Use Keyboard Shortcut to Set Row Height to Fit Text

If you are a keyboard lover, you can use this method to adjust the row height to fit the text.

Steps:

  • First, select the row having insufficient row height.

Use Keyboard Shortcut to Set Row Height to Fit Text

  • Next, type the below keys one by one to apply the AutoFit Row Height option.

Alt + H + O + A

  • Finally, upon applying the above keys, you will see that row 5 is adjusted to the text in it.

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


6. Fit Text by Changing Row Height for Entire Excel Worksheet

You can change the height of the entire worksheet in excel. To do that follow the below steps.

Steps:

  • First, select all the cells in the active worksheet by selecting the small triangle icon located at the intersection of the column and row header. Or you can press Ctrl + A + A to select all the cells in a worksheet.

Fit Text by Changing Row Height for Entire Excel Worksheet

  • Then, right-click anywhere in the selection and select Row Height.

Fit Text by Changing Row Height for Entire Excel Worksheet

  • When the Row Height dialog box shows up, enter the desired row height (say 30) and press OK.

Fit Text by Changing Row Height for Entire Excel Worksheet

  • Finally, upon pressing OK, you will get the below output. We can see that the height of all rows present in the worksheet is adjusted to 30. Besides the text of rows, 5 and 9 are also fully visible now.

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


Things to Remember

  • You can adjust row height in inches, centimeters, or millimeters. To do that go to View > Page Layout.

Things to Remember

  • In Excel, you can change the default row height too. To do that, go to File > Options > General. Then change the Font Size from the When creating new Workbooks. Remember, this change will only be applied when you restart the excel and create a new workbook.


Conclusion

In the above article, I have tried to discuss several methods to adjust the row height to fit text in excel elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

Hosne Ara

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo