Excel Cell Word Wrap: How to Turn It On and Fix Rows

To wrap text in Excel, select the cell or cells, then choose Home > Wrap Text. Excel for Microsoft 365 on Windows will display long entries on multiple lines inside the existing column, usually increasing the row height so the text is visible.

What word wrap does in Excel

Word wrap changes how text is displayed in a cell; it does not change the cell’s value. If a cell contains a long note, Excel breaks the displayed text across lines at the column’s width rather than letting the text run into neighboring empty cells or disappear behind occupied cells. The full entry remains in one cell and can still be selected, copied, searched, or used in formulas as usual.

For example, a narrow column containing the sentence Please review the revised delivery schedule before Friday may show that sentence on several lines when wrapping is on. Widening the column may reduce the number of lines, while narrowing it may create more. The underlying text stays the same in either case.

Wrapping is useful for headings, addresses, comments, and descriptive fields where you want to preserve the column layout. It is not the same as inserting a line break into the cell’s contents: wrap points are calculated from the cell width and can move when the column is resized, while a manually inserted break stays at a specific point.

How to turn Wrap Text on or off

On Windows, select one or more cells, then go to Home > Alignment > Wrap Text. The command is a toggle: selecting the same cells and choosing Wrap Text again turns wrapping off. You can also select a whole column or row first if you want the setting applied to its cells, including cells you fill in later.

For a single cell: Click the cell and choose Home > Wrap Text.
For a range: Drag across the cells or click the first cell, hold Shift, and click the last; then choose Wrap Text.
For an entire column: Click its column letter, then choose Wrap Text. Use this selectively because every cell in the column inherits the display setting.
With the keyboard on Windows: Press Alt, then H, then W. These are sequential ribbon Key Tips, not keys to press simultaneously.

In Excel for Mac, select the cells and use Home > Wrap Text on the ribbon. Excel for the web also provides Wrap Text on the Home tab. Ribbon placement can vary slightly with window size or a simplified ribbon, so look in the Alignment group if the command is not immediately visible. There is no single Windows-style Alt, H, W sequence to rely on across Mac and web.

To use the cell-formatting dialog instead, select the cells and open Format Cells, then choose the Alignment tab and select Wrap text. On Windows, Ctrl+1 opens Format Cells; on Mac, Command+1 is the corresponding shortcut in many Excel versions. The dialog is handy when you are already adjusting alignment, orientation, or indentation at the same time.

How wrapping affects column width and row height

Excel uses the column width to decide where displayed lines break. When wrapping is enabled, a narrow column generally produces more lines, and a wider column produces fewer. Excel then needs enough row height to show those lines. It commonly expands a row automatically when wrapped text is entered or when a column is resized, but the result depends on the row’s formatting and contents.

If part of the wrapped text is hidden, select the affected row or rows and choose Home > Format > AutoFit Row Height. You can also point to the boundary below a row number and double-click it to AutoFit that row. To fit several rows, select them first. If you prefer a consistent height, drag the row boundary or use Home > Format > Row Height and enter a value; however, a fixed height can clip wrapped text that needs more space.

Column width is adjustable in a similar way. Drag the boundary between column letters to change the width, or use Home > Format > Column Width to enter a value. Double-clicking a column boundary applies AutoFit Column Width based on the contents. Be aware that a long entry can make the column very wide, which may be undesirable in a report; wrapping is often a better choice when the sheet needs consistent, readable columns.

For example, if a row contains a two-line heading in a narrow column, increasing that column’s width might reduce the heading to one line and lower the row height. If the row has a manually set height, however, Excel may leave it unchanged and show only part of the text. After changing widths or wrap settings, AutoFit Row Height is a useful way to restore visibility.

Use manual line breaks when a specific break matters

Wrap Text lets Excel choose break locations. If you want a label to break at a particular phrase regardless of the column width, insert a line break within the cell. In Excel for Windows, edit the cell, place the insertion point where the next line should begin, and press Alt+Enter. For instance, a department name and location can be placed on separate lines inside one cell.

A manual break is part of the cell’s text, so it remains at that point even if the column becomes wider. The rest of the text can still wrap naturally if it does not fit on a line. This makes manual breaks useful for carefully arranged labels, but they can create awkward spacing after later edits or when the same value is displayed at different widths. For ordinary notes and changing data, automatic wrapping is usually easier to maintain.

