How to Fix Wrap Text in Excel: Quick Steps and Tips

Errors & fixes · Updated November 3, 2026

How to Fix Wrap Text in Excel: Quick Steps and Tips

To fix Wrap Text in Excel, select the affected cells, then choose Home > Wrap Text. If the words still look cut off, adjust the column width or use Home > Format > AutoFit Row Height. Wrap Text displays long cell entries on multiple lines within the same cell; it does not change the text itself or automatically widen the column. Before making changes, save your workbook if it contains important formatting.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows.
  • Permission to edit the sheet. If the sheet is protected, you may need its password or help from the workbook owner.
  • A few seconds to check the selected cell, its row height, and its column width. No add-ins or formulas are required.

Step-by-Step

  1. Select the cells that need fixing. Click one cell to change only that cell, or drag across a range to select several cells. To apply wrapping throughout a worksheet, click the small triangle at the top-left corner between the row numbers and column letters, then turn on Wrap Text. You can also select a whole column by clicking its letter or a whole row by clicking its number. Check the selection before changing formatting so you do not affect unrelated cells.
  2. Turn on Wrap Text from the Home tab. Open Home and, in the Alignment group, click Wrap Text. Excel should display the cell’s contents on multiple lines as needed. The button may look highlighted when the active cell has wrapping enabled. If you are working with a narrow cell, the wrapped lines will be stacked vertically within the existing column width; Excel generally increases the row height to show them.
  3. Check the result at normal zoom. Click another cell or press Enter to leave the selection, then inspect the text. A selected cell can make its edges harder to judge, and a very small zoom level can make line breaks appear confusing. Remember that Wrap Text changes how the entry is displayed, not the underlying value. Click the cell and look at the formula bar if you need to confirm the complete text is still present.
  4. AutoFit the row height if any lines are hidden. Select the affected row or rows, then choose Home > Format > AutoFit Row Height. You can also move the pointer to the boundary below a row number and double-click it to AutoFit that row. Excel adjusts the height to fit the visible wrapped lines. If multiple rows need adjustment, select them together before using AutoFit Row Height.
  5. Adjust the column width if the wrapping is too dense. Drag the boundary between column letters to make the column wider or narrower. A wider column usually means fewer wrapped lines; a narrower column usually means more. To fit a column to its longest entry, select the column and choose Home > Format > AutoFit Column Width, or double-click the boundary to the right of its letter. AutoFit can make a column much wider than you want, so dragging to a practical width may be better for a report.
  6. Review alignment settings. With the cells selected, open the Alignment group on Home and check the horizontal and vertical alignment controls. Choose Top Align if you want wrapped text to start at the top of a tall row, or Middle Align if it should sit in the center. Also check that the text is not rotated or indented in a way that makes it seem clipped. These options affect placement, while Wrap Text controls line breaks.
  7. Clear conflicting formatting only if needed. If the cell still behaves unexpectedly, select it and open the Format Cells dialog with Ctrl+1. On the Alignment tab, verify that Wrap text is checked and review Shrink to fit and Merge cells. These settings can change the result: Shrink to fit reduces text size to fit a cell, while merged cells can interfere with automatic row sizing. Change only the setting you have identified as the cause.
  8. Test the layout with a longer entry. If you are setting up a form or table, try a realistic long value in a blank test cell or undo your test after checking the layout. Confirm that the full entry is visible at the intended column width and row height. Save the workbook once the display is correct. If you use Excel for Mac, the Wrap Text control is also on the Home tab; some ribbon labels or dialog layouts may differ slightly. Excel for the web also has a Wrap Text control on Home, though menu placement can vary with the window width.

Common Mistakes

Expecting Wrap Text to widen a column. The feature keeps the existing column width and uses additional lines instead. If the cell becomes much taller than expected, increase the column width a little or set a deliberate width for a more balanced layout.

Changing row height without checking the cause. A fixed row height can hide wrapped lines, but AutoFit may not solve every situation. Merged cells are a common complication because Excel does not reliably AutoFit row height for merged ranges. Consider unmerging the cells, using Center Across Selection for a similar heading appearance, or setting the row height manually.

