Excel Row Won’t Expand? Fix Height and Hidden Rows

Errors & fixes · Updated November 18, 2026

If an Excel row won’t expand, select it and choose Home > Format > AutoFit Row Height, or drag the lower border of its row number downward. If the row is meant to grow to show wrapped text, turn on Home > Wrap Text first; Excel does not automatically increase row height every time you type or edit cell contents.

What “expand” means in Excel

People use “expand” to describe several different things in a worksheet. A row may be too short to display all its text, it may be hidden, or it may be part of a collapsed outline. Those problems look similar at a glance, but the fixes are different. Start by checking whether the row number is visible and whether the row’s contents are clipped. If the row number is missing, investigate hidden rows, filters, or grouping. If the number is visible but the text is cut off, adjust the height or wrapping.

Excel worksheets have a fixed grid: each row has a height, and each column has a width. Text does not make the grid automatically resize as you enter it. Instead, you can set a height yourself or use AutoFit to size a row for the content Excel can measure. AutoFit is an adjustment command, not a permanent rule that keeps changing the row after every later edit.

AutoFit a row to show its contents

In Excel for Microsoft 365 on Windows, select the row or rows, then choose Home > Format > AutoFit Row Height. To select a row, click its number at the left edge of the worksheet. To select several neighboring rows, drag across their row numbers; to select separate rows, hold Ctrl while clicking their numbers. You can also select the whole sheet with the triangle at the top-left corner of the grid, then run AutoFit Row Height, though that may change many rows.

There is also a quick mouse method: point at the bottom border of a row number until the pointer changes to a vertical resize indicator, then double-click. Excel adjusts that row to fit its current contents. Double-clicking the border between two selected row numbers applies the adjustment to all selected rows. Dragging the border instead sets a height by hand.

  • Windows ribbon shortcut: select the rows, then press Alt, H, O, A in sequence. These are ribbon Key Tips for Home, Format, and AutoFit Row Height.
  • Mac: select the rows and use Home > Format > AutoFit Row Height, or double-click the row boundary. Windows Alt-key sequences do not apply on Mac.
  • Set a precise height: choose Home > Format > Row Height, enter a value, and select OK. The value is measured in points.

AutoFit is useful for ordinary text and many other cell contents, but it may not produce the height you expect in every layout. If Excel appears to ignore the command, check wrapping, merged cells, hidden rows, and sheet protection before repeatedly resizing the same boundary.

Turn on Wrap Text before adjusting height

When a cell contains a long sentence, Excel may let the text extend into empty cells to its right. If the neighboring cell contains anything, the text is clipped visually. Wrap Text makes the content display on multiple lines within the cell’s existing column width. The row then needs enough height for those lines, which is why AutoFit Row Height is often the next step.

Select the relevant cells or rows and choose Home > Wrap Text. Then select the rows and choose Home > Format > AutoFit Row Height. Column width affects the result: a narrow column creates more wrapped lines and a taller row, while a wider column may allow the same text to fit on fewer lines. If you change the column width after fitting the row, run AutoFit again so the height can respond to the new wrapping.

For example, suppose a cell contains a two-sentence note in a narrow column. Without wrapping, the cell may show only the first part of the note. With wrapping enabled, the note can occupy several lines, but a fixed-height row may still hide the lower lines. AutoFit Row Height adjusts the row to show the visible wrapped content. It does not change the wording or widen the column.

Check for a hidden row, filter, or outline

If the row number itself is missing—for example, the labels jump from 12 to 15—rows 13 and 14 may be hidden. Select the row numbers on both sides of the gap, right-click the selection, and choose Unhide. You can also select the surrounding rows and choose Home > Format > Hide & Unhide > Unhide Rows. If the hidden row is at the top of the sheet, select the whole sheet before choosing Unhide Rows.

A filter can also make records disappear. Filtered-out rows are not the same as manually hidden rows, so the Unhide command may not bring them back. Look for filter arrows in the column headings and clear the relevant filter using the arrow’s Clear Filter option, or use Data > Clear to remove filters. This restores rows excluded from the current filter without changing the underlying data.

Rows grouped with Excel’s outline feature can be collapsed. Look above the row numbers for outline level buttons such as 1 and 2, or for a plus sign beside a group. Click the plus sign or choose a more detailed outline level to show the grouped rows. A minus sign indicates that a group is currently expanded. These controls hide or show a set of rows; changing row height will not expand a collapsed group.

Look for merged cells and other layout limits

Merged cells are a frequent reason AutoFit seems not to work. When a cell spans multiple columns, Excel may not calculate the needed row height correctly with AutoFit. The text can wrap, yet the row may stay too short or show only part of the content. This is a limitation of how AutoFit handles merged-cell layouts, not proof that the text has been deleted.

