Excel Text Wrapping Not Working? Fix the Common Causes

Errors & fixes · Updated November 3, 2026

Excel Text Wrapping Not Working? Fix the Common Causes

If text wrapping is not working in Excel, select the affected cells and choose Home > Wrap Text, then make sure the row is tall enough to show the extra lines. If the text still looks cut off, check for a fixed row height, merged cells, or a column wide enough that wrapping is not needed.

What Wrap Text does in Excel

Wrap Text changes how text is displayed inside a cell: instead of continuing across the empty cells to its right, the text appears on multiple lines within the cell’s existing column width. It does not change the underlying value, add spaces, or insert line breaks into the cell’s contents. A narrow column may therefore make a sentence occupy several visual lines, while widening the column can reduce the number of lines.

In Excel for Microsoft 365 on Windows, select one or more cells and use Home > Wrap Text in the Alignment group. The Windows ribbon shortcut is Alt+H, W. The button may appear highlighted when wrapping is enabled for the selection. On Mac, use Home > Wrap Text; the exact keyboard shortcut can vary with the keyboard and Excel version. Excel for the web also has Wrap Text on the Home tab.

Wrapping applies to cell contents, not to the worksheet as a whole. You can select a range, an entire row or column, or the whole sheet before turning it on. The display may change immediately, but the row height may also need to adjust before every line becomes visible.

Start with a quick troubleshooting sequence

Try these steps in order. They distinguish a wrapping setting problem from a layout problem, which is often the reason the button seems to have no effect:

  1. Select the cell or range containing the text. If you are unsure which cell is affected, click it and check the Name Box to the left of the formula bar.
  2. Choose Home > Wrap Text. If the button is already active, click it off and on again to refresh the setting.
  3. Widen or narrow the column slightly. If the text is shorter than the available width, there may be no visible change even though wrapping is enabled.
  4. Increase the row height, or use Home > Format > AutoFit Row Height. You can also double-click the boundary below the row number to fit the row to its contents.
  5. Check whether the cell is merged with neighboring cells. If it is, unmerge it temporarily and test wrapping in a normal cell.
  6. Open Format Cells and inspect the Alignment settings if the ribbon button and the result do not agree.

After changing the column width or cell contents, check the row height again. A row that fitted yesterday may not fit after a longer value is entered, a formula returns more text, or someone changes the column width.

Check row height and column width

A common misconception is that turning on Wrap Text automatically guarantees that the whole cell will be visible. Wrapping determines where text is displayed on multiple lines, but a row with a manually fixed height can still clip those lines. For example, a cell containing a two-line address may have Wrap Text enabled while its row remains only tall enough for one line.

To let Excel size a row, select it and choose Home > Format > AutoFit Row Height. You can select several rows first to fit them together. Double-clicking a row boundary is a quick alternative. If AutoFit does not produce the expected height, drag the row boundary down manually and see whether the hidden lines appear.

Column width has a different effect. A wider column gives Excel more room per line, so fewer lines are needed; a narrower column creates more. If the column is very wide, wrapping may be on but appear to do nothing because the full text fits on one line. If a cell contains a long identifier with no spaces, its display can also be less intuitive than ordinary sentences. Test with a short sentence containing spaces to separate a layout issue from a content-specific one.

When several rows are selected, AutoFit may adjust each row to its own contents. That can produce uneven row heights, which is normal. If a report needs uniform rows for visual consistency, set a common height after deciding how much text should be visible; doing so may mean some wrapped content is clipped.

Merged cells and other layout limits

Merged cells are one of the most persistent causes of confusing results. Excel does not reliably AutoFit row height for cells merged across columns. A merged heading can wrap but remain partly hidden because the row does not grow to match its text. Unmerge the cell and test again; if that fixes the display, the merge was affecting the sizing behavior.

If you need a heading centered across several columns, consider selecting the range and using the alignment option Center Across Selection rather than merging cells. This keeps the cells separate, which can make sorting, selecting, and sizing more predictable. The setting is available in the Format Cells dialog under Alignment, in the Horizontal alignment list. Another practical option is to reserve one wide cell for the heading and format it without merging.

Fixed row heights can also be intentional, such as in a printable form or a compact dashboard. In that situation, wrapping cannot make the row taller without changing the layout. Increase the row height, reduce the font size, widen the column, or shorten the displayed text. Shrink to fit is another alignment option, but it reduces the font size so the content fits on one line; it is not the same as wrapping and can make text difficult to read.

Inspect alignment and cell formatting

If Wrap Text appears enabled but the cell still behaves unexpectedly, open Format Cells. On Windows, press Ctrl+1, choose the Alignment tab, and check the Text control options. On Mac, Command+1 opens Format Cells in many Excel configurations; if that shortcut is unavailable, open the Format Cells dialog from the ribbon or menu. Confirm that Wrap text is selected. You can also review the horizontal and vertical alignment options there.

