How to Adjust Row Height in Excel: Every Method, Shortcut, and AutoFit Fix

Adjusting row height in Excel sounds like the kind of thing you should be able to do in two seconds. Drag a border, type a number, move on. In practice, the moment your data starts wrapping, your fonts shift, or your sheet inherits formatting from somewhere else, the row sizing rebels. Cells get cut off at the bottom. Headers tower over the data. AutoFit refuses to fit. Print previews lie about what will actually appear on paper.

This guide walks through every reliable way to set, change, and lock row height in Excel, on Windows and Mac, including the shortcuts power users rely on, the AutoFit behaviour that catches people out, and the VBA snippets you can drop into a workbook when nothing else cooperates.

What row height actually means in Excel

Row height in Excel is measured in points, not pixels. One point equals 1/72 of an inch, which means the default height of 15 points is roughly 20 pixels at standard zoom. The maximum allowed height is 409.5 points, which is enormous, and the minimum is 0 (a hidden row).

The number you set is the height of the entire row from top border to bottom border. It is not the font size and it is not the cell padding. Change the font and Excel may quietly nudge the row height to fit; change the row height manually and Excel will stop trying to adjust automatically. That second behaviour is the source of about half the row sizing frustration you will ever encounter, and we will come back to it.

The fastest way: drag the row border

Move your cursor to the row header on the left (the column of numbers labelling each row). Hover over the line between any two row numbers and the cursor will change to a double-headed arrow. Click and drag down to make the row taller, drag up to make it shorter. Excel will display the current height in points as you drag.

To resize multiple rows at once, click the first row number, hold Shift, click the last, then drag any border between selected rows. Every selected row gets the same height. This is the trick most people miss; they resize one row at a time and wonder why a 200-row sheet takes ten minutes to tidy up.

Setting an exact height with the Row Height dialog

Dragging is fast but imprecise. When you need an exact value, use the dialog. Right-click any selected row header and choose Row Height. A small box appears asking for a value in points. Type a number and press Enter.

You can also reach this dialog from the ribbon. On the Home tab, click Format in the Cells group, then pick Row Height from the drop-down. Same result, longer journey. If you want to be efficient, learn the keyboard path: Alt + H, O, H on Windows opens the Row Height dialog directly. No mouse needed.

What value should you type? For single-line text at the default 11-point Calibri, 15 points is right. For 12 to 14 point fonts, somewhere between 18 and 22. For multi-line text with wrap turned on, you usually want AutoFit (covered next) rather than a fixed number.

AutoFit row height: the feature people want but rarely use right

AutoFit measures the tallest content in each selected row and sets the row height to match. Select the rows you want to size, then on the Home tab click Format and choose AutoFit Row Height. Done. Every selected row now hugs its content.

The faster way is to double-click the bottom border of any row header. Excel applies AutoFit to that single row. Want to AutoFit every row in the sheet? Click the triangle in the top-left corner of the grid (between the A column and the 1 row) to select everything, then double-click any row border. The whole sheet snaps to content. This same logic is the foundation of AutoFit Excel for columns and rows alike.

AutoFit has one quirk that catches everyone eventually. Once you set a row height manually, by dragging or typing, Excel marks that row as user-sized and stops adjusting it automatically. If you later turn on Wrap Text or add a longer string, the row will not grow. The fix is to AutoFit again, which clears the user-sized flag.

Why your row height will not change

Excel has a couple of conditions that disable row resizing entirely. Knowing them saves a lot of dragging at borders that refuse to move.

First, the worksheet might be protected. If Review > Protect Sheet is on, formatting changes including row height can be blocked. Unprotect the sheet to regain control.

Second, merged cells confuse AutoFit. When a cell is merged across columns, AutoFit Row Height ignores the wrapped content in the merged range. The row will refuse to grow no matter how much text you cram in. The workaround is either to unmerge the cells and use Center Across Selection for the same visual effect, or to set the height manually.

Third, the row might already be hidden. A hidden row in Excel has a height of zero. If your row appears to be missing, right-click the row numbers above and below the gap, choose Unhide, and the row reappears at its old height.

Resize every row in the sheet to the same height

This is the cleanest layout move for tables, dashboards, and printable reports. Select All (Ctrl + A, or click the triangle at the top-left of the grid), right-click any row header, choose Row Height, type your value, press Enter. Every row in the sheet is now identical. Combine that with a similar treatment of columns from How to Adjust Column Width in Excel and your sheet starts to look engineered rather than improvised.

If you only want to apply a uniform height to a region, select that block of rows by clicking the first row number, Shift-clicking the last, and using Row Height the same way. Selecting a range of cells works too. Excel applies the change to every row that intersects the selection.

The keyboard shortcuts worth memorising

If you adjust row height more than once a week, learn these. They are faster than any mouse path.

On Windows, Alt + H, O, H opens Row Height. Alt + H, O, A AutoFits the selected rows. Shift + Space selects the entire row that your cursor is in, which is useful before either of the above. Ctrl + Shift + 9 unhides selected rows; Ctrl + 9 hides them (sets height to zero).

On Mac, there is no direct equivalent for the Alt-key ribbon shortcuts, but you can use the Format menu (Format > Row > Height, or Format > Row > AutoFit). For Mac power users, building a custom shortcut through System Settings pointing to Row Height in Excel is the trick that bridges the gap.

Make rows resize automatically as you type

