Sometimes we need to adjust row heights in Excel to view cell contents properly. In this article, we’ll show you the simple methods to Auto adjust Row Height in Excel.
To help you understand better, I’m going to use a sample dataset as an example. The following dataset represents the Salesman, Product, and Net Sales of a company.
Download Practice Workbook
Download the following workbook to practice by yourself.
3 Simple Ways in Excel to Auto Adjust Row Height
1. Excel AutoFit Row Height Feature to Auto Adjust Row Height
In our first method, we’ll use AutoFit Row Height feature in Excel to adjust the row height of Row 9 in the following image so that we can properly see the cell contents.
- First of all, select the 9th.
- Next, select the AutoFit Row Height feature in the Formats drop-down list which you’ll find in the Cells group under the Home tab.
- Finally, you’ll see the newly adjusted 9th row.
2. Double-Clicking Lower Boundary for Auto Adjusting Row Height in Excel
Another way to auto-adjust row height in Excel is by Double-Clicking the mouse. Here, we’ll double-click the Lower Boundary of the 5th row to view the cell contents clearly.
- First, point the mouse cursor at the lower boundary of the 5th row.
- Finally, double-click the mouse and you’ll get your desired outcome.
Read More: Row Height Units in Excel: How to Change?
3. Auto-Adjust Row Height in Excel With Keyboard Shortcut
We can also apply Keyboard Shortcut to adjust row height in Excel. Follow the steps below to know how to use it.
- Firstly, select the 10th row.
- Next, press the keys ‘Alt’, ‘H’, ‘O’ and ‘A’ one after another.
- Finally, it’ll return the newly adjusted 10th row.
Other Ways to Adjust Row Height in Excel
1. Excel Row Height Feature for Adjusting Row Height
We can also manually set row heights in Excel with the Row Height feature.
- First of all, select any row or multiple rows to adjust the height.
- In this example, select all the rows from 4 to 10.
- Next, select the Row Height feature in the Formats drop-down list which you’ll find in the Cells group under the Home tab.
- A dialogue box will pop out and type your desired row height there.
- Then, press OK.
- Finally, you’ll see the selected rows with their newly adjusted height.
2. Adjusting Row Height in Excel Using the Mouse
We can also use the Mouse to adjust row heights manually.
- First, select rows 4 to 10.
- Next, click the mouse and drag the lower boundary of any of your selected rows.
- In this example, select the lower boundary of row 6.
- Finally, you’ll get your required row heights.
3. Excel Wrap Text Feature to Adjust Row Height
We will apply the Excel Wrap Text feature in our last method to adjust row height. Here, our 4th row contains the title of the specific columns, but they are not properly placed within the cell.
- First, select the cells B4, C4, and D4.
- Then, select Wrap Text in the Alignment group under the Home tab.
- Finally, you’ll see the re-adjusted 4th row.
Excel AutoFit is Not Functioning (Possible Reasons)
- If you have Merged Cells, the AutoFit feature won’t work. You have to manually set the row height for such cases.
- The AutoFit feature also won’t work if you have applied the Wrap Text feature in your cells. You have to manually set the row height for such cases.
Now you will be able to Auto adjust Row Height in Excel using the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.