Formatting can be copied into a cell along with other properties. For example, using Format Painter or pasting formatted cells may bring across a fixed row height, a merge, or a different alignment. To isolate the issue, copy the text and paste it into a blank, unmerged cell with a standard row height, then enable Wrap Text. If it works in the new cell, the original cell’s layout or formatting is the likely cause.

Clearing all formatting can remove useful number formats, borders, and colors, so do not use it as the first repair. If you want to test formatting without damaging the original, make a copy of the cell or workbook first. You can also use Home > Clear > Clear Formats on a test cell, then reapply the formatting you need.

Text, formulas, and manual line breaks

Wrap Text works with text typed into a cell and with text returned by a formula. It affects presentation only: a formula result remains the same value even when Excel displays it on several lines. If the formula result is short enough to fit the column, enabling wrapping may produce no visible difference. If the result is longer, check the row height as well as the setting.

A manual line break is different from automatic wrapping. On Windows, while editing a cell, press Alt+Enter to start a new line at a specific point. On Mac, Option+Return inserts a line break in a cell. Wrap Text may be needed to show the resulting lines correctly, and the row still needs enough height. Manual breaks are useful for addresses or labels where you want a particular phrase to begin on a new line; automatic wrapping is better when the line breaks should respond to column width.

For example, an address entered as one continuous line can wrap wherever the available width requires. If you want the street and city on separate lines regardless of width, insert a manual line break between them. If you later change the column width, the automatic line breaks can shift, while the manual break stays at the point you entered. Neither method changes the cell into multiple cells.

Distinguish wrapping from text overflow and clipping

When a cell’s text extends into an adjacent blank cell, that is overflow, not wrapping. Excel can display the extra text across empty cells, but content in the neighboring cell blocks that display. This often makes a value look cut off even though it is still present in the original cell. Turn on Wrap Text or widen the column if you want the content contained within its own cell.

Clipping is different again: some of the text is present but not visible because the row or column cannot display it. A narrow column can hide text that would otherwise overflow if the next cell is occupied. A short fixed-height row can hide lower wrapped lines. Select the cell and look at the formula bar to confirm whether the full value is stored before changing or retyping anything.

These distinctions matter when printing too. A worksheet may look readable on screen but print with cut-off lines if row heights, page scaling, or column widths change. Use Print Preview to inspect the result. Page scaling can shrink the sheet to fit a page, but that reduces the printed size; it does not repair a row that is too short to show its contents.

When the setting will not stay on

If wrapping turns off again or changes in only part of a range, first check whether you selected the cells you intended. A selection can include cells with mixed formatting, so the ribbon button may show a mixed or unclear state. Apply Wrap Text to the entire target range, then verify a few individual cells. Also check whether the cells are part of a merged range, table, or copied block with inconsistent formatting.

For a workbook shared with others, confirm that the change is saved and that you are editing the active file rather than a read-only copy. In Excel for the web, changes normally save to the workbook online, but a browser view or editing permission can affect what you can change. On Windows or Mac desktop, save the workbook and reopen it if the display seems stale. Avoid repeatedly changing settings before checking the row height; the setting may already be correct.

If only one worksheet is affected, compare its cell formatting with a working sheet. If the issue affects many sheets, try the same text in a new blank workbook. A successful test there points toward formatting or layout in the original file; a failed test may indicate a broader application or display issue. Updating Excel can help with software problems, but ordinary wrapping failures are more often explained by row height, merges, or alignment.

Frequently Asked Questions

Why does Wrap Text show as on, but the whole text is not visible?
A fixed row height or merged cell may prevent all wrapped lines from appearing. Use AutoFit Row Height or increase the height manually, and test an unmerged cell if necessary.

How do I make Excel automatically adjust row height for wrapped text?
Select the row or rows and choose Home > Format > AutoFit Row Height. You can also double-click the boundary below a row number. AutoFit may not work reliably for merged cells.

Why does Wrap Text not change anything?
The text may already fit on one line because the column is wide, or the cell may be selected incorrectly. Narrow the column slightly and confirm that Wrap Text is enabled for the cell containing the text.

Does Wrap Text change the value in a cell?
No. It changes how the value is displayed, not the stored text or formula result. Use Alt+Enter on Windows or Option+Return on Mac when you need a deliberate line break within the cell.

Why is text cut off even though the row is tall enough?
Check the column width, neighboring cells, and merged-cell layout. A neighboring value can block overflow, while a narrow column can constrain what is visible. The formula bar can show whether the full value is still in the cell.

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.