Autofit Row Height Not Working | Fast Fixes That Last

What Autofit Row Height Does Behind The Scenes

Autofit for row height tells Excel to scan the content in each cell of a row and then stretch or shrink the row so every visible line of text fits. The feature watches font size, wrapped text, and manual line breaks, and then sets a new height that matches the tallest cell in that row.

In a clean sheet, you select one or more rows, choose AutoFit Row Height, and each row snaps to a tidy size. When the feature misbehaves, the sheet often looks cramped, with text cut off, or bloated, with big gaps that waste space and push the sheet over extra pages when you print.

The behaviour follows clear rules once you know what can block automatic sizing. Most problems fall into a short list: manual row heights, merged cells, wrapped text that does not recalc, hidden columns with wrapped content, filters, and sheet protection. Each one changes how Excel reads the cells when it tries to adjust height.

One more detail matters here: AutoFit Row Height only reacts to content that Excel thinks is “in play.” If a cell holds a long formula result, a hidden column holds wrapped notes, or the font size changes inside a single cell, the calculation can land in a place that looks odd to the person reading the sheet. That is why the same command can feel perfect in one workbook and messy in another.

Autofit Row Height Not Working In Excel: Quick Checks

Before you chase rare bugs, run through a fast checklist on the rows that refuse to resize. These checks clear many day to day glitches with just a few clicks and give you a sense of how the sheet has been built over time.

• Reset manual row height — Select the stubborn rows, go to Home > Format > AutoFit Row Height, then open the Row Height box once to confirm the value now updates instead of staying locked.
• Confirm Wrap Text settings — Select the cells, press Ctrl+1, open the Alignment tab, and make sure Wrap Text is on when you expect multiple lines or off when you want a single line.
• Clear Fill horizontal alignment — In the same Alignment tab, set Horizontal back to General or Left instead of Fill so Excel can shape the text with wrapping instead of stretching characters across the cell.
• Remove manual line breaks for a test — Press F2 in a cell, then use Ctrl+J in Find and Replace to strip Alt+Enter breaks, or retype a short sample to see whether the row starts to resize again.
• Turn filters off briefly — Remove filters, apply AutoFit Row Height on the full block of rows, then restore the filter if the view needs it.
• Check for sheet protection — Open Review > Unprotect Sheet and confirm there is no lock rule that blocks row height edits.

If one of these simple checks fixes the sheet, you can move on and keep working. If not, the cause usually sits with wrapped text, merged cells, or a mix of both, and those need a bit more care.

While you run these checks, keep an eye on the Name box and status bar. A quick glance at the row height value after each step tells you whether Excel has switched back to automatic sizing or is still stuck on a fixed number.

Fix Autofit Row Height Issues From Manual Layout Changes

Excel stores row height as either an automatic value or a specific number of points. Once a user drags a row border or types a height, Excel treats that row as fixed until you give it permission to adjust again. This often happens in shared workbooks where one person tidies a print view and the next person expects autofit to handle updates.

To bring a row back to automatic behaviour, select it and choose Home > Format > AutoFit Row Height. That command wipes the fixed height and recalculates the value from cell content. If you want a clean slate over a whole block, select the entire sheet with Ctrl+A, then apply AutoFit Row Height once so every row returns to an automatic state.

Hidden columns can also confuse the eye. A cell in a hidden column might hold wrapped text that drives a taller height than the visible cells seem to need. When you run into rows that look taller than any visible content, unhide nearby columns and check for long descriptions, notes, or comments stored in those hidden cells.

Printing adds one more twist. Page breaks can tempt users to drag row borders for visual spacing. Those manual tweaks linger long after the print job is done and can make autofit feel random from page to page. The fix is the same: clear manual heights by applying AutoFit Row Height over the region again, then adjust page breaks with margins or scaling instead of dragging row lines.

In long tables, it helps to separate layout rows from data rows. Keep spacer rows, signature lines, or title blocks in a small band at the top and bottom of a sheet, and leave the main data grid free for autofit. That way you can reset the core table without disturbing custom spacing that you really want to keep.

Autofit Row Height Issues With Wrapped Text And Line Breaks

Many sheets rely on wrapped text for headers, notes, and comments, and those cells often sit at the centre of row height problems. Wrapped text depends on both the Wrap Text flag and the column width, so when one changes and the other does not, the row height calculation can fall out of sync.

