Excel Row Height Shortcut: Set, Adjust, and AutoFit Rows

In Excel for Microsoft 365 on Windows, press Alt, H, O, H in sequence to open the Row Height dialog, enter a value, and press Enter. To fit a row to its contents instead, press Alt, H, O, A; these are sequential Ribbon key tips, not keys to hold down together.

The two row-height shortcuts

The first sequence, Alt then H, O, H, opens the Row Height dialog for the selected row or rows. Type a height in points and confirm. The second sequence ends in A and runs AutoFit Row Height, which adjusts selected rows to show their current cell contents.

To use either command, select at least one cell in each row you want to change. You can select a continuous range of rows by dragging across their row numbers, or select a single row by clicking its number at the left edge of the sheet. If you select several rows and enter one fixed height, Excel gives all of them that height. AutoFit instead calculates a suitable height for each selected row individually.

Set an exact height: Alt, H, O, H, enter a number, then Enter.
Fit content: Alt, H, O, A.
Check the key tips: press Alt and read the letters displayed on the Ribbon if your Excel language or layout uses different labels.

What row height means in Excel

Excel measures row height in points, a typographic unit; one point is 1/72 of an inch. The number in the dialog is therefore not a count of pixels. How tall a row looks on screen also depends on display scaling and zoom, so a value such as 30 points will not necessarily occupy the same number of screen pixels on every monitor.

A worksheet row can be as tall as 409 points. The usual starting height depends on the workbook’s default font and font size; 15 points is common, but it is not a universal setting. If a workbook uses a larger font, or a different default font, its standard row height may differ. This is one reason to use AutoFit or inspect the Row Height dialog rather than assume every workbook begins with the same measurement.

Height is a property of the whole row, not of one individual cell. If a row contains several cells, Excel must make enough vertical space for the tallest displayed content in that row. Increasing a single row’s height can therefore create extra blank space beside shorter entries in other columns.

Setting a precise height

Use the fixed-height command when you need consistent spacing, such as in a printed form, a checklist, or a report with uniform record rows. Select the relevant rows, open the Row Height dialog with the shortcut, enter the desired number of points, and confirm. For example, setting a group of rows to 24 points gives each selected row the same specified height, regardless of whether its cells contain short labels or longer text.

For the Ribbon alternative in Excel for Windows, go to Home > Format > Row Height. This is useful if the key-tip sequence is unavailable or you prefer to see the command before choosing it. The same Format menu also provides commands for column width, hiding rows, and fitting rows to their contents.

When planning a fixed height, consider the font, font size, and whether text wraps. A height that looks generous for a short label may cut off a multi-line note. If you deliberately need extra white space, a fixed value is appropriate; if the goal is simply to reveal all current text, AutoFit is usually the more direct choice.

Using AutoFit for changing content

AutoFit Row Height tells Excel to calculate the height needed for the content currently in the selected rows. It is especially useful after turning on Wrap Text, changing a font size, or pasting longer entries. The command is Home > Format > AutoFit Row Height, or the Windows key-tip sequence Alt, H, O, A.

AutoFit is a one-time adjustment, not a permanent rule that continuously monitors a row. If you later edit a cell, paste new text, change the column width, or apply a larger font, the existing row height may no longer be suitable. Run AutoFit again when needed. This distinction matters in templates: a row that fits today can clip newly entered content tomorrow.

Column width affects AutoFit because it changes how much text fits on each line. A narrow column can cause a wrapped entry to occupy several lines and require a taller row. If you are preparing a table, set the column widths first, turn on wrapping where appropriate, and then AutoFit the rows. Otherwise, a later width change may alter the line breaks and make the row height look wrong.

Wrapped text, merged cells, and clipped entries

For ordinary cells, the usual sequence for displaying a long entry is to select the cells, choose Home > Wrap Text, and then run AutoFit Row Height. Wrap Text allows content to continue on additional lines within the cell; AutoFit makes the row tall enough to display those lines. If wrapping is off, a long entry may appear to spill into empty cells beside it, or may look cut off when neighboring cells contain data.

