How to Enable Word Wrap in Excel and Adjust Cell Text

How-to basics · Updated November 20, 2026

To enable word wrap in Excel, select the cell or cells, then choose Home > Wrap Text. Excel keeps the column width and displays long cell contents on multiple lines, usually increasing the row height so the text is visible. You can use this in Excel for Microsoft 365 on Windows, Mac, and the web; the ribbon layout may vary slightly by platform.

What You’ll Need

  • An Excel workbook with text or a formula result in one or more cells.
  • Permission to edit the worksheet. If the sheet is protected, you may need the password or access from its owner before changing formatting.
  • A rough idea of which cells should wrap. You can select a single cell, a range, an entire column, or several non-adjacent cells.

You do not need an add-in or a special file type. Wrap Text is ordinary cell formatting, so it can be applied to existing entries and to blank cells before you enter text. The instructions below are for Microsoft Excel for Microsoft 365 on Windows, with Mac and web notes where the controls differ.

Step-by-Step

  1. Open the worksheet and select the cells. Click a cell that contains the text you want to wrap. To apply the setting to a range, click and drag across the cells, or click the first cell, hold Shift, and click the last cell. To select a whole column, click its letter at the top. For non-adjacent cells in Windows, hold Ctrl while selecting each one; on a Mac, hold Command. Selecting the relevant cells first prevents you from changing unrelated parts of the worksheet.
  2. Open the Home tab. On Windows, click Home on the ribbon if it is not already open. Find the Alignment group, which contains controls for horizontal and vertical alignment, text orientation, and indentation. In Excel for Mac, use the Home tab and look for Wrap Text in the alignment controls. In Excel for the web, the same command is on the Home tab; a compact window may hide some ribbon controls, so expand the ribbon or look in the Alignment group.
  3. Turn on Wrap Text. Click Wrap Text once. Excel breaks the displayed text into additional lines at the cell’s right edge, based on the available column width. The cell’s underlying value does not change: wrapping affects how the value is shown, not the words, numbers, or formula stored in the cell. If the column is wide enough for the whole entry, it may remain on one line, which is normal.
  4. Check the row height. Excel often expands the row automatically to show the wrapped lines. If you can see only part of the text, move the pointer to the boundary below the row number and double-click to AutoFit that row. You can also select the affected row or rows and choose Home > Format > AutoFit Row Height. AutoFit changes row height, not column width, so the text continues to wrap at the current column width.
  5. Adjust the column width if needed. A very narrow column can create many short lines and make a row unusually tall. Drag the boundary between column letters to widen or narrow the column, or double-click that boundary to AutoFit the column to its contents. If you AutoFit a column, it may become wide enough that some text no longer needs to wrap. Choose a width that balances readable lines with the space available on the worksheet.
  6. Apply the format to other cells when appropriate. Select another range and click Wrap Text to apply the same display setting there. You can select an entire worksheet by clicking the triangle at the top-left corner between the row numbers and column letters, then turn on wrapping. Use whole-sheet formatting cautiously: it can increase the height of many rows and make the workbook harder to scan. To reuse formatting selectively, use Format Painter on the Home tab, then click or drag over the destination cells.
  7. Save and review the result. Save the workbook, then check a few entries, including the longest one. Confirm that all lines are visible and that the extra row height has not made nearby data difficult to follow. If the text is still cut off, work through the troubleshooting section below; row height, merged cells, and the selected range are frequent causes.

On Windows, you can also use the ribbon KeyTip sequence Alt, H, W to toggle Wrap Text for the selected cells in the English-language desktop ribbon. Press the keys in sequence rather than as one simultaneous shortcut. The sequence can vary with language or ribbon configuration. There is no single equivalent shortcut that works consistently across every Mac and web setup, so use the visible Wrap Text button on those platforms.

Common Mistakes

  • Expecting the column to get wider. Wrap Text generally keeps the column width and adds lines vertically. If the layout looks too cramped, widen the column manually or consider whether the content belongs in a wider field.
  • Assuming the row always resizes correctly. Excel usually adjusts row height, but a manually fixed height can leave lines hidden. AutoFit Row Height or a manual row-height adjustment can resolve this.
  • Formatting the wrong range. The command affects the current selection. If only one cell was selected, neighboring cells will not automatically wrap. Check the selection before clicking the button, especially when formatting a table or a large range.
  • Confusing wrapping with a manual line break. Wrap Text lets Excel decide where lines break according to the cell width. It does not insert line-break characters into the value. For a deliberate break at a particular point, edit the cell and insert a line break instead: on Windows, press Alt+Enter while editing; on Mac, the key combination can depend on the Excel version and keyboard, so use the Mac Excel command for inserting a line break if available in your setup.
  • Using merged cells and expecting AutoFit to behave normally. AutoFit may not calculate the needed row height correctly for merged cells. This is a limitation of how Excel sizes merged areas. If possible, unmerge the cells, or set the row height manually after turning on wrapping.
  • Thinking the text itself has been edited. Turning wrapping on changes formatting only. It does not remove spaces, shorten a description, or alter a formula result. If the underlying entry is too long for the intended layout, edit the content separately.