• Refresh wrapped cells — Toggle Wrap Text off and back on for the affected cells, then apply AutoFit Row Height once more so Excel recalculates the number of lines.
• Adjust column width before autofit — Set your final column width first, since the number of wrapped lines changes with width, then run AutoFit Row Height on the rows that hold the longest text.
• Replace manual breaks with natural wrapping — Where you can, remove Alt+Enter breaks and let Wrap Text decide where lines fall based on column width.
• Check header rows with long labels — Headers with long names often hold the tallest text in the table, so run autofit on the header row after any change in font size or width.

Manual line breaks are a frequent source of confusion. The Alt+Enter breaks remain stored even when you turn Wrap Text off, and they can drive odd spacing when you toggle wrapping later. Cleaning those cells pays off, especially in templates that many people reuse across months or years.

In some builds, you may also see mixed fonts or sizes inside a single cell. A bold word or a larger note at the end of a sentence can push the cell taller than neighbours that use one style. When that happens, autofit is doing what it should, yet the row height feels wrong when you only glance at the first few words. A quick check inside the cell often explains the extra height.

When Merged Cells Break Autofit Row Height

Merged cells are the single biggest reason some users see autofit row height not working again and again. Excel does not run AutoFit Row Height on rows that contain merged cells, and it also skips columns that contain merged cells when you use AutoFit Column Width. The behaviour is by design, not a bug.

That means any row that holds merged cells needs manual height control. You can still wrap text inside a merged range, but the row will not grow on its own. Instead, you must drag the border or assign a height that leaves enough space for the longest cell in that merged block. On wide reports with merged titles, this often explains why one band of rows never seems to respond.

Symptom	Likely Cause	Suggested Fix
Wrapped text cut off inside a title cell	Merged cells across several columns	Unmerge cells or set a manual row height that fits the text
Only rows with merged headers refuse to resize	AutoFit ignores rows that hold merged cells	Use Center Across Selection instead of Merge, then reapply autofit
Layout works in Google Sheets but not in Excel	Sheets handles merged cells and wrapping differently	Rebuild the header with unmerged cells for Excel versions

If you need the visual effect of text spanning several columns, Center Across Selection gives a cleaner result. Select the range, open Format Cells, choose the Alignment tab, and set Horizontal to Center Across Selection. The cells stay separate, so AutoFit Row Height can still read each column and respond to content changes.

For large blocks that must stay merged, a small helper macro can run through the range and assign row heights that match the content. That route takes a bit of setup and testing, yet it often beats dragging dozens of row borders by hand every time someone adds a sentence to a merged header.

Row Height Autofit Issues In Filtered Tables And Hidden Rows

Filters and hidden rows also affect the path of your fixes. AutoFit Row Height only runs on rows that are visible when you call the command, and it sets the height based on the visible cell content. This means a filter can hide the very cell that should drive the tallest height.

• Clear filters for a full reset — Remove all filters, select the full table, run AutoFit Row Height, then set the filter back to the needed view.
• Unhide collapsed outlines — Expand grouped rows before you use autofit so their content can influence the row height.
• Avoid mixing manual and automatic rows — If some rows stay fixed for layout reasons, keep them separate from the region where you rely on autofit.

Hidden rows that hold long notes can also drive irregular heights when you later unhide them. After you reveal those rows, run AutoFit Row Height once more so Excel recalculates heights based on the full set of visible cells instead of a partial view.

In Google Sheets, the Resize row > Fit to data command behaves in a similar way. Manual height changes, merged cells, and wrapped text can still limit automatic sizing. When you move workbooks between Excel and Sheets, a short pass through the rows with autofit or fit to data in each app keeps the layout consistent.

Stop Future Autofit Row Height Glitches

Once you clear the current problems, a few layout habits keep sheets tidy and reduce repeat work. Small design choices at the start of a workbook save time for everyone who edits it later and make future troubleshooting much simpler.

• Limit merged cells — Keep Merge & Center for rare decorative headings and prefer Center Across Selection for labels that span columns.
• Build stable column widths — Decide on standard widths for your main tables early so wrapped text behaves the same across similar sheets.
• Use styles for fonts and sizes — Define a cell style for body text and apply it everywhere instead of changing font size cell by cell.
• Reserve manual row heights for special blocks — Where you must lock a height, such as a signature area or spacer row, keep that region small and well marked.
• Test templates with long content — Before you share a template, paste long sample text into key cells and confirm that autofit behaves as expected.

With these habits, complaints about autofit for row height should fade from daily use. The feature still has limits, especially with merged cells and heavy wrapping, yet your sheets will feel cleaner, easier to scan, and far less prone to surprise gaps or clipped text.