Rows that look squashed, text that gets chopped off mid-word, headings that need a bit more room — sooner or later every spreadsheet user has to fix a row height. The good news? Excel gives you about six different ways to do it, and most of them take less than a second.

The bad news? Picking the wrong one can leave merged cells stuck or force you to redo the work every time you reopen the file. That's why most quick tutorials only get you halfway there.

This guide walks through every method — dragging the border, double-clicking for AutoFit, the right-click menu, the Format menu, the keyboard shortcut, and the VBA one-liner. You'll also see why rows sometimes refuse to resize (hello, merged cells), how wrap text changes everything, and what default Excel actually gives you out of the box.

If you're new to spreadsheets, the Excel basics guide covers the layout first. Otherwise, jump straight in — we'll go method by method, then troubleshoot the weird stuff at the end.

The fastest method most people learn first: drag. Move your cursor to the bottom border of the row header (that grey number on the left), wait for the cursor to turn into a double-headed arrow, then click and drag down. The row gets taller as you pull. Drag up and it shrinks. Release, and you're done — no dialogs, no menus.

Want to adjust several rows at once? Select them first. Click row 3, Shift-click row 8, then drag the border of any selected row. Every highlighted row resizes to match. This is the trick most spreadsheets skip — you don't have to redo each row one by one.

It also works for non-adjacent rows. Ctrl-click each row number you want, then drag any selected border. Perfect for sheets where headers live on rows 1, 15, and 30 and you want them all the same height.

One catch — if your row contains a merged cell, dragging can behave strangely. The row will resize but the merged content may not reflow. We'll cover that fix further down. For now, keep merged cells out of ranges you're bulk-resizing.

AutoFit is Excel's smart sizing feature. Instead of guessing how tall a row needs to be, Excel measures the tallest content in the row and resizes automatically. To trigger it, double-click the same bottom border of the row header you'd normally drag. The row snaps to fit whatever is inside.

This is hands-down the cleanest method when you've pasted in text that's longer than one line, or when wrap text is on and you want every line visible. AutoFit reads the actual rendered content height, including font size, line breaks, and wrap-text overflow.

For multiple rows, select them first and then double-click any selected border — they all autofit independently. Each row sizes to its own content, so a row with one line stays short while a row with five lines grows tall. If you have hundreds of rows, select the whole sheet with Ctrl+A and double-click any row border to autofit everything in one move.

AutoFit Row Height also lives in the Format menu, which we'll get to next. Both routes do the same thing — pick whichever feels faster. Some users prefer the menu because it leaves the click-target larger; others prefer the border double-click because it never misses.

If dragging feels imprecise, type the height directly. Right-click the row number and choose Row Height. A small dialog opens asking for a value in points. Type a number, click OK, done. Excel measures row height in points (1 point = 1/72 inch). The default is 15 points, which renders at roughly 20 pixels at standard zoom.

The same dialog appears via the ribbon: Home tab → Format (in the Cells group) → Row Height. The Format menu also has AutoFit Row Height right below it, and Default Width nearby for columns. Three settings, one menu — useful when you want everything in one place.

If you want a consistent look across a table, the typed-value approach beats dragging every time — pick 25 or 30 points for headings, 18 for body rows, and the whole sheet feels designed instead of accidental. Consistency is the difference between a spreadsheet that looks professional and one that screams homemade.

Need fixed heights across multiple rows? Select them all first, then open Row Height. The value you type applies to every selected row. This is faster than dragging when you have a target number in mind — no eyeballing, no re-adjusting.

Keyboard people, this one's for you: Alt+H+O+H. Press them in sequence (not at the same time) and the Row Height dialog opens. Alt activates the ribbon, H jumps to Home, O opens Format, H picks Row Height. For AutoFit Row Height the chord is Alt+H+O+A. Memorize those two and you'll never reach for the mouse again.

Other shortcuts in the same neighbourhood: Alt+H+O+W for column width in excel, Alt+H+O+I for AutoFit Column Width, and Shift+Space to select an entire row before applying any of the above.

Excel shortcuts stack — select rows with Shift+Space, extend with Shift+Down, then Alt+H+O+H sets the height. Three keystrokes and you're done. The whole flow takes less time than reaching for the mouse and right-clicking. Once it's muscle memory, you stop noticing it.

On Mac, ribbon shortcuts work a bit differently — the Alt-key chord isn't quite the same. We've got a section on that further down. For now, if you're on Windows, those four chords cover most of what you'll need day to day.

Excel's default row height is 15 points. That's not arbitrary — it's tied to the default font (Calibri 11), which needs about 15 points of vertical space to render without clipping. Change the font size and Excel doesn't automatically adjust rows; you'll have to AutoFit or set a new height yourself.

This catches people out when they bump headings up to 14pt or 16pt and wonder why the text looks cramped against the gridlines. The row didn't grow with the font. Either turn on wrap text and AutoFit, or manually set the row to 22 or 24 points to give the bigger font some breathing room.

If your file ends up with 4,000 rows all at custom heights and you want to wipe the slate clean, select all rows (Ctrl+A twice if needed), open Row Height (Alt+H+O+H), and type 15. Everything resets. AutoFit from there if you want Excel to size each row to its content again.

Wondering why rows still look truncated even after resizing? Usually one of two things: wrap text isn't on, so Excel doesn't know it needs to grow the row; or the row contains a merged cell, which breaks AutoFit. Both have fixes — read on for the troubleshooting section.