On Mac, the shortcut for inserting a line break can depend on the keyboard and Excel version; Control+Option+Return is commonly used. If that combination does not work, edit the cell and check the Excel keyboard-shortcut guidance for the current Mac version. A line break changes the cell content, unlike simply turning Wrap Text on.

Common reasons wrapped text still looks clipped

Wrap Text can be enabled even when the entire entry is not visible. The setting controls line layout, but the row still needs sufficient height. Check these common causes before re-entering or deleting text:

The row height is fixed or too small. Use Home > Format > AutoFit Row Height, or increase the height manually.
The cell is merged with neighboring cells. Merged cells can wrap, but Excel may not calculate an appropriate automatic row height for them. Increase the row height manually, or consider unmerging the cells and using alignment options instead.
The column is very narrow. A narrow column can create many lines and make the row unusually tall. Widen it or shorten the display text if that better suits the sheet.
The cell contains a manual line break. The break may create an extra line even after the column is widened. Edit the cell to remove or reposition it if it is no longer wanted.
Another cell or object affects the layout. Review nearby merged cells, row sizing, and the selected range; make sure the wrap command was applied to the cells containing the text.

Also distinguish clipping from overflow. With wrapping off, text may visibly extend into an adjacent empty cell; if that neighboring cell contains something, the extra text is usually hidden from view. With wrapping on, Excel keeps the display within the cell’s column and uses additional lines instead. In either case, click the cell and inspect the formula bar to see the complete stored value.

Wrap Text compared with Shrink to Fit and Merge

Wrap Text is one of several alignment choices, and the alternatives solve different layout problems. In Format Cells > Alignment, Excel also offers Shrink to fit. That option reduces the displayed font size enough to fit the entry on one line within the cell. It can be useful for a short heading in a fixed-width column, but very long text may become difficult to read. It does not create additional lines.

Merging combines selected cells into one larger cell, which can make a report title span several columns. It is different from wrapping: merge changes the grid structure and can complicate sorting, filtering, selecting ranges, and automatic row sizing. For tabular data, it is often better to keep cells unmerged and use Wrap Text with suitable alignment. If the goal is to center a heading across columns without merging, Center Across Selection in the horizontal-alignment options may be an alternative, depending on the layout.

Choose based on the constraint. Use wrapping when the font should remain readable and the row may grow; use Shrink to fit when a one-line display is essential and slight font reduction is acceptable; use merging for a deliberate multi-column heading rather than routine data cells. These settings can also interact, so inspect the result after applying more than one alignment option.

Printing and readability considerations

Wrapped text affects worksheet layout, so check print preview before sharing a report. Taller rows can push later content onto another printed page, while a narrow print scaling setting may shrink the entire worksheet and make text hard to read. Use File > Print to review the pages, and adjust column widths, row heights, page orientation, or print area if the output is crowded. Do not assume that a worksheet’s on-screen fit guarantees a good printed result.

Wrapping can improve readability by keeping a descriptive entry beside its related data, but excessive wrapping creates tall rows that are harder to scan. A practical design often uses concise column headings, moderate widths, and wrapping only for fields whose full contents need to remain visible. Keep text alignment consistent and leave enough row height for the longest expected entry. For data that is only occasionally needed, a shorter cell display paired with the full value in a comment or another field may be more suitable.

Frequently Asked Questions

Why is Wrap Text not working in Excel? Confirm that the correct cells are selected and that Home > Wrap Text is enabled. If the text is still clipped, the row may have a fixed or insufficient height; try Home > Format > AutoFit Row Height. Merged cells can also prevent row height from adjusting as expected.

How do I make Excel automatically fit row height? Select the relevant rows, then choose Home > Format > AutoFit Row Height. You can also double-click the boundary below a row number. AutoFit may not size merged cells reliably, so those rows might need manual adjustment.

Does wrapping change the text in a cell? No. Wrap Text changes the display, not the stored value. To see the full value, select the cell and look in the formula bar. A manually inserted line break is different because it is included in the cell’s contents.

Can I wrap text in Excel without making the row taller? You can set a fixed row height, but Excel may then clip some lines. Shrink to fit can keep text on one line by reducing its displayed size, while a wider column may reduce the number of wrapped lines. Each choice has a different effect on readability.

How do I remove word wrapping? Select the wrapped cells and choose Home > Wrap Text again to turn the toggle off. If the row remains tall afterward, use AutoFit Row Height or set a smaller height; turning wrapping off does not always restore the previous row dimensions.

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.