When you turn on Wrap Text (Home > Wrap Text, or Alt + H, W on Windows), Excel will normally grow the row to fit the wrapped content. Normally. If a row has been manually sized, wrap text will not resize it; the text wraps but the row stays short and the bottom lines get clipped.

The fix is to AutoFit those rows once. Select the rows, double-click any row border in the selection, or use Format > AutoFit Row Height. From that point forward, Excel treats them as auto-sized again and will grow them as you add more text.

This combination of Wrap Text and AutoFit is what powers most readable data tables. Without it, long entries either disappear behind the next column or get cut off vertically. With it, the table breathes.

Excel for Mac: where the same options live

The Mac version of Excel uses a Format menu rather than a fully tabbed ribbon for some operations. Select your rows, then go to Format > Row > Height to set an exact value. Format > Row > AutoFit runs the AutoFit logic. The right-click context menu also includes Row Height and AutoFit Row Height, which is usually faster.

One Mac-specific note: trackpad gestures can interfere with dragging row borders precisely. If you find yourself overshooting, slow the trackpad tracking speed temporarily in System Settings, or hold the mouse button while moving very slowly. For pixel-perfect work, the Row Height dialog is more reliable than dragging on a trackpad.

Resize rows with VBA when nothing else works

For repetitive jobs across many sheets or workbooks, a macro beats clicking. Open the Visual Basic Editor with Alt + F11, insert a new module, and paste a short routine.

To set every row in the active sheet to 20 points: Rows.RowHeight = 20. To AutoFit every row: Rows.AutoFit. To target a range, qualify it: Range("A1:A100").EntireRow.RowHeight = 18. Run the macro with F5 and the whole selection responds instantly. This pairs nicely with deleting blank rows when cleaning up imported data.

If you build dashboards or recurring reports, putting a small Format Sheet macro on a button at the top of every workbook saves a few minutes per file. Worth it after the third repetition.

Row height for printing: what changes

Print preview can be brutal. A sheet that looks fine on screen turns out to be too tall for one page, or the rows you carefully sized to 18 points look squashed on paper. A few things drive this.

Page Layout view (View > Page Layout) shows row height in inches or centimetres instead of points, which is what the printer cares about. Set heights in this view if you are sizing for a printed page. Page setup scaling also affects how rows appear on paper. If Fit to is set, Excel scales everything down, including row height, so what looked tall becomes compact.

For multi-page reports, repeated headers can throw the math off. Use Page Layout > Print Titles to lock the top rows that should repeat on every page. The body rows can then be sized for content; the headers stay fixed.

Common row height problems and quick fixes

Rows resize themselves when you change fonts. That is Excel auto-adjusting because the row was never manually sized. If you want them to stay put, set a height explicitly once.

AutoFit makes rows too tall. Usually a hidden character or trailing line break inside a cell is the cause. Use Find and Replace (Ctrl + H) to remove line breaks (search for Ctrl + J, replace with nothing) or unwanted whitespace, then AutoFit again.

Row height changes every time you reopen the file. Look for conditional formatting that adjusts font size based on a value. Excel may resize the row based on the largest font in any cell that ever displays, even briefly.

Different rows on different machines. Display scaling differs by monitor and OS settings. A row at 20 points renders at slightly different pixel heights on a Retina display versus an external 1080p screen, but the printed output is identical because points are absolute.

Building a sheet that stays consistent

Once you have row height right, the practical move is to combine it with a few other settings so the sheet stays clean as it grows. Use Wrap Text on text columns, set a uniform row height that fits two lines of your standard font, freeze the header row using How to Freeze a Row in Excel, and apply table formatting (Ctrl + T) so new rows inherit the same height.

The result is a sheet that scales gracefully. Whether you add ten rows or a thousand, every row is the same height, headers stay visible, text wraps without getting cut, and the layout survives sorting, filtering, and copying into other sheets.

Quick reference: row height values that work

If you would rather not think, here are the values that produce readable sheets at typical zoom levels. For single-line 11-point Calibri, use 15 points (default). For 11-point Calibri with light padding, use 18. For 12-point text or slightly more breathing room, use 21. For two lines of wrapped 11-point text, 30 points is comfortable. Header rows usually look right around 24 to 28 points, large enough to stand apart from the body without dominating the sheet.

For dashboards, pair these row heights with column widths in the 12 to 18 character range and your tables read like they were designed rather than typed. Throw in alternating row shading and the whole layout suddenly has the polish of a published report.

One last quirk: pasted content overriding your row heights

Pasting from another workbook or from a web page can drag the source formatting along with it, and row height comes with that formatting. A tidy 18-point row can suddenly jump to 45 points because the cell you pasted carried a wrap and a font size you did not ask for.

To prevent this, use Paste Special (Ctrl + Alt + V on Windows, or Edit > Paste Special on Mac) and choose Values, or Values and Number Formats. The data lands without disturbing the layout you built. If you have already pasted and the rows blew out, select them, run AutoFit Row Height once, then set the height manually to your preferred value.

Practice the row and layout skills

Reading about Excel features is one thing; remembering them under deadline pressure is another. Working through practice questions on row and column formatting, AutoFit behaviour, and keyboard shortcuts is the fastest way to make the knowledge stick. If you are preparing for an Excel proficiency test or an office assessment, timed practice reveals which features you have actually internalised and which ones still need a quick reference.