If text in an Excel merged cell is not wrapping, select the merged cell and choose Home > Wrap Text, then increase the row height if any lines are still hidden. Excel often does not automatically AutoFit the height of a row containing a merged cell, so turning on wrapping alone may not make all the text visible.
Why wrapping can look broken in a merged cell
Wrap Text controls whether Excel displays a cell’s contents on multiple lines to fit its width. A merged cell spans several columns, and Excel treats that combined area as one cell for display. When the text exceeds the available width, it can wrap—but the row still needs enough height to show the extra lines.
This creates a common mismatch: wrapping is enabled, but the row height stays at its previous setting. The first line appears while later lines are clipped, or the text seems to spill into an adjacent row. The content may be present and the setting may be on; the row simply is not tall enough to display it all.
There is another important detail: a merged range keeps the content from its upper-left cell. If you expected text from another cell in the selected range to appear after merging, Excel may have discarded it. Wrapping cannot restore content that was removed during the merge.
Turn on Wrap Text and check the alignment
In Excel for Microsoft 365 on Windows, select the merged cell and go to Home > Wrap Text. The button is in the Alignment group. If the text still looks cut off, check that the cell has not been given a fixed row height that is too small.
- Select the merged cell or merged range.
- Choose Home > Wrap Text. If it is already highlighted, click it off and on once to refresh the display.
- Choose Home > Top Align in the Alignment group if you want the first line to sit at the top of the taller row.
- Increase the row height, using the methods below, until every line is visible.
On Windows, Alt+H, W is the ribbon KeyTip sequence for Wrap Text. KeyTips can vary with ribbon configuration, so the visible Home tab button is the straightforward option. On Excel for Mac, select the cell and use Home > Wrap Text; the ribbon layout may differ slightly. These steps change display formatting, not the underlying text.
Set the row height when AutoFit does not work
For a normal, unmerged cell, AutoFit Row Height usually adjusts the row to show wrapped content. Merged cells are a known exception: Excel may not calculate the required height correctly for a merged area. Selecting Home > Format > AutoFit Row Height is worth trying, but if the row does not change, set its height manually.
- Drag the lower boundary of the row number downward to make the row taller. If the merged cell spans several columns but only one row, adjust that row.
- For a specific measurement, select the row and choose Home > Format > Row Height, then enter a larger value.
- If a merged range spans more than one row, adjust the heights of the rows it covers and check the result. The visible space is shared across those rows.
Row Height uses points, not a number of text lines. The right value depends on the font, font size, column width, and the text itself. Increase it in small increments and check the result at the worksheet’s normal zoom. A row can be too short even when Wrap Text is on, and making the column wider may reduce the height needed.
Check the merged width and the text itself
Wrapping is based on the width of the entire merged area. For example, if a cell is merged across columns B through D, Excel uses the combined width of those columns. If the merged area is narrow, a sentence may occupy many lines and need a much taller row. Widening one or more of the columns can reduce the number of lines.
Check for formatting that makes the text harder to read, too. A small font, indents, or a large font size can change how much fits on each line. If the cell is horizontally centered, the text may look unusual once it wraps; try left alignment for paragraphs. Vertical alignment such as Bottom Align can also make the first visible line appear lower in a tall row. Top Align is useful while diagnosing clipped text.
If only part of the content appears, click the cell and inspect the formula bar. It shows the cell’s contents even when the worksheet display is clipped. This helps distinguish a display problem from missing or shortened text.
Use a manual line break for a deliberate layout
Wrap Text places line breaks according to the available width, so the exact line endings can change when columns are resized or the font changes. If you need a heading or label to break at a particular point, insert a manual line break within the cell. On Windows, edit the cell, place the insertion point where the next line should begin, and press Alt+Enter. In Excel for Mac, the usual shortcut is Control+Option+Return.
A manual break does not replace Wrap Text or adequate row height. It sets a chosen break, while the row still must be tall enough to show both lines. For instance, a long heading might be entered as Product availability, followed by a manual break, then Updated weekly. If the heading is in a merged range, turn on Wrap Text as well and increase the row height if needed.
Manual breaks are most useful for titles and short labels. They are less convenient for paragraphs that change frequently, because editing the text may require repositioning the breaks.
Common causes to rule out
If the basic fix has not worked, check these possibilities before changing the workbook structure:
- The row is hidden or extremely short. Select the relevant row numbers, then use Home > Format > Row Height to assign a visible height.
- The wrong cell is selected. A merged range may cover several columns. Click inside it and confirm the selection, then apply Wrap Text to that range.
- The text is not in the upper-left cell. Merging retains only the upper-left cell’s value. Check the formula bar and, if necessary, undo immediately or restore the other content from a backup.
- The merged area is too narrow. Widen its columns, reduce the font size where appropriate, or use a less restrictive layout.
- A fixed row height is limiting the display. Set a larger height manually instead of relying on AutoFit.
- The cell contains a formula returning a long result. The same wrapping and row-height rules apply to displayed formula results; check the formula bar to confirm the returned text.
Also distinguish wrapping from shrinking text. Format Cells > Alignment includes a Shrink to fit option. That reduces the displayed font size to fit the cell width rather than creating additional lines. It may be useful for short labels, but it is not the same as wrapping and can make long text difficult to read.
Consider an alternative to merging
Merged cells can make a heading appear centered over several columns, but they can complicate row sizing and make sorting, filtering, copying, and selecting ranges less convenient. If a merged cell is causing repeated layout problems, consider whether the visual result can be achieved without merging.
For a centered heading across columns, select the cells and open Format Cells with Ctrl+1 on Windows. On the Alignment tab, choose Center Across Selection from the Horizontal list. This centers the text from the leftmost selected cell across the selected cells without combining them into one cell. On Mac, open Format Cells with Command+1. The option is an alignment setting, not a merge command.
Another option is to keep the text in one ordinary cell and widen that column, or place a heading in a separate row above the data. For longer notes, use a wider unmerged cell and wrap the text. Keeping each data value in its own cell is especially helpful when the worksheet will be sorted, filtered, or used as a source for formulas and charts.
Keep merged-cell formatting manageable
For a worksheet that already uses merged ranges, consistent formatting helps prevent surprises. Apply wrapping and alignment deliberately, allow enough row height for the longest likely entry, and review the layout after changing column widths or fonts. If entries vary greatly in length, test the longest one rather than sizing the row around a short example.
Before merging cells that already contain information, check every cell in the proposed range. Excel’s merge warning is important: only the upper-left value is retained. If the other values matter, cancel the merge and combine the information in a separate cell or redesign the layout first. This is a data-preservation issue, not a text-wrapping setting.
Frequently Asked Questions
Why does AutoFit Row Height not work on merged cells?
Excel may not calculate the required height for a merged cell when using AutoFit. Turn on Wrap Text, then drag the row boundary or use Home > Format > Row Height to set enough space manually.
Does Wrap Text work with merged cells in Excel?
Yes. Select the merged range and choose Home > Wrap Text. The limitation is that the row height may not expand automatically, so wrapped lines can remain hidden until you increase it.
How do I show all text in a merged cell?
Enable Wrap Text, check the merged area’s width, and make the row tall enough to display every line. Top Align can make the beginning of the text easier to see while adjusting the layout.
Will unmerging cells delete the text?
Unmerging normally leaves the retained value in the upper-left cell; it does not recreate values that were lost when the cells were originally merged. Check the range before merging, and keep a backup if its contents matter.
What can I use instead of merged cells?
For a heading centered across columns, try Format Cells > Alignment > Horizontal > Center Across Selection. For data or long notes, separate cells with suitable column widths and wrapping are often easier to manage.
Related
- Excel: How to Hide Column Lines and Gridlines on a Worksheet
- Excel Hide Column Letters? What the Setting Actually Does
- Excel Heatmap Table: How to Create and Read One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- 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…
- Hyperlink Not Working in Word Header? Fixes That HelpA hyperlink in a Word header usually works, but Word may require a modifier-click to open it, or…
- Excel Text to Columns With Dates: Fix Date FormatsTo convert text dates in Excel, select the cells, choose Data > Text to Columns, move through the…
- Why Is IFERROR Not Working in Excel?IFERROR works only when the expression inside it returns an Excel error; it will not replace ordinary text,…
- Excel Column Filter Not Showing All Values? Fix ItIf an Excel column filter is not showing all values, first clear filters on the other columns and…
- Excel MATCH Not Working? Fix Common Lookup Errors FastIf Excel MATCH is not working, first force an exact match by setting the third argument to 0,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.