How to Change Row Height in Excel: Every Method Explained

Adjusting row height in Excel is one of those tasks that sounds simple until you're staring at a spreadsheet where text is getting clipped, cells look cramped, or your data just doesn't breathe the way it should. Whether you're formatting a report, building a dashboard, or cleaning up imported data, knowing how to control row height — and when to use each method — makes a real difference in how readable and professional your work looks.

Why Row Height Matters in Excel

By default, Excel sets row height based on the font size in use. Change the font to 14pt and the row expands slightly. Wrap text inside a cell and Excel may (or may not) auto-adjust, depending on your settings. When row height doesn't match your content, you end up with text that's visually cut off, excessive white space, or rows that look inconsistent across the sheet.

Row height in Excel is measured in points — the same unit used for font sizes. The default row height is typically around 15 points (roughly 20 pixels at standard screen resolution), though this shifts depending on the default font set for your workbook.

Method 1: Drag the Row Border Manually

The quickest visual method: hover your cursor over the bottom border of a row number on the left side of the sheet. When the cursor changes to a double-headed vertical arrow, click and drag up or down to resize.

This works well for one-off adjustments, but it's imprecise. You're eyeballing it, which means inconsistent heights across multiple rows if you repeat the process row by row.

To resize multiple rows at once using drag:

1. Select multiple row numbers by clicking and dragging down the row header column (or hold Ctrl to select non-adjacent rows)
2. Hover over the bottom border of any selected row header
3. Drag — all selected rows resize together

Method 2: Set an Exact Height Using the Format Menu

When consistency matters — like when you're building a structured report or aligning printed pages — setting an exact value is the right move.

1. Select one or more rows by clicking their row numbers
2. Go to Home → Format → Row Height
3. Type a specific value and click OK

You can also right-click any selected row header and choose Row Height from the context menu — same result, fewer clicks.

This method gives you pixel-perfect control. If you know your printed layout requires rows at 30 points for readability, you can apply that uniformly across every row in the sheet.

Method 3: AutoFit Row Height

AutoFit tells Excel to automatically size each row just tall enough to display its tallest cell content. It's the fastest way to clean up a sheet after pasting data, changing fonts, or enabling text wrapping.

To AutoFit one or more rows:

1. Select the rows you want to adjust (or press Ctrl+A to select the entire sheet)
2. Go to Home → Format → AutoFit Row Height

Alternatively, double-click the bottom border of a row header — Excel will snap that row to its auto-calculated ideal height.

⚠️ AutoFit works based on the current content. If a cell has wrapped text but the column is very narrow, AutoFit will make the row quite tall to accommodate the full wrapped content. This can produce surprisingly large rows if your column widths haven't been set first.

Method 4: Using a Keyboard Shortcut Path

Excel doesn't have a single-key shortcut for row height, but the Alt key sequence gets you there without touching the mouse:

Alt → H → O → H (press sequentially, not simultaneously)

This navigates: Home tab → Format → Row Height. Once the dialog opens, type your value and press Enter. Useful for keyboard-heavy workflows or when you're applying heights across many sheets quickly.

Method 5: Setting Row Height Across an Entire Sheet 🗂️

To apply a uniform height to every row:

1. Click the triangle icon in the top-left corner of the grid (between the row numbers and column letters) to select all cells
2. Right-click any row header → Row Height
3. Enter your value

This is particularly useful when standardizing a template or resetting a sheet that has been manually adjusted in scattered places.

Factors That Affect Which Method Works Best for You

Variables That Change the Experience

Excel version plays a role. The ribbon layout, right-click menu options, and even AutoFit behavior can vary between Excel 2016, 2019, Microsoft 365, and the web version of Excel. The web app has a more limited format menu and doesn't support the same keyboard sequences.

Operating system matters too. Excel on macOS uses slightly different menu paths and keyboard shortcuts. The core functionality is the same, but the navigation differs — for example, row height on Mac is typically accessed via Format → Row in the menu bar rather than through the ribbon.

Text wrapping settings directly interact with row height. If Wrap Text is enabled, AutoFit will expand rows to show all wrapped content. If it's disabled, AutoFit keeps rows tighter but content may appear clipped visually (though it's still there in the cell).

Merged cells are a known complication. AutoFit doesn't reliably adjust row height for rows containing merged cells — this is a long-standing Excel limitation. If you're working with merged cells and content isn't displaying correctly, manual height adjustment is usually the only reliable fix.

Imported or copied data sometimes brings hidden formatting that overrides your row height settings. If a row refuses to resize as expected, check whether the cells contain custom formatting from an external source.

How Printed Output Relates to Row Height

What looks right on screen doesn't always translate cleanly to print. Excel's Print Preview (File → Print) shows how row heights will appear on paper. Rows that look fine at screen resolution may appear disproportionately tall or short when printed, especially if you've changed page margins or scaling settings.

If you're designing a sheet for both screen and print, testing in Print Preview after setting row heights is worth building into your workflow — the same numeric height value can read very differently depending on paper size, orientation, and zoom level.

The right row height approach ultimately depends on what your spreadsheet is for, how it's going to be used, and whether you're prioritizing visual design, data density, print formatting, or something else entirely — and that's a call only your specific setup and goals can answer.