Confusing Wrap Text with manual line breaks. Wrap Text lets Excel choose where lines break based on the cell width. A manual break forces a new line at a particular point. Adding manual breaks does not replace setting a suitable row height or column width.

Applying formatting to the wrong range. Clicking the worksheet corner selects the entire sheet, so changes can affect existing layouts and empty cells. Select only the relevant rows, columns, or cells unless you truly want wrapping applied everywhere.

Assuming the text has been deleted. A cell may show only part of its contents because its row is too short or its column is narrow. Check the formula bar before editing or retyping. This helps prevent accidental replacement of a complete entry.

Tips

Set column widths before finalizing row heights. When the width changes, Excel may create a different number of wrapped lines, so a height that looked right before can become too small afterward. For a table, select the relevant rows and AutoFit them again after adjusting the columns.

Use Wrap Text for paragraphs, notes, addresses, and descriptive labels that should remain inside a cell. For a heading that needs a specific break regardless of the column width, edit the cell, place the cursor where the line should split, and press Alt+Enter on Windows. On Excel for Mac, use Control+Option+Return to insert a line break. The row may still need AutoFit.

For consistent tables, use a readable column width and apply wrapping to the whole data range rather than fixing cells one at a time. You can select the range and use the same Home > Wrap Text control. If the sheet is used for printing, check Print Preview as well: scaling a worksheet to fit a page can make text look smaller even though wrapping is working.

Keep row heights uniform when a clean grid matters more than showing every line immediately. In that case, choose a suitable fixed height and allow users to click a cell to read the full entry in the formula bar. For shared workbooks, consider adding a note or instruction that longer text may require selecting the cell to view all of it.

Troubleshooting

Wrap Text appears enabled, but text remains on one line. Check whether the entry is short enough to fit at the current column width. Excel has no reason to wrap text that already fits. Narrow the column slightly to verify the behavior, then restore a width that works for the sheet.

Only part of the wrapped text is visible. Select the row and use Home > Format > AutoFit Row Height. If that does not help, inspect the row height by dragging its lower boundary, and check for merged cells. For a merged range, unmerge it temporarily to test whether the merge is blocking AutoFit; if the layout depends on the merge, set an adequate row height manually.

The row height will not change. Check whether the worksheet is protected, whether the row has a manually set height, and whether cells in the row are merged. If protection is on, use Review > Unprotect Sheet if you have permission. Then select the row and try AutoFit again. If you cannot unprotect the sheet, ask its owner to change the formatting.

The button is unavailable or changes do not stick. Confirm that the workbook is open in an editable state and that the sheet is not protected. If several cells are selected, see whether the selection includes a merged range or a table with special formatting. Test one ordinary cell in an unprotected area to distinguish a cell-specific issue from a worksheet-wide restriction.

Text looks tiny instead of wrapping. Open Format Cells with Ctrl+1, choose Alignment, and see whether Shrink to fit is selected. Turn it off if you want text to wrap rather than shrink. Also check for reduced zoom or print scaling before changing font size; those can make text look smaller on screen or on paper without changing the cell’s actual font.

Frequently Asked Questions

Where is Wrap Text in Excel?
In Excel for Microsoft 365 on Windows, select the cells and choose Home > Wrap Text in the Alignment group. The command is also available through the Format Cells dialog on its Alignment tab.

Why does Wrap Text not automatically make the row taller?
A fixed row height, merged cells, or sheet protection can prevent the expected adjustment. Select the row and choose Home > Format > AutoFit Row Height. If the cells are merged, set the height manually or reconsider the merge.

Does Wrap Text change the cell value?
No. It changes the display, not the stored text or number. The complete content remains in the cell and can be checked in the formula bar.

How do I put a line break in a specific place?
Edit the cell, place the cursor at the desired position, and press Alt+Enter on Windows. On Mac, press Control+Option+Return. This inserts a manual line break; turn on Wrap Text and make sure the row is tall enough to show the lines.

Can I wrap text in Excel for the web?
Yes. Select the cells and use the Wrap Text command on the Home tab. If the text is cut off, adjust the row height or column width; some formatting controls may appear in a different place depending on the browser window size.

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.