Row height in Excel sounds trivial until a long string of text gets clipped, a printout cuts your data in half, or a row stubbornly refuses to grow no matter how many times you drag its border. The default is 15 points (about 20 pixels) on Windows and 12.75 points (around 17 pixels) on Mac — both designed for a single line of 11-point Calibri.

The moment your content gets bigger, wraps, or includes merged cells, that default stops being enough. This guide walks you through every method to adjust row height: mouse drag, double-click AutoFit, ribbon menus, keyboard shortcuts, dialog box entry, and VBA macros for bulk changes.

By the end you will know not just how to change one row, but how to set a sensible default for an entire workbook and how to rescue stuck rows that refuse to resize. Before diving into the methods, it helps to understand the units Excel uses.

Row height is measured in points — the same unit used for fonts. One point equals 1/72 of an inch, so a row 72 points tall is exactly one inch on a printed page. Column width, by contrast, is measured in characters of the default font, which is why row and column sizing feel a little inconsistent.

The maximum row height is 409 points. Anything you set above that gets clamped silently. If you ever see a value not stick, the limit is the most likely culprit. Pixel display also depends on your screen DPI, so the same point value can look slightly different from one monitor to another. For more on resizing both axes together, see our guide to resizing cells in Excel.

Method 1: Drag the Row Border With Your Mouse

This is the fastest way to change a single row. Move your cursor to the row number on the left side of the worksheet and hover over the bottom edge of the row you want to resize. The cursor turns into a horizontal line with arrows pointing up and down.

Click and hold, then drag down to make the row taller or up to make it shorter. A small tooltip shows you the current height in points and pixels as you drag — handy when you need a specific size.

To resize several rows at once, first select them: click the first row number, then Shift-click the last one (or Ctrl-click for non-adjacent rows). Drag the border of any selected row and every selected row resizes to the same height. This is the trick most people miss — they resize one row at a time and wonder why the worksheet looks uneven. Select first, then drag once.

Method 2: Set an Exact Height From the Ribbon

When you need a precise value rather than an eyeballed drag, the ribbon gives you a dialog. Select the row or rows you want to change. On the Home tab, click Format in the Cells group, then choose Row Height.

Type the value you want in points and press Enter. The dialog accepts decimals, so 22.5 is valid. If you type something above 409 Excel quietly caps it. If you live in the ribbon, this is the cleanest path. If you prefer keyboard control, the next two methods are quicker.

Method 3: Keyboard Shortcut for Row Height (Windows)

There is no single hotkey for "set row height," but the Alt key sequence is fast once you learn it. Select the row, then press Alt, H, O, H one key at a time (not all at once).

This walks you through Home → Format → Row Height and opens the same dialog as Method 2. Type your value and press Enter. Once it is in muscle memory you will not touch the mouse for row sizing again. Many readers pair this with the essential Excel keyboard shortcuts for navigation and formatting.

Method 4: Keyboard Shortcut for Row Height (Mac)

Mac Excel does not use Alt sequences the same way. Instead, select the row and use Format menu → Row → Height from the menu bar, or right-click the row number and choose Row Height.

There is also a Cmd+1 shortcut to open Format Cells, though that dialog does not include row height — only cell-level formatting. The fastest Mac approach is right-click for the context menu or set up a custom shortcut under System Settings → Keyboard → App Shortcuts.

Method 5: AutoFit Row Height

AutoFit is the option you will reach for nine times out of ten. Instead of guessing a value, Excel measures the tallest content in each row and sizes the row to fit exactly. To trigger AutoFit, double-click the border between any two row numbers. The row above the border snaps to fit.

For multiple rows, select them all, then double-click the border of any selected row — every selected row resizes independently. From the ribbon, the path is Home → Format → AutoFit Row Height. The keyboard sequence on Windows is Alt, H, O, A.

AutoFit respects wrapped text, so if you have long entries with Wrap Text turned on, every row grows to show every line. This is the secret to making messy data presentable without manual fiddling. Our deep dive on AutoFit in Excel covers the edge cases.

Method 6: Right-Click Context Menu

Right-click any row number and the context menu offers Row Height directly. Type a value, hit Enter, done. This works on Windows and Mac and is often the fastest path when your hand is already on the mouse.

The same context menu gives you Hide, Unhide, Insert, and Delete — see our guides on hiding rows and unhiding rows for the related operations.

Method 7: VBA Macro for Bulk Row Height

If you need to set hundreds of rows or build a repeatable workflow, VBA is the answer. Press Alt+F11 to open the Visual Basic Editor, insert a new module from the Insert menu, and paste a short routine.

A simple example sets every row on the active sheet to 25 points: Sub SetRowHeight() then Rows.RowHeight = 25 then End Sub. For a specific range, use Range("A1:A100").RowHeight = 30. To AutoFit every row programmatically, use Cells.EntireRow.AutoFit.

Save the workbook as .xlsm so the macro persists. Bind it to a shortcut under Developer → Macros → Options if you run it often. VBA also lets you set conditional heights — for example, taller rows only where a flag column equals "Y" — which is impossible from the dialog.

Method 8: Change the Default Row Height

Excel does not expose a "default row height" setting directly. Instead, you change it for the active sheet using Format → Default Width for columns and Format → Row Height applied to every row.

The simplest method: select all cells with Ctrl+A (twice if needed), open Format → Row Height, type your desired default, and press Enter. To make this stick across new workbooks, save the file as a template named book.xltx in your XLSTART folder.

