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

Get FREE Advanced Excel Exercises with Solutions!

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.


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. Clicking and Draging to Adjust Excel Row Height and 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

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.


2. Using Mouse to Set Row Height to Adjust Text in Excel

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

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. Adjusting Row to a Specific Height in Excel to Fit Text

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

  • 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.


4. Using 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.


5. Applying 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


6. Fitting 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


Things to Remember

  • In Excel, there are different row height units. You can adjust row height in inches, centimeters, or millimeters. To do that go to View > Page Layout. Then, select a row >> right-click on it >> select Row Height from the context menu. You can use a specific unit in that box.

Things to Remember

  • In Excel, you can change and restore 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.


Download Practice Workbook

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


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


<< Go Back to Row Height | Rows in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hosne Ara
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo