You may need to standardize the row heights in your Excel worksheet for a cleaner look or to fit printed pages. Manually adjusting each row is slow and inefficient. Excel provides tools to change the height of multiple rows simultaneously. This article explains the methods to set all rows to the same height in one action.
Key Takeaways: Setting Uniform Row Height
- Select All button: Click the triangle in the sheet’s top-left corner to highlight every cell before setting a uniform row height.
- Format > Row Height: Use this menu command on the Home tab to enter a specific numeric value for all selected rows.
- Mouse drag on row headers: Select multiple rows and drag the boundary below one header to visually set the same height for all.
Understanding Row Height Formatting in Excel
Row height in Excel is measured in points, where one point equals 1/72 of an inch. The default height is 15 points, but it adjusts automatically if you change the font size. To enforce a uniform appearance, you must manually set a fixed height. This action overrides the automatic sizing and applies your chosen measurement to the selected rows. You can apply this to the entire sheet or a specific range.
Before you begin, ensure your data is finalized. Changing row heights can affect cell text visibility. If text is too tall for the new height, it may be cut off or displayed with a line break. The methods below work in all modern versions of Excel for Windows, including Microsoft 365, Excel 2021, and Excel 2019.
Steps to Set a Uniform Row Height
You can use the ribbon menu, the right-click menu, or the mouse. The following steps detail each method.
- Select the rows you want to change
Click the row number header on the left side of the sheet to select one row. To select multiple adjacent rows, click the first row header, hold Shift, and click the last row header. To select the entire worksheet, click the Select All button, which is the small gray triangle where the row and column headers meet. - Open the Row Height dialog
With the rows selected, go to the Home tab on the ribbon. In the Cells group, click Format. From the dropdown menu, select Row Height. A small dialog box will appear. - Enter your desired height
In the Row Height dialog box, type a number. Common values are 15 for the default, 20 for more space, or 30 for double spacing. Click OK. All selected rows will immediately change to the exact height you specified.
Using the Right-Click Menu
- Select your rows
Highlight the row headers for the rows you want to modify. - Right-click and choose Row Height
Right-click directly on one of the selected row headers. From the context menu that appears, select Row Height. - Set the value
Enter the numeric height value in the dialog box and click OK to apply.
Using the Mouse to Drag to a Height
- Select multiple rows
Click and drag over the row headers to select several rows. - Drag a row boundary
Move your mouse pointer to the bottom border of one of the selected row headers. The cursor will change to a vertical double-headed arrow. Click and drag up or down. - Release to apply
As you drag, a tooltip shows the current height. Release the mouse button when the desired height is shown. All selected rows will match this new height.
Common Mistakes and Limitations
Text Is Cut Off After Setting Row Height
If you set a row height smaller than your text requires, the content will not display fully. Excel does not automatically expand the row in this case. To fix this, you must either increase the row height again or reduce the font size of the cell text. Using the Wrap Text feature can help fit text within a fixed height.
Merged Cells Prevent Uniform Height Changes
Rows containing vertically merged cells can behave unexpectedly when you try to change their height. It is best to unmerge cells in the selected range before applying a uniform height. Select the merged cells, go to Home > Alignment > Merge & Center, and click Unmerge Cells.
Hidden Rows Are Not Affected
If you select a range that includes hidden rows, setting the row height will not unhide them or change their height. You must unhide the rows first. Select the rows around the hidden ones, right-click, and choose Unhide.
Manual Drag vs. Dialog Box: Key Differences
| Item | Mouse Drag Method | Row Height Dialog Box |
|---|---|---|
| Precision | Visual estimate, less precise | Exact numeric input |
| Speed | Faster for quick adjustments | Slower but more accurate |
| Best for | Making rows visually uniform | Setting a specific point value like 18.5 |
| Selection requirement | Must select multiple row headers | Can use Select All button for whole sheet |
You can now apply a consistent row height across your entire Excel worksheet or specific sections. Use the Row Height dialog for precise control, especially when preparing documents for printing. For a related formatting task, try using the Column Width feature under Format to standardize your sheet’s layout. To quickly revert to default heights, select the rows, open the Row Height dialog, and delete the value to let Excel auto-fit.