Wrap text and row height are joined at the hip. Without wrap text, Excel keeps every cell as a single line. Make the row taller all you like — the text stays on one line, with anything past the column width spilling over or getting hidden behind the next cell.

Turn wrap text on (Home tab → Wrap Text button, or Alt+H+W) and Excel breaks the content across multiple lines inside the cell. AutoFit Row Height then sizes the row to show every line. This combo — wrap text plus AutoFit — handles 90% of "my data got cut off" complaints with two clicks.

Merged cells are the troublemaker. Excel's AutoFit ignores merged cells because it can't decide which row should grow. The workaround: unmerge using the how to merge cells in excel controls, set the row height manually, then re-merge if you really need it.

Better still, use Center Across Selection instead of merge — the cells stay separate so AutoFit keeps working, but the text looks centred across the range. Find it under Format Cells → Alignment → Horizontal → Center Across Selection. It's the unsung hero of clean headers in financial models.

Freezing panes doesn't change row height behaviour, but be aware that the frozen rows keep their custom heights when you scroll. If your frozen header is 30 points tall, it stays 30 points tall while the data below scrolls past.

For repeating work — say you import a CSV every week and need every row at 25 points — drop into VBA. Press Alt+F11 to open the editor, insert a module, and paste a one-liner. The macro library is small but powerful for row-height work.

Rows("1").RowHeight = 30 sets row 1 to 30 points. Rows("1:10").RowHeight = 25 covers rows 1 through 10. Rows.RowHeight = 18 hits every row on the active sheet. Wrap it in a macro and bind it to a button if you do this daily, or save it to your personal macro workbook so it's available in every file.

Printing with custom heights? Excel respects whatever heights you've set when it sends the page to the printer. Use Page Layout view (View tab → Page Layout) to see exactly how rows will sit on paper before you commit. If a row pushes content onto a second page, drop the height a few points or use Page Break Preview to drag the break.

Combine custom row heights with frozen header rows and your printouts look polished instead of cramped. The Repeat Rows at Top setting (Page Layout → Print Titles) keeps your headers visible on every printed page — pair it with a 25-point header row and a clean design emerges.

Once your sheet looks right, the same principles carry into more advanced layouts — see autofit excel for the column-side story, since rows and columns share most of the same logic.

A few quick edge cases worth knowing about. The maximum row height Excel allows is 409 points — about 545 pixels. Try to set anything higher and Excel rejects the value silently. If you actually need a row that tall, you're probably better off using an image cell or a merged range across multiple rows.

Hidden rows show as zero height. Right-click and pick Unhide to bring them back, or select the rows around the hidden ones and set a specific height to reveal everything. If a row stubbornly refuses to show, it's almost always hidden rather than zero-height.

Conditional formatting doesn't change row height — it only changes fill colour, font style, and the like. If you want rows to grow when a condition is met, you'll need a Worksheet_Change event in VBA. That's more advanced than most users need, but it's there if your workflow demands dynamic sizing.

Tables (Insert → Table) inherit row height from the sheet defaults but allow per-row overrides. Filtering doesn't reset heights; sorting doesn't reset heights. Once you've set a row to 25 points, that height travels with the data row wherever it ends up in the sort order.

Touch and stylus devices (Surface, iPad with mouse, Mac trackpad) all support drag-to-resize on row borders, but the target area is smaller and the gesture less precise. If you're working on touch, switch to the typed-value method — right-click and pick Row Height, or use the Format menu. Less squinting, fewer misses.

Zoom level affects how easy it is to grab the border. At 100% zoom the border is a comfortable target. At 50% it's a hairline. Bump zoom up to 150% temporarily if you're doing detailed border-dragging work, then zoom back down once the heights are set.

Display scaling on high-DPI monitors can confuse Excel — rows that render at exactly 15 points on one monitor might look slightly taller or shorter on another. Excel's measurement is consistent in points; it's the pixel rendering that varies. Trust the points value and ignore the pixel preview when sharing files across monitors.

For collaboration, row heights set in the desktop app sync to the web version and mobile apps. Anyone opening the file in Excel for the web or on their phone sees the same heights. Just remember that some mobile views ignore row height beyond a certain limit to keep cells tappable.

Pick the method that matches the moment. Drag when you're just eyeballing one row. Double-click for AutoFit when the content is variable. Type an exact value when consistency matters. Reach for Alt+H+O+H when you've got the keyboard in flow, and drop into VBA when you're cleaning up the same sheet every week.

The trick isn't memorizing one method — it's knowing which to grab so you stop fighting the spreadsheet and get back to the data. Most users settle into a personal blend: drag for the casual tweaks, the Format menu for headers, the keyboard chord when they're heads-down in a long session, and the right-click menu when they're on a laptop trackpad and don't want to fiddle with a tiny border target.

If you take only one habit from this guide, make it the double-click AutoFit. It costs nothing, it never breaks (well, unless you've merged cells), and it handles the most common scenario — "this row got cut off" — without any thinking. Layer the typed-value approach on top for headers, and you've got 95% of layout work covered.

Want to keep sharpening the rest of your Excel toolkit? Autofit in excel covers the column-width companion to everything here, and how to multiply cells in excel shows how formulas tie into the layout choices you've just made. Layout and logic feed each other — sort one out and the other gets easier.