The Three Ways to Adjust Row Height

You can change row height in Excel by dragging the border between row numbers, double-clicking to auto-fit, or typing a specific measurement. The method you choose depends on whether you want to set an exact height, let Excel decide based on content, or make a quick visual adjustment.

All three methods work the same way across Excel versions on Windows and Mac. The row number column on the left side of your spreadsheet is where you'll find the controls — that's the gray area showing 1, 2, 3, and so on.

Key Takeaways

  • Drag the border between two row numbers up or down to manually set the height you want, and Excel will show you the exact measurement as you drag.
  • Double-click the border between row numbers to auto-fit the height to whatever text or numbers are in that row.
  • Right-click a row number and select "Row Height" to type in an exact measurement in inches or centimeters.
  • Select multiple rows by clicking one row number, then holding Shift and clicking another to change them all at once.
  • If a row shows a dotted line instead of text, the height is too small — drag the border down or double-click to auto-fit.

Dragging the Row Border to Set Height Manually

Position your cursor on the line between two row numbers in the gray row header on the left. Your cursor will change to a resize arrow — a double-headed line pointing up and down. Click and drag that border upward to make the row shorter or downward to make it taller.

As you drag, Excel displays the height measurement in a small box near your cursor. Most rows start at a height of 15 points. Standard letter-size text fits comfortably in 20 to 25 points. If you're working with wrapped text or larger fonts, you may need 30 points or more.

Release the mouse button when the row reaches the height you want. The change applies when ready. This method is fastest when you need to adjust just one or two rows and you can see visually whether the height looks right.

Double-Clicking to Auto-Fit Row Height

Double-click the border between two row numbers, and Excel automatically adjusts the upper row to fit all the content inside it. This is the quickest way to fix a row that's too short for its text.

Auto-fit measures the tallest cell in that row and sets the height to accommodate it completely. If a cell contains wrapped text that spans three lines, auto-fit will make the row tall enough to show all three lines. If the cell contains a single number, the row height shrinks to fit just that.

Auto-fit works on one row at a time when you double-click. To auto-fit multiple rows at once, select them first by clicking one row number, holding Shift, and clicking another row number further down. Then double-click any border between the selected rows.

Using the Row Height Dialog Box for Exact Measurements

Right-click on the row number you want to change. A menu appears with several options. Click "Row Height" — not "Hide" or "Unhide", but the option that says "Row Height".

A small dialog box opens with a text field showing the current height. Clear this number and type the height you want. Excel measures row height in points by default — one point equals 1/72 of an inch. Type a number like 20, 25, or 30 depending on how tall you need the row.

Click OK and the row adjusts to exactly that height. This method is useful when you need multiple rows to be the same height or when you're working from a template that specifies exact measurements.

Changing Multiple Rows at Once

Select all the rows you want to change by clicking the first row number, then holding Shift and clicking the last row number in the range. All rows between them highlight in blue. You can also select non-consecutive rows by holding Ctrl (or Command on Mac) and clicking individual row numbers.

Once rows are selected, use any of the three methods: drag the border between any two selected row numbers, double-click to auto-fit all of them, or right-click and choose "Row Height" to set them all to the same measurement.

This is especially useful when you have a table where several rows contain similar content and should be the same height, or when you want to make all rows in a section taller to improve readability.

Fixing Common Row Height Problems

If text in a cell shows as a dotted line or appears cut off, the row is too short. Drag the row border down or double-click to auto-fit. Excel will not automatically expand row height when you type — you have to adjust it manually or use auto-fit.

If you accidentally make a row very short and can no longer see the row number clearly, you can still select it by clicking in the area where it should be, then dragging the border down. Alternatively, right-click in that area and choose "Row Height" to type in a larger number.

Row height resets to default (15 points) only if you explicitly set it back. Changing font size, adding bold formatting, or wrapping text does not automatically change row height — you must adjust it yourself or use auto-fit.

Frequently Asked Questions

What's the difference between row height and font size?

Font size controls how large the letters appear. Row height controls how much vertical space the entire row takes up. You can have large text in a short row (text will be cut off) or small text in a tall row (with empty space above and below). Auto-fit makes the row height match the font size and content.

Can I set a minimum row height so rows don't get too small?

Excel does not have a built-in minimum row height setting. However, you can select all rows, set them to a specific height using the Row Height dialog, and then adjust individual rows as needed. Some users create a template with rows already set to their preferred minimum height.

Does changing row height affect the data in the cells?

No. Row height only changes how the row appears on screen and in print. The actual data stays the same. If text is hidden because the row is too short, the text is still there — it just is not visible until you make the row taller.

How do I make all rows in a sheet the same height?

Click the select-all button (the gray box in the top-left corner where the row numbers and column letters meet). Then right-click any row number and choose "Row Height". Type the height you want, and all rows in the sheet change to that height at once.

Why does auto-fit sometimes make a row taller than I expected?

Auto-fit measures the tallest cell in the row. If one cell contains wrapped text or a large image, auto-fit will make the entire row tall enough to show it. Check whether any cells in that row have text wrapping turned on, which causes text to break into multiple lines.