Hosne Ara
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.
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.
- 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.
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.
- 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.
- As a consequence, Excel will adjust the row height based on the text in it.
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.
- 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.
- Next, right-click on the selected row and select Row Height.
- Consequently, the Row Height dialog appears. In the Row Height field, type the desired height and press OK.
- Finally, you will get the below result. Row 5 is adjusted to fit the text located in it.
- 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.
- Consequently, Excel will adjust the row height to fit the text in it.
Read More: VBA to Customize Row Height in Excel
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.
- 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.
- Then, right-click anywhere in the selection and select Row Height.
- When the Row Height dialog box shows up, enter the desired row height (say 30) and press OK.
- 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.
- 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.
