If Excel AutoFit row height is not working, select the affected rows and choose Home > Format > AutoFit Row Height. If the text still appears cut off, check for merged cells, disabled Wrap Text, a protected sheet, or a row-height limit; these are common reasons AutoFit cannot show all the content.
Try the quick AutoFit fix first
In Excel for Microsoft 365 on Windows, select the row or rows by clicking their numbers along the left edge of the worksheet. To select the whole sheet, click the Select All button at the intersection of the row and column headings. Then choose Home > Format > AutoFit Row Height. This tells Excel to recalculate the height for the selected rows using their contents.
You can also position the pointer on the lower boundary of a selected row number and double-click. Excel adjusts that row to fit its content. If you select several rows first, the command applies to all of them. A drag on the boundary is different: it sets a height manually rather than asking Excel to calculate one.
Before troubleshooting further, check that the text is actually in the cells you expect and that the relevant rows are selected. A row hidden by a filter, collapsed outline, or manually hidden setting will not become visible just because you run AutoFit. If needed, unhide it from the row-heading context menu, then apply AutoFit.
How AutoFit row height works
AutoFit is a sizing calculation, not a general repair for every display problem. Excel estimates how much vertical space the cell contents require, taking the column width and text formatting into account. A narrow column usually creates more wrapped lines and therefore needs a taller row; a wider column may fit the same text on fewer lines.
For ordinary text, Excel needs Wrap Text enabled if the text is meant to appear on multiple lines within the same cell. Select the cells and choose Home > Wrap Text. You can also insert a deliberate line break while editing a cell with Alt+Enter on Windows. If that text should occupy multiple visible lines, wrapping should be enabled as well.
AutoFit applies to the row, not to an individual cell in isolation. The row must be tall enough for the cell in that row that needs the most vertical space. Other cells in the same row may consequently have extra blank space below their contents. Column width is controlled separately, so AutoFit Row Height will not widen a column or correct a column-width problem.
Diagnose the problem in a few checks
Use a simple test to determine whether the issue is with the data, formatting, or worksheet settings. In an empty area, enter a short sentence in a cell, turn on Wrap Text, and narrow the column. Then select that row and run AutoFit Row Height. If the test row expands correctly, the original cells likely have a special condition such as merged cells, unusual formatting, or a manually hidden row.
- Text is on one line and clipped: Turn on Wrap Text if you want the text to continue on lines within the cell. Otherwise, widen the column or use a shorter display value.
- Text wraps but the bottom lines are missing: Select the row and run AutoFit again. If it still fails, check for merged cells, protection, or a maximum-height issue.
- Only some rows fail: Compare their merge status, cell formats, font sizes, and row heights with a row that works.
- The row number jumps over a number: The missing row may be hidden. Unhide it before adjusting its height.
- Text looks small or crowded at a different zoom: Zoom changes the on-screen scale, not the underlying row height. Check the cell at a comfortable zoom and inspect the actual row boundary.
It can also help to copy the problem cell into a blank worksheet using Paste Special > Values, then apply Wrap Text and AutoFit there. If the copied text displays correctly, the original worksheet’s layout or formatting is likely involved. This is a diagnostic test; it does not preserve the original cell’s formulas or formatting.
Common reasons AutoFit appears to fail
Wrap Text is off. AutoFit cannot display a long sentence on multiple lines if the cell is not set to wrap. The text may overflow into empty neighboring cells, or appear cut off when a neighboring cell contains data. Enable Wrap Text when the intended layout is a multi-line cell.
The row has a manually set height. A previous drag or Row Height command can leave a fixed height that is too small. Running AutoFit should recalculate the selected row, but make sure you have selected the correct row and are not merely dragging its boundary. If the row remains constrained, check whether the worksheet is protected.
The worksheet is protected. Protection can prevent changes to row formatting. If the sheet is protected, go to Review > Unprotect Sheet, if you have permission and the required password. Alternatively, ask the workbook owner to allow row formatting when protecting the sheet. Do not try to bypass protection; it may be there to preserve a controlled template.
Formatting makes the content larger than expected. A large font, a different font face, or mixed formatting within a cell can change the required height. If the text was pasted from another program, select the cells and inspect the font and size on the Home tab. As a test, apply a consistent font and size, then AutoFit again.
The row has reached a practical or technical limit. Excel rows have a maximum height of 409 points. Very long text, large fonts, or many wrapped lines may not fit entirely within one row. In that case, split the content across rows, reduce the font size, widen the column, or place the full text in the formula bar or a separate document rather than expecting the row to grow without limit.
The content is hidden rather than clipped. A row may be hidden, or part of a grouped outline may be collapsed. AutoFit does not expand a collapsed group or unhide a row. Also, zoom level can make a correctly sized row look cramped on screen, but changing zoom is not a substitute for checking the row’s actual size.
Merged cells need a different approach
Merged cells are a frequent cause of AutoFit problems. Excel does not reliably calculate automatic row height for text in a merged range, because the text spans multiple cells while the height belongs to the row or rows underneath. A merged heading can therefore remain clipped even when Wrap Text is on and AutoFit has been applied.
The most reliable option is to avoid merging cells where text must size itself automatically. Instead, select the cells across which the heading should appear and use Home > Alignment dialog launcher, then set Horizontal to Center Across Selection. The text remains in the first cell, but the appearance can span the selected columns without creating a merged range. Exact dialog labels can vary slightly by Excel build.
If the cells must stay merged, set the row height manually: select the row and choose Home > Format > Row Height, then enter a height that displays the text. You may need to adjust the column widths, font, or row height until the full content is visible. Unmerging, running AutoFit, and merging again may not provide a dependable result, so verify the final layout rather than assuming the calculated height will persist.
A reliable order for fixing wrapped text
When you need a repeatable result, work through the settings in a consistent order. This helps distinguish a sizing problem from a cell-layout problem and avoids repeatedly changing row heights without addressing the cause.
- Select the relevant cells and confirm the intended column widths.
- Turn on Home > Wrap Text if the contents should display on multiple lines.
- Check whether any affected cells are merged. If they are, use a manual height or redesign the layout if practical.
- Confirm that the worksheet is not protected from row formatting and that the rows are visible.
- Select the affected row numbers, then choose Home > Format > AutoFit Row Height.
- Inspect the lowest line of text. If it is still missing, check the font, long content, and maximum row height, then set a manual height or change the layout.
On Excel for Mac, the Home tab also provides the Format and AutoFit Row Height commands, though ribbon arrangement and keyboard shortcuts can differ from Windows. The pointer method—select a row and double-click its lower boundary—is also useful. In Excel for the web, use the available Home formatting controls or the row-heading boundary; if a workbook feature or protected-sheet setting prevents the change, open it in the desktop app or ask the owner to adjust permissions.
When to adjust the row manually
AutoFit is convenient for ordinary worksheet text, but a manually specified height is often better for presentation layouts. Examples include a report with consistent row spacing, a form with designated writing areas, or a dashboard where changing content should not shift nearby objects. Select the row and choose Home > Format > Row Height to enter a value in points, or drag the lower row boundary while watching the height indicator.
Manual sizing is also appropriate when a cell is merged or contains so much text that it approaches Excel’s row-height limit. Consider whether the full text needs to be visible in the grid at all. A short summary in the cell with the complete note in a separate column, a comment, or a linked document can make a large worksheet easier to scan. For printed sheets, use Print Preview after changing row heights, since page breaks and the printed layout may make a screen-friendly arrangement unsuitable for paper.
Frequently Asked Questions
Why does AutoFit row height not work with Wrap Text?
First confirm that the relevant row is selected and run Home > Format > AutoFit Row Height. If the row still clips the wrapped text, check whether the cell is merged, the sheet is protected, or the content exceeds the usable row height. Merged cells are a particularly common exception.
How do I AutoFit all rows in Excel?
Click the Select All button above row 1 and left of column A, then choose Home > Format > AutoFit Row Height. This can change row heights throughout the worksheet, so use it carefully in a formatted report where deliberately consistent heights matter.
Can I double-click to AutoFit row height?
Yes. Select the row or rows, then double-click the lower border of one of the selected row headings. This asks Excel to fit the height to the contents. Dragging the same border instead sets a manual height.
Why does AutoFit work for some rows but not others?
Rows can differ in merge status, wrapping, font size, protection, visibility, and text length. Compare a failing row with a working one. If the failing row contains merged cells, use a manual height or replace the merge with Center Across Selection where the layout allows it.
Does AutoFit change the column width too?
No. AutoFit Row Height adjusts vertical space only. To size a column to its contents, select the column and choose Home > Format > AutoFit Column Width. Widening a column can reduce the number of wrapped lines, which may in turn reduce the row height needed.
Why is some text still missing after AutoFit?
The row may be at Excel’s 409-point maximum, the cell may be merged, or the worksheet may not permit formatting changes. Check those conditions and try a wider column, smaller font, split content, or a manual row height. Also confirm that the text is not simply hidden by a collapsed or hidden row.
Related
- Combine Excel Files: Practical Methods and Steps
- What Column Number Is V in Excel? Find It in Seconds
- How to Combine Two Cells in Excel and Keep Both Values
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Stuck on Not Responding? Causes, Fixes, and RecoveryIf Excel is stuck on Not Responding, first give it a few minutes if it may be calculating,…
- Excel TRUE/FALSE Formula Not Working? FixesIf an Excel TRUE/FALSE formula is not working, first check that it starts with =, that its cell…
- Excel REF Error When Pasting: Causes and FixesIf Excel shows #REF! after you paste, a formula has ended up with an invalid cell reference; the…
- Excel XLOOKUP Value Error? How to Find and Fix It FastAn Excel XLOOKUP #VALUE! error most often means the lookup array and return array do not have matching…
- Power Query Divide by Zero Error: How to Fix It QuicklyTo fix a divide-by-zero error in Power Query, check whether the divisor is zero or null before dividing,…
- Hyperlink Not Working in Outlook 365? Fixes to TryIf a hyperlink is not working in Outlook 365, first test it with Ctrl+click in classic Outlook, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.