Merged cells are a common exception. AutoFit may not correctly calculate the height needed for text in a merged range, because the content spans multiple cells while row height belongs to the row. If a merged heading is clipped, you may need to set the height manually, adjust the column widths or merge layout, or use a separate unmerged cell for the text. Do not assume that repeating AutoFit will fix every merged-cell layout.

Also check whether the row is hidden or whether the cell contains a line break. A hidden row has no visible height until it is unhidden. A manual line break, often inserted with Alt+Enter while editing a cell on Windows, creates another line of content; with wrapping enabled, that can increase the height required. If text still appears clipped, inspect the row boundary and the cell’s alignment and wrapping settings before changing the font.

Choosing between a shortcut, the mouse, and menus

The keyboard is quickest when you know the command and are already working in the grid. The mouse can be more intuitive when you only need to make a visual adjustment: move the pointer to the boundary below a row number and drag it up or down. Double-clicking that boundary applies AutoFit to that row. For multiple rows, select their row numbers first; dragging a boundary changes the selected rows together, while double-clicking fits the selected rows to their contents.

The menu is useful when you need to discover a command or verify its name. In Excel for Windows, use Home > Format > Row Height for a specified value, or Home > Format > AutoFit Row Height for content-based sizing. The menu route and key tips reach the same row-formatting commands; choosing one does not change the underlying workbook behavior.

On Excel for Mac, do not rely on the Windows Alt, H, O sequences. Use the Ribbon’s Home > Format menu and choose the row-height or AutoFit command, or use the macOS menu bar’s Format > Row options when available in your version. Excel for the web also offers row sizing through its Format controls, but Windows desktop key-tip sequences may depend on browser and keyboard handling. When a shortcut does not work, use the visible menu command rather than assuming the workbook is faulty.

Common problems and quick checks

If the shortcut seems to do nothing, remember that the letters are pressed one after another after Alt; do not hold all four keys simultaneously. Check that Excel is active and not in the middle of editing a cell. Press Esc to leave cell-edit mode, select the intended rows, and try again. Ribbon key tips can also differ with Excel’s display language, so the letters shown on screen are the best guide for that installation.

If the row height changes but the text remains difficult to read, check the cause rather than repeatedly increasing the number. Confirm that the correct row is selected, that Wrap Text is enabled when needed, and that the column is wide enough for a sensible number of lines. For merged cells, manually set the height or redesign the layout. If only some rows need adjustment, select those rows rather than the entire sheet to avoid creating unwanted blank space elsewhere.

One related shortcut distinction helps prevent mistakes: the key-tip sequence for row height ends in H, while AutoFit Row Height ends in A. The corresponding column commands are different: Alt, H, O, W opens Column Width, and Alt, H, O, I runs AutoFit Column Width. If a column became wider when you intended to change a row, check which final key you pressed.

Frequently Asked Questions

What is the shortcut to change row height in Excel?
In Excel for Microsoft 365 on Windows, press Alt, H, O, H in sequence. Enter the height in points in the dialog and press Enter.

What is the shortcut to AutoFit row height?
Select the row or rows and press Alt, H, O, A in sequence. Excel adjusts each selected row to fit its current contents where it can calculate the required height.

Why is my Excel row height not changing?
Make sure the row is selected and Excel is not editing a cell. Check whether the row is hidden, whether you used the row command rather than a column command, and whether merged cells are preventing AutoFit from sizing the content as expected.

Can I set the same height for several rows?
Yes. Select the rows, open Row Height, enter one value, and confirm. Excel applies that fixed height to all selected rows. AutoFit works differently: it sizes each selected row according to its own contents.

Does AutoFit update when I change the text later?
No. AutoFit adjusts the height based on the content at the time you run it. If later edits, a font change, or a column-width change cause text to wrap differently, run AutoFit again or set a suitable height manually.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.