Tips

  • Use wrapping for labels and descriptions. Long product names, notes, addresses, and headings often fit better in a fixed-width column when displayed on multiple lines. This can be easier to read than a very wide column that pushes other fields off screen.
  • Set wrapping before entering repeated text. If you know a column will contain lengthy descriptions, select it and enable Wrap Text first. New entries in those cells will use the setting, reducing the need to format each row later.
  • Combine wrapping with alignment. In the Home tab’s Alignment group, use vertical alignment controls to position wrapped text at the top, middle, or bottom of a cell. Top alignment is often useful in rows with different amounts of text because it makes the first line start at a consistent place.
  • Keep a consistent width for related fields. A stable column width makes wrapped rows easier to scan. If one column becomes too narrow, its rows can grow much taller than neighboring rows, disrupting the visual rhythm of a table.
  • Use a manual line break only when the break matters. For example, a department name and its location might be easier to read on separate lines even when the column is wide. A manual break stays at the chosen point; ordinary wrapping changes as the column width changes.
  • Check worksheet and print views separately. A row that looks readable on screen may occupy a lot of space when printed. Use Print Preview to check page breaks and page count, and adjust column widths, margins, or print scaling if needed. Scaling the sheet can make text smaller, so inspect the final print size.
  • Remember that formulas can wrap too. If a formula returns a long text string, selecting its cell and turning on Wrap Text changes the display just as it does for typed text. The formula remains intact in the formula bar.

Troubleshooting

The words still appear on one line. First check whether Wrap Text is on for the cell: select it and look for the active state of the button on the Home tab. If it is enabled but the text still fits in the column, Excel has no reason to display another line. Narrow the column slightly to see the wrap, or leave it as-is if the single line is readable.

Only the top line is visible, or the bottom is cut off. The row may have a fixed height. Select the row and use Home > Format > AutoFit Row Height, or drag the row boundary downward. If the cell is merged, AutoFit may not work as expected; try unmerging it or set a suitable row height manually. Also check that the text is not hidden by a filter, outline, or a collapsed row.

Wrap Text is unavailable or changes nothing. Confirm that you are editing a worksheet rather than viewing a read-only preview, and that the sheet is not protected against formatting changes. If the workbook is in a restricted or shared editing state, ask its owner about permissions. In Excel for the web, expand the ribbon if the control is not visible, and make sure the target cell or range is selected.

Some cells wrap and others do not. Different cells can have different formatting even in the same column. Select the entire intended range and click Wrap Text to apply it uniformly. Also check whether some rows have manually set heights, or whether some cells are merged while others are not. A text value that is shorter than the available width will naturally remain on one line even when wrapping is enabled.

Rows become too tall after wrapping. Widen the column, shorten or edit unusually long entries, or use a manual line break only where a deliberate split improves readability. You can also review whether the whole column needs wrapping or only selected cells do. Avoid setting every row to a large fixed height unless the worksheet genuinely requires it, since that can waste space and still fail to show especially long entries.

The result changes after changing the column width. That is expected: automatic line breaks depend on the available width. Widening the column may reduce the number of lines; narrowing it may increase them and make rows taller. After resizing columns, use AutoFit Row Height on affected rows if Excel does not update their height as expected.

Frequently Asked Questions

Does Wrap Text change the contents of a cell?
No. It changes only the display format. The cell still contains the same text, number, or formula, and you can see or edit the full value in the formula bar.

Can I wrap text in an entire column?
Yes. Click the column letter to select the column, then choose Home > Wrap Text. Consider applying it only to the used portion if wrapping every cell would make the worksheet unnecessarily tall.

How do I turn word wrap off?
Select the wrapped cells and click Home > Wrap Text again. The button toggles the setting. The text may then display on one line or be clipped, depending on the column width and the contents of neighboring cells.

Is Wrap Text the same as Shrink to Fit?
No. Wrap Text puts content on multiple lines and may increase row height. Shrink to Fit reduces the displayed font size to fit the content on one line within the cell. You can find Shrink to Fit in the Alignment options of the Format Cells dialog, but it can make long text difficult to read.

Does word wrap work in Excel for Mac and Excel for the web?
Yes. Select the cells and use Home > Wrap Text in both. Ribbon placement can vary with window size and version. Row-height and merged-cell behavior may also require manual adjustment, so check that the full text is visible on your platform.

Why does AutoFit Row Height not work for my wrapped text?
A manually set row height or merged cells can prevent the expected automatic sizing. Try selecting the row and choosing Home > Format > AutoFit Row Height. If the cell is merged and the row still does not expand, adjust the height manually or redesign the layout without merged cells.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.