To change the row height of one row, drag the boundary below the row heading until the row is the height that you want. To change the row height of multiple rows, select the rows that you want to change, and then drag the boundary below one of the selected row headings.
To change the height of a single row, drag the boundary below the row heading until the row is the height you want. To decrease the height, drag the bottom boundary up.
Change the height of rows Click and drag across the row headings for the rows that you want to change. Row separator Row headings Note: If you have to change the height of only one row, you don't need to select it first. Point to the separator underneath any selected row heading. The pointer becomes a . Do one of the following:
To set the row height to a specific measurement, select a cell in the row that you want to resize. On the Layout tab, in the Cell Size group, click in the Table Row Height box, and then specify the height you want.
To automatically adjust the row height, select AutoFit Row Height. To specify a row height, select Row Height, and then type the row height that you want in the Row height box.
Use the horizontal and vertical ruler to measure items in the worksheet (such as column width, row height, or the width and height of pages). Change the ruler units
Select the rows or columns and then select Layout and choose your height and width. Select View > Ruler checkbox, select the cell you want, and then drag the markers on the ruler.
Although Excel offers no direct control for line spacing within a cell, you can use several text alignment strategies to adjust white space or make the text more readable.