If the layout allows it, select the merged cell and choose Home > Merge & Center > Unmerge Cells, then use Wrap Text and AutoFit Row Height. Unmerging can change the appearance and placement of content, so inspect the affected cells before doing it in a shared or carefully formatted worksheet. If the merged layout must remain, drag the row boundary to a suitable height or use Home > Format > Row Height to enter a value. Check the result again if the text or column widths change.

Excel also limits the maximum row height to 409 points. If content still does not fit at that limit, it cannot be shown by making the row taller. Consider widening the column, reducing unnecessary line breaks, splitting the text across cells, or using a smaller font. Zoom changes how large a row looks on screen, but it does not increase the row’s actual height or create more space for its contents.

Check protection and manual sizing

A protected worksheet may prevent you from changing row heights. If Excel refuses to resize a row or the relevant controls are unavailable, open Review and look for Unprotect Sheet. If the sheet is protected with a password, you need permission and the password from whoever manages the workbook; there is no legitimate formatting command that bypasses that protection.

When setting up protection, the sheet owner can allow users to format rows. Choose Review > Protect Sheet, then enable Format rows in the permissions list before protecting the sheet. The exact options depend on how the worksheet is protected, and a workbook may also have other restrictions. Do not unprotect a shared file without considering whether protection is there to preserve a form or prevent accidental changes.

Manual sizing can also make the result seem inconsistent. A row previously set to a specific height remains at that height until you change it or run AutoFit. If the contents later become shorter, AutoFit may reduce the row; if contents become longer, run AutoFit again. A drag sets the height for the selected row but does not instruct Excel to keep adapting that height in the future.

A reliable troubleshooting order

Use this sequence to narrow down the cause without changing unrelated worksheet formatting:

  1. Check the row numbers. If there is a gap, try Unhide Rows; if the data is filtered or grouped, clear the filter or expand the outline instead.
  2. If the row is visible, select it and turn on Home > Wrap Text for text that should use multiple lines.
  3. Run Home > Format > AutoFit Row Height. If that does not work, double-click the row’s lower border or set a height through Home > Format > Row Height.
  4. Check whether the cell is merged. If it is, unmerge it if appropriate or set the height manually.
  5. If resizing is blocked, check Review for sheet protection and ask the workbook owner for access when needed.
  6. Review column width, font size, and zoom. A narrower column may create more wrapped lines, while zoom only changes the on-screen appearance.

Try the sequence on one row before selecting the whole worksheet. AutoFit may alter many carefully formatted rows if applied broadly, including rows used as headings or visual separators. If a workbook has a consistent report layout, it can be better to set the intended height for a small group of rows than to AutoFit everything at once.

Excel for Mac and Excel for the web

The main row-height controls are similar in Excel for Microsoft 365 on Windows and Mac: select the row, use the Home tab’s Format controls, or drag its boundary. On Mac, use the ribbon rather than Windows’ Alt, H, O, A Key Tip sequence. Keyboard shortcuts for selecting rows also differ: Windows uses Shift+Space to select the current row, while Mac commonly uses Shift+Space as well, subject to macOS keyboard settings and Excel’s shortcut preferences. If a shortcut is intercepted by the operating system, use the row number or ribbon command.

Excel for the web also provides row resizing and wrapping controls, but the exact menus and available features can vary with the web interface. If a worksheet’s row will not resize there, try opening it in the desktop app if you have access, particularly when the file uses complex merged cells or protection settings. Editing in the desktop app does not remove worksheet protection; you still need the required permission.

Frequently Asked Questions

Why does Excel not automatically expand a row when I type?
Excel keeps row heights fixed unless you change them or run AutoFit. Turn on Wrap Text if the text should display on several lines, then use Home > Format > AutoFit Row Height. You may need to run AutoFit again after changing the text or column width.

How do I make all text visible in an Excel row?
Select the row, turn on Home > Wrap Text for the relevant cells, and choose Home > Format > AutoFit Row Height. If the cell is merged, AutoFit may not calculate the height reliably, so unmerge it if suitable or set the row height manually.

Why can’t I unhide an Excel row?
Check whether the row is excluded by a filter or included in a collapsed outline; those are not necessarily fixed by Unhide Rows. Also check sheet protection. If row numbers skip over the missing row and there is no filter or outline, select the rows above and below the gap and choose Unhide.

Can an Excel row be taller than 409 points?
No. Excel’s maximum row height is 409 points. If the content does not fit, try a wider column, a smaller font, fewer line breaks, or a different layout rather than attempting to exceed the limit.

Why does AutoFit fail on a merged cell?
Excel may not calculate the height needed for wrapped text in merged cells. Unmerging the cell can allow AutoFit to work more predictably, but it changes the layout. If the merge must stay, adjust the row height manually and review it again when the text changes.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.