Excel has cells, which are framed as rows and columns in worksheets. Adjusting Row height in excel is one of the basic tasks. When you designed your report or create a dashboard you have to adjust the excel row height or column width frequently based on the cell contents.
For example, Suppose you are creating a dashboard, and for the header, you need the title text along with the company logo. You have to adjust the height of the row to cover your logo in the title.
Mouse click and drag to adjust row height
The first step is to click on the row number of the row you want to change.
For this example,
- You will click on row 4. Once you have clicked on the row number, you will notice the mouse changes to a resize icon. Hover your mouse over the bottom border of the row until you see a double-headed arrow.
- Click and hold the left mouse button, then drag the mouse up or down to change the row height.
- Release the mouse button when you are finished
Mouse double-click to adjust row height
Please follow the below procedure to adjust the row height using the mouse double-click
Hover your mouse over the bottom border of row 4 until you see a double-headed arrow. Once you see the arrow, double-click the left mouse button
Now you can see the row auto adjust the height to cover the entire cell content
Use the Home tab to adjust row height
Assuming that you have a worksheet with data in it and you want to adjust the row height to better fit the data.
Please follow the below steps to use the Home tab to adjust row height in excel
- Select the row or rows whose height you want to change. To select multiple rows, click on the first row you want to select, hold down the Shift key, and click on the last row you want to select.
- Select Home Tab.
- Choose Format
- Select Row Height, to open the Row Height dialog box
- Type desired height, in this example you type 30
- Press OK
Conclusions
When you are working with a lot of data in Excel, you may find yourself in need of changing the row height to better accommodate all of the information. Row height is the measurement of how tall each row is in your spreadsheet, and you can change it with any one of the above methods.
If you have any questions, please leave a comment below and I will get back to you as soon as possible.
