How can I adjust the row height in excel? Modify the default row height in excel

Method 1. Configure the height of multiple rows

1. As shown in the following figure, open the excel table and select the leftmost row number (numbers 1, 2, and 3)

2. Right-click the selected area and click "row height" in the pop-up menu, as shown in the figure.

3. A dialog box for setting "row height" is displayed. Here, you can enter a number, for example, enter 40.

4. Check whether the selected row height has changed.

Method 2: single row height settings

1. It is very simple to set the row height for a single row. I also select the row with the row height set by the person.

2. Place the mouse over a horizontal line of the selected row. When the mouse turns into a cross, we can directly move down to change the row height of this row.

3. If you drag the lines to the top of the lines, you can use the method to set the height of the lines.