Excel’s default row height adjusts automatically to fit your text, but this can lead to inconsistent formatting. You often need uniform row sizes for professional reports, forms, or dashboards. This article explains how to set a precise, numerical height for one or multiple rows in your worksheet.
Key Takeaways: Setting Precise Row Height in Excel
- Format > Row Height: Opens a dialog box to type an exact measurement in points for selected rows.
- Right-click row number > Row Height: A quick shortcut menu to access the same precise measurement dialog.
- Home > Format > AutoFit Row Height: Resets rows to automatically fit content, useful for undoing manual height settings.
Understanding Row Height Measurement 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 can range from 0 to 409 points. This system provides pixel-perfect control over your spreadsheet’s layout. You cannot set row height using inches or centimeters directly in the standard dialog, but the point system allows for very precise adjustments.
When you manually drag a row border, Excel shows the height in points and pixels. However, for exact replication across many rows, you must use the numerical input method. This is essential for creating templates, aligning objects, or ensuring printed output matches a specific design.
Steps to Set a Specific Row Height
You can set the height for a single row, multiple contiguous rows, or non-adjacent rows. The core method is the same for all scenarios.
- Select the target rows
Click the row number on the left side of the sheet to select an entire row. To select multiple rows, click and drag across the row numbers. For non-adjacent rows, hold Ctrl while clicking each row number. - Open the Row Height dialog box
Go to the Home tab on the ribbon. In the Cells group, click the Format button. From the drop-down menu, select Row Height. Alternatively, right-click any of the selected row numbers and choose Row Height from the context menu. - Enter the exact measurement
A small dialog box will appear. In the Row height field, type the desired value in points. For example, type 20 for a row slightly taller than the default. Click OK to apply the new height to all selected rows immediately.
Using the Mouse for Approximate Adjustment
For quick, visual adjustments, you can use the mouse. Position your cursor on the bottom border of the row number header. The cursor will change to a double-sided arrow. Click and drag the border up or down. A tooltip will show the current height in points and pixels as you drag. Release the mouse button to set the height. This method is less precise but faster for one-off changes.
Common Mistakes and Formatting Limitations
Row Height Appears to Reset or Change
If a row you manually sized suddenly changes height, AutoFit is likely the cause. Double-clicking the row border automatically activates AutoFit Row Height, which resizes the row to fit the tallest cell entry. To prevent this, avoid double-clicking row borders after setting a manual height. Use the single-click and drag method or the Format menu instead.
Cannot Set Row Height to Zero
Excel requires a minimum row height of 1 point. If you try to enter 0 in the Row Height dialog, Excel will not accept it and may default to a previous value. To effectively hide a row, you must set its height to a very small value like 1 point, or use the Hide command by right-clicking the row number and selecting Hide.
Text Still Gets Cut Off in a Tall Row
Increasing row height does not automatically change text wrapping. If you have a long line of text in a cell and the column is narrow, the text will remain cut off. You must also enable text wrapping for that cell. Select the cell, go to the Home tab, and in the Alignment group, click the Wrap Text button. The text will then expand to fill the available row height.
Manual Height vs. AutoFit vs. Default Height
| Item | Manual Row Height | AutoFit Row Height | Default Row Height |
|---|---|---|---|
| Control | Full numerical control | Automatic based on content | Fixed at 15 points |
| Best Use | Uniform templates, printed forms | Dynamic data where content size varies | General data entry, standard worksheets |
| How to Set | Format > Row Height dialog | Double-click row border or Format > AutoFit | Inherited automatically; can reset via Format > Default Row Height |
| Precision | Exact to the point | Approximate, varies per row | Consistent but not customizable per row |
You can now apply a specific point measurement to any row in your worksheet. For related formatting, try setting exact column widths using a similar method in the Format menu. A useful advanced tip is to record setting a row height as part of a macro, allowing you to apply the same precise layout to new sheets with a single keyboard shortcut.