If you have a number of rows in your sheet and each one has a different size of data. For example one row may have a wrapped text or a text with big font size that does not match with the current row height, then you can adjust the row height.
To adjust the height of each row to fit the entered data:
- Select the rows to be adjusted.
- In the Home tab, Cells group, click Format.
- From the Format menu Click AutoFit Row Height.
Alternatively you can do the same by following these steps:
- Select the rows to be adjusted.
- Point to the lower border of anyone of the selected rows (at the left of the row where the row number is). The mouse pointer should change to a cross with vertical arrows at the top and bottom.
- Double click on the row border.
Before:
After:


