On Mac, the XLSTART folder lives at ~/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Excel. On Windows it sits inside the Office installation directory or your user profile. Any workbook saved there as book.xltx becomes the template every new file uses.

When Row Height Will Not Change

Sometimes you drag a row border and it snaps back, refuses to grow, or grows but clips the text anyway. Three common causes follow below.

Merged cells. Merged cells confuse AutoFit. The merged range counts as a single cell for measurement, so AutoFit may underestimate the height needed for wrapped text inside a merged block. Workaround: select the merged cells, set the height manually, or use the "Center Across Selection" alignment instead of merging. Our guide to Excel merge cells explains the alternatives.

Frozen panes. When you freeze rows, Excel locks their height as part of the freeze. Unfreeze (View → Freeze Panes → Unfreeze) before resizing, then re-freeze.

Protected sheet. If the worksheet is protected and "Format rows" is unchecked in the protection options, no one can change row height. Unprotect (Review → Unprotect Sheet, enter the password), resize, then reapply protection.

Row Height for Printing

What looks fine on screen sometimes prints awkwardly. Excel scales the print preview based on point values, not pixels, so a row that fills the screen may print smaller than expected. Before printing, check Page Layout view (View → Page Layout).

This shows rows at print size, including the effect of margins and page breaks. If a row is too tall and pushes content onto a second page, shrink it slightly or use Page Layout → Fit to: 1 page wide and tall, which scales the whole sheet to fit.

Be careful with AutoFit before printing: if any cell contains an extra-long string with Wrap Text off, AutoFit will not grow the row, and the text gets clipped on paper. Turn Wrap Text on for the printable range, then AutoFit, then preview.

Row Height vs Column Width

Row height is in points; column width is in characters of the default font. The two units do not convert directly. A row 20 points tall is roughly 27 pixels at 96 DPI; a column 20 characters wide is roughly 145 pixels.

If you are trying to make cells square (useful for pixel-art and grid layouts), set both to small values like row height 15 and column width 1.71 — the closest you can get to square 20×20 pixel cells. Our guide to adjusting column width covers the column side of this in depth.

Common Mistakes to Avoid

The biggest trap is mass-AutoFitting with wrapped text in merged cells — AutoFit silently underestimates and rows print clipped. The second trap is changing row height on a filtered range: only visible rows resize, hidden ones stay at the old height. Remove the filter, resize, then reapply.

The third trap is forgetting that locked cells in a protected sheet block row resizing even for the sheet owner without the password. Finally, do not rely on dragging when you need consistency — type the exact value into the dialog instead.

Power-User Tips

Use AutoFit as a final pass after you have entered all your data and applied wrap text. Save a custom Quick Access Toolbar button for AutoFit Row Height — it lives at File → Options → Quick Access Toolbar → All Commands.

Pair row height with Wrap Text for long-form text columns (notes, comments, descriptions) — without wrap, AutoFit has nothing to measure. If you build dashboards, set a uniform row height for every label row (typically 22 points) for a clean grid look.

And remember: row height does not affect cell value, only display — your formulas, sort order, and data integrity are unchanged regardless of how tall or short rows look.

Row Height and Filtered Data

Filters change how row sizing behaves. When a filter hides rows, those hidden rows keep their old height — only the visible ones respond to resize operations. If you AutoFit a filtered range, you may discover after removing the filter that hidden rows are still oversized or undersized.

The safe pattern: remove the filter, resize, then reapply. Alternatively, do a final pass with no filter active before sharing or printing the workbook. Excel does this on purpose to avoid corrupting your hidden data, but it surprises people who expect AutoFit to touch every row.

Subtotals introduce a similar gotcha. The subtotal row inherits whatever height the surrounding rows have, but if you collapse the outline, the visible summary rows may need extra height for headers or totals. Resize after collapsing to taste, then save the view.

Hidden Rows vs Zero-Height Rows

There are two ways a row can be invisible. The first is hidden through right-click → Hide or Format → Hide & Unhide. The second is zero-height — you dragged the row border up until it disappeared.

Both look identical in the worksheet, but they unhide differently. For hidden rows, select the rows above and below and right-click → Unhide. For zero-height rows, you need to drag the border between row numbers to expand them, or select the surrounding rows, open Format → Row Height, and type a positive value.

The most common cause of zero-height rows is an accidental drag — easy to do, easy to fix once you know.

Pixel-Perfect Row Height for Dashboards

If you are building a dashboard or report layout, consistent row height is critical. The professional approach: select every data row at the start, set a uniform height (24-30 points works well for body text in a 11-12 point font), and leave AutoFit off.

For header rows, double the height (40-60 points) and turn on vertical center alignment. This creates breathing room and a polished look. For chart embed rows, use even taller values (100-150 points) so charts can render at a useful size.

Combine this with Page Layout view to preview how the rows will print, and you have a layout that looks crafted rather than auto-generated.

Putting It All Together

For one row, drag the border or double-click for AutoFit. For many rows, select first, then drag once or AutoFit once. For an exact value, use the ribbon dialog or the Alt-H-O-H shortcut on Windows.

For bulk changes across hundreds of rows, use VBA. For a workbook-wide default, save as book.xltx in XLSTART. When something will not resize, check for merged cells, frozen panes, or sheet protection first.

With these methods in hand you should never be stuck with clipped text or oversized rows again. If you are getting deeper into Excel formatting, our masterpage at Excel Practice Test brings together every guide on the site plus 200+ practice questions for certification prep.