If Excel row AutoFit is not working, select the affected row or cells and choose Home > Format > AutoFit Row Height. If the row still will not expand, check for merged cells, text wrapping, hidden rows, or sheet protection; these are common reasons AutoFit does not produce the height you expect.
What AutoFit Row Height Does
AutoFit calculates a row height that can display the cell contents, using the column width, font, and formatting as part of that calculation. A short value in a wide cell may need only one line; the same text in a narrow cell may wrap onto several lines and require a taller row. If the contents fit on one line, AutoFit may leave the row at its existing or standard-looking height, so a lack of visible change does not necessarily mean the command failed.
Row height is measured in points, while column width is based on character-width units. The two dimensions are related in practice: changing a column’s width can change how many lines a wrapped entry needs, so the row may need to be autofitted again afterward. Excel also has a maximum row height of about 409 points. If a cell needs more room than that, AutoFit cannot display all of its contents in a single row.
AutoFit affects the selected rows. It does not automatically resize every row in a worksheet just because one cell has changed. It also sizes for cell contents, not for every object that happens to appear over a row, such as a floating text box or a picture.
Run AutoFit on the Correct Rows
Start with the direct command rather than repeatedly dragging a row boundary. In Excel for Microsoft 365 on Windows, select the row or rows, then use Home > Format > AutoFit Row Height. You can select a whole row by clicking its number at the left edge of the sheet. To select consecutive rows, drag across their row numbers or select the first row number and Shift-click the last.
- Fit one row: click its row number, then choose AutoFit Row Height.
- Fit several rows: select their row numbers and run the command once.
- Fit the used area: select the relevant cell range, then run AutoFit Row Height. Excel adjusts the rows represented in the selection.
- Resize by hand: drag the boundary below a row number. Double-click that boundary to autofit the row to its contents.
On Windows, the ribbon KeyTips sequence Alt, H, O, A opens the AutoFit Row Height command. Press the keys in sequence rather than holding them all down. The related sequence for AutoFit Column Width is Alt, H, O, I. On a Mac, use the Home tab’s Format menu for AutoFit Row Height; ribbon shortcuts differ from Windows, so the menu is the clearest route. In Excel for the web, look for the same row-height command on the Home ribbon, or double-click the boundary beneath the row number when the interface permits it.
Check Text Wrapping and Column Width
Wrapping is a frequent source of confusion. AutoFit can make a row taller to show wrapped text, but it does not turn wrapping on for you. Select the cells and choose Home > Wrap Text, then run AutoFit Row Height. If wrapping is off, a long entry may continue across empty cells or appear cut off at the edge of a neighboring nonempty cell while the row stays short.
Column width matters too. For example, a sentence that fits on one line in a wide column may occupy four lines after the column is narrowed. If you resize a column after fitting the row, run AutoFit again. Conversely, widening the column can allow Excel to reduce the row height. Check the actual column width and wrapping setting before concluding that row sizing is broken.
Manual line breaks can also affect the result. A line break inserted inside a cell with Alt+Enter on Windows creates multiple lines even if the text is otherwise short. AutoFit should account for those lines, but a narrow column, unusual formatting, or a row-height limit can still make the result look wrong. On a Mac, the key combination for inserting a line break differs; use the cell-editing command appropriate to your Mac version.
Common Reasons AutoFit Fails
When the command runs but the row remains too short, inspect the sheet for conditions that prevent Excel from calculating or displaying the expected height. These checks usually identify the problem faster than changing every row manually.
- The row is hidden: a hidden row has zero height, so it will not become visible just because you autofit it. Unhide it first by selecting the rows above and below, right-clicking a selected row number, and choosing Unhide. Then select the restored row and autofit it.
- The worksheet is protected: protection can block formatting changes, depending on the permissions chosen when protection was applied. On the Review tab, check whether the sheet is protected. The sheet owner may need to unprotect it or allow row formatting.
- The row has a manually set height: a fixed height can make the result appear unchanged if the content already fits or if the command was applied to a different row. Select the row explicitly and run AutoFit Row Height again. If you need a specific size, use Home > Format > Row Height and enter a value.
- The cell contains a formula: AutoFit uses the displayed result, not the formula’s intended meaning. If the formula returns a blank string or a short result, the row may remain short. If the displayed result is stale, recalculate the workbook and then autofit.
- There are leading spaces or unusual characters: pasted text can include spaces or line breaks that affect how it wraps. Click the cell and inspect the formula bar, or edit the cell to check for content that is not obvious in the grid.
- The font or formatting differs: a large font, superscript, or mixed formatting can alter the height needed. If a workbook uses a font unavailable on another computer, Excel may substitute a different font and render the text differently.
A filtered list needs a little care: rows hidden by a filter are not the same as rows that are simply visible. Autofit the rows that are currently shown, and clear the filter or unhide rows if you need to adjust entries that are not visible. If the range is part of a table, its filters do not change the basic row-height command, but they can make it easy to overlook which rows are selected.
Merged Cells Need a Different Approach
Merged cells are a well-known limitation for row AutoFit. When a cell spans multiple columns, Excel may not calculate the height needed for its wrapped text reliably. Running AutoFit on the row can leave the merged text clipped, even though the same text in an unmerged cell sizes correctly. Repeating the command often does not solve the underlying issue.
If practical, unmerge the cells and use a centered-across-selection format instead of merging. That keeps the cells separate, which generally works better with sorting, filtering, and automatic sizing. If the merged layout must stay, set the row height manually using Home > Format > Row Height, or adjust it by dragging the row boundary until the text is visible. A temporary unmerged cell with a similar width can help estimate the needed height, but the final merged row may still require manual adjustment.
Use a Reliable Troubleshooting Sequence
Follow these steps in order so you change the cause rather than merely hiding the symptom:
- Click the row number to select the affected row. Confirm that you have not selected a neighboring row by mistake.
- Check whether the row is hidden or whether a filter has hidden the record. Unhide it or adjust the filter as needed.
- Turn on Home > Wrap Text for the relevant cells if you want long entries to display on multiple lines.
- Set a useful column width. AutoFit the row after the width is final, because width affects wrapping.
- Choose Home > Format > AutoFit Row Height. If the result is still clipped, check for merged cells, protection, unusual fonts, and the maximum row height.
- If only some rows fail, compare one failing row with a working row. Look for merged cells, different font sizes, manual line breaks, or a different wrap setting.
When a formula or external data source has recently changed, ensure the displayed result is current before judging the height. Excel normally recalculates automatically, but a workbook set to manual calculation may not update until recalculation is requested. On Windows, F9 recalculates open workbooks; on a Mac, use the equivalent recalculation command available for your Excel version. After the result updates, run AutoFit again.
When Manual Row Height Is the Better Choice
AutoFit is useful for ordinary cell text, but it is not always the right tool. A report may need consistent row heights for printing, or a merged heading may need a deliberate layout. In those cases, select the rows and choose Home > Format > Row Height to enter a value, or drag the boundary to a suitable height. Apply a consistent value to the relevant rows if visual uniformity matters more than fitting each entry precisely.
Remember that manually increasing a row does not make text wrap. If the contents still appear on one line, turn on Wrap Text. Also, a tall row will not reveal text hidden by a white font, a custom number format, or a cell that displays a different value than expected. If your goal is to display long notes, consider widening the column, wrapping the cell, or placing detailed text in a separate notes column rather than making the whole sheet difficult to scan.
Floating shapes and text boxes are another separate case. A text box can overlap a row, but its contents do not determine that row’s height. Resize the object itself, or move it so it does not cover cell content. Likewise, images placed over cells may need their own sizing or positioning adjustments; AutoFit does not resize them to fit the row.
Excel Desktop, Mac, and Web Differences
The core behavior is similar in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web: select the rows and use the row-height AutoFit command. The location and appearance of ribbon controls can vary with window size and updates. On Windows, the menu path is Home > Format > AutoFit Row Height; on Mac, use the corresponding Format control on the Home tab. In the web app, the command may be easier to find by expanding the ribbon or using the row-header context menu.
If a workbook behaves differently between desktop and web, check whether the row is merged, whether the font is available in both environments, and whether a feature or formatting detail is being rendered differently. Open the workbook in the desktop app when you need more complete formatting controls or a precise manual height. Avoid assuming that changing zoom will repair the row: zoom changes how large the sheet looks on screen, not the underlying row-height value.
Frequently Asked Questions
Why does AutoFit Row Height do nothing?
It may have been applied to the wrong selection, the row may be hidden or protected, or the content may already fit. Merged cells and text that is not wrapped are also common causes. Select the row, check Wrap Text, and run the command again.
Why is wrapped text still cut off after AutoFit?
Check for merged cells first, because AutoFit may not size merged text reliably. Also confirm that the row is not at Excel’s approximate 409-point maximum and that the text is actually in the cell rather than in an overlapping text box.
How do I autofit every row in Excel?
Select the worksheet rows you want to change, or select the whole sheet using the Select All button at the top-left corner between the row and column headings. Then choose Home > Format > AutoFit Row Height. On a very large sheet, applying it to the used range can be quicker and avoids changing empty rows unnecessarily.
Does AutoFit work with merged cells?
Not reliably for wrapped text. Unmerge the cells if the layout allows, or set the row height manually. A centered-across-selection format can sometimes preserve the appearance of a heading without merging cells.
Why does row height change on another computer?
Different fonts, font substitutions, and rendering differences can change how many lines fit within the same width. Keep the workbook’s fonts consistent and rerun AutoFit on the computer where the final layout will be used; set a manual height if the layout must remain fixed.
Related
- Excel Number Format to Hide Zeros Without Changing Values
- Excel Number Custom Format Codes: Examples and Tips
- Excel No Color Fill: How to Remove a Cell’s Background
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- ISNUMBER Not Working in Excel? Common Causes and FixesIf ISNUMBER is not working in an Excel formula, first check whether the value is really a number:…
- Excel LET Function Not Working? Fix Common ErrorsIf Excel LET is not working, first confirm you are using Excel 2021 or Microsoft 365, then check…
- Excel Equal Formula Not Working? Common FixesIf an Excel equality formula is not working, first check that it is entered as a formula and…
- Excel Not Letting Me Drag Formulas? Fix the Fill HandleIf Excel will not let you drag a formula, first check that the fill handle is enabled: go…
- Conditional Formatting in Excel Not Working?If conditional formatting in Excel is not working, first open Home > Conditional Formatting > Manage Rules and…
- Excel Find Not Working? Fix Search and Find SettingsIf Excel Find is not working, press Ctrl+F, open Options, and check the search scope and Look in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.