Wrap Text in Excel: How It Works and How to Fix It

Errors & fixes · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, select the cell or cells, then choose Home > Alignment > Wrap Text; Excel displays long entries on multiple lines within the existing column width. The setting changes how content appears, not the text itself, and you can also add line breaks manually when you want to control where a line ends.

What wrapping text does

Normally, a cell displays its contents on one line. If the next cell is empty, text can appear to spill visually into that space; if the next cell contains something, the visible text is cut off at the cell boundary. Wrapping keeps the content within its own cell and places later words on additional lines. Excel increases the row height when it can so those lines are visible.

Wrapping is useful for long headings, descriptions, addresses, notes, and column labels. For example, a narrow column headed Delivery address can show the full heading across two or more lines instead of requiring a very wide column. The underlying value remains in one cell, so sorting, filtering, copying, and referencing it in formulas work as before.

Wrap Text can be applied to a single cell, a range, an entire row, or an entire column. If you select a range, the setting applies to every selected cell, including blank cells. Text returned by a formula can wrap too: wrapping affects how a cell displays its result, not whether the value was typed or calculated.

How to turn on Wrap Text

In the Windows desktop version of Microsoft 365, select the cells and use Home > Alignment > Wrap Text. The same button toggles wrapping on or off, so select a wrapped cell and click it again to return to a single-line display. The Windows ribbon shortcut is Alt+H, W; press the keys in sequence rather than all at once.

  1. Select the cell, range, row, or column you want to format.
  2. Open the Home tab and find the Alignment group.
  3. Choose Wrap Text. If the ribbon is collapsed, open the Home tab to reveal its controls.
  4. Adjust the column width or row height if the result is difficult to read.

In Excel for Mac, select the cells and use the Wrap Text control on the Home tab. You can also open Format Cells and choose the Alignment tab, then enable Wrap text. Excel for the web also provides Wrap Text on the Home tab; the Windows desktop keyboard shortcut may not work in a browser because the browser can reserve key combinations.

To apply the format to a whole column, click its letter heading before turning on wrapping. To format nonadjacent cells, hold Ctrl on Windows or Command on Mac while selecting them, then apply the setting. A cell’s wrapping choice is part of its formatting, so copying the cell with its formatting can copy that choice as well.

How column width and row height affect the result

Excel wraps text according to the available width inside the cell. A narrower column generally creates more lines and makes the row taller; a wider column generally creates fewer lines. The exact break depends on the words, spaces, font, font size, and other formatting. Excel may break a long word at a character boundary when there is not enough room to display it as a whole.

Rows usually expand automatically to show wrapped text. If the content is still partly hidden, the row might have a fixed height set earlier. Select the affected row or rows, then choose Home > Format > AutoFit Row Height. You can also drag the lower boundary of a row number to set a height yourself. A manually chosen height can clip content if it is too small, even when Wrap Text is enabled.

Column width can be adjusted by dragging the boundary between column headings. To let Excel estimate a width from the contents, select the column and choose Home > Format > AutoFit Column Width. That command can make a column wider than you want, however. For a compact report, set a deliberate width and let the row height grow instead.

One important exception is a cell that is part of a merged range. Excel may not automatically calculate the appropriate row height for wrapped text in merged cells. If a merged heading is clipped, increase the row height manually or consider unmerging the cells and using Center Across Selection for a similar centered appearance. Merged cells can also make sorting and selecting ranges less convenient.

Adding a line break exactly where you want one

Wrap Text lets Excel decide where lines break based on the cell width. To choose a specific break, edit the cell, place the insertion point where the next line should start, and insert a line break. On Windows desktop Excel, press Alt+Enter while editing the cell. On Mac, the line-break shortcut is Control+Option+Return. In Excel for the web, shortcut behavior can vary with the browser and operating system; use the available in-cell editing controls if the shortcut is intercepted.

A line break is part of the cell’s contents, so it remains at that position even if you widen the column. For example, a single cell could contain a person’s name, a line break, and a department name. This is different from automatic wrapping: automatic breaks can move as the column changes, while a manual break stays where inserted. Wrap Text may still be needed to display additional text beyond a manual break.

To add line breaks while building text with a formula, the formula must include a line-feed character, and the destination cell must have Wrap Text enabled for the break to display as a new line. This can be helpful for assembling a multi-line label, but for ordinary data entry the keyboard shortcut is often simpler. Keep in mind that line breaks can affect matching or cleanup if you later use the cell contents in other calculations.

Wrapping compared with other alignment options

Wrap Text is one of several ways to handle content that does not fit. The best choice depends on whether you want more lines, a wider column, smaller displayed text, or a particular visual orientation.

  • Wrap Text: Keeps the font size and column width while displaying the text on multiple lines. It often increases row height.
  • Shrink to fit: Reduces the displayed text size so it fits on one line. It can make a long entry difficult to read and does not create extra lines.
  • Widen the column: Preserves a one-line display if there is enough room, but uses more horizontal space across the worksheet.
  • Text orientation: Rotates or angles text, which may suit compact headings but is usually less comfortable for long sentences.
  • Merge cells: Combines a group of cells into a larger visual area, but can complicate sorting, copying, and automatic row sizing.

These settings are in the Alignment controls, including the Alignment tab in the Format Cells dialog. They solve different layout problems: wrapping is usually a practical choice for readable labels or notes, while shrink to fit is more appropriate when a single-line display is essential and the text is short enough to remain legible.

Common Wrap Text problems and fixes

If clicking Wrap Text seems to do nothing, check whether the cell has enough width for the whole entry. A wide column may leave the text on one line even though wrapping is on; narrow the column to see the line breaks. Also verify that you selected the cell containing the text and that the text is not in a neighboring cell.

  • Only part of the text is visible: Select the row and use Home > Format > AutoFit Row Height. Check for a fixed row height or a merged cell, either of which can prevent the expected display.
  • Words break at awkward places: Widen the column slightly, reduce unnecessary font size, or insert a manual line break at a more useful point. Long unbroken strings, such as codes or URLs, may not wrap like ordinary sentences.
  • The row is much taller than expected: Check for manual line breaks, narrow columns, large fonts, or extra paragraph spacing represented by blank lines. Widening the column can reduce the number of displayed lines.
  • Only some cells change: Confirm that the full intended range was selected. If the cells use different formatting, apply Wrap Text to the range again.
  • Text still appears hidden after changing width: Recheck the row height and merged-cell status. A fixed height may need to be reset or increased after the width changes.

It is also easy to mistake overflow for wrapping. With wrapping off, content can appear across empty neighboring cells without being stored in those cells. With wrapping on, the text stays visually inside its own cell and continues on another line. Clicking the cell and looking at the formula bar can help confirm that the complete value is present even if the grid display is clipped.

Keeping wrapped text readable when printing

Wrapped cells generally print with the same line breaks visible in the worksheet, but a printed page has its own width constraints. If a worksheet is scaled to fit on one page, Excel may shrink the whole sheet, including its text. Preview the page using File > Print before distributing it. If the text looks too small, consider changing page orientation, adjusting margins, widening columns selectively, or allowing the sheet to span multiple pages rather than shrinking it excessively.

For a clean printed table, check that each wrapped row has enough height and that headings are not split in an awkward place. Print preview can also reveal columns pushed onto a second page. Wrapping does not set page breaks or repeat headings by itself; those are separate print-layout choices.

Frequently Asked Questions

Does Wrap Text change the contents of a cell?
No. It changes the cell’s display and may increase the row height, but it does not rewrite or divide the stored value. Use a manual line break only when you want a line break to become part of the cell contents.

Why is wrapped text cut off in Excel?
The row may have a fixed height, or the text may be in a merged cell that does not autofit reliably. Try Home > Format > AutoFit Row Height, then increase the row height manually if needed.

Can I wrap text in multiple cells at once?
Yes. Select a range, whole row, or whole column, then choose Home > Alignment > Wrap Text. The setting applies to every selected cell.

How do I make a new line inside an Excel cell?
Edit the cell and press Alt+Enter on Windows, or Control+Option+Return on Mac, at the point where the new line should begin. Enable Wrap Text if the full multi-line entry does not display.

Does wrapping work with formulas?
Yes. If a formula returns text, the cell can display that result on multiple lines when Wrap Text is enabled. A line break returned within the text may also require wrapping to be visible as a new line.

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.