Excel Not Wrapping Text? Fix the Cell

Errors & fixes · Updated November 18, 2026

If Excel is not wrapping text, select the affected cell or cells and choose Home > Wrap Text. If the text still appears cut off, check the column width and row height, and look for merged cells or formatting that prevents the row from expanding.

What Wrap Text does in Excel

Wrap Text displays a cell’s contents on multiple lines within the existing column width. It changes how the cell is displayed; it does not insert line breaks into the underlying text, widen the column, or change the cell’s value. For example, a long product description can remain one continuous string in the formula bar while appearing on three lines in the worksheet.

Excel normally lets text overflow into the next cell when that neighboring cell is empty. If the neighboring cell contains anything, even a space, the overflow is hidden at the cell boundary. Wrap Text keeps the contents inside the original cell instead, which is often useful for headings, notes, and descriptions. Numbers, dates, and times generally do not overflow like text: if a numeric value does not fit, Excel may show number signs (####) instead. Wrapping is not the fix for that display.

Turning on wrapping can make a row taller so that more lines are visible. The column stays the same width, and other cells in that row share the increased row height. The exact number of visible lines depends on the column width, font, font size, and the length and composition of the text.

Turn on Wrap Text

In Excel for Microsoft 365 on Windows, select one cell or a range, then go to Home > Wrap Text in the Alignment group. The control is a toggle: selecting it again turns wrapping off. You can select a whole column by clicking its letter, or select the entire worksheet with the button at the intersection of the row numbers and column letters before applying the setting.

You can also open the full cell-formatting dialog. Select the cells, press Ctrl+1, open the Alignment tab, check Wrap text, and select OK. On a Mac, use Command+1 to open Format Cells; the Wrap Text control is also available on the Home tab. In Excel for the web, select the cells and use Home > Wrap Text.

If only some entries in a column need wrapping, apply the setting to those cells rather than the entire column. This avoids making every row taller when other cells contain short values. To check whether wrapping is enabled, select a cell and look for the active Wrap Text control on the Home tab, or inspect the Alignment tab in Format Cells.

Check column width and row height

A narrow column creates more wrapped lines; a wide column creates fewer. If a cell appears to show only one line, the row may have a fixed height that is too small to display the additional lines. This can happen after someone manually resizes the row, or when a workbook uses carefully controlled row heights for printing or layout.

To let Excel recalculate the height, select the affected row or rows and choose Home > Format > AutoFit Row Height. You can also move the pointer to the lower boundary of a row number and double-click it to AutoFit that row. To AutoFit several rows, select them first. Excel adjusts the height based on the contents and formatting it can display.

If AutoFit makes the row too tall or does not give the layout you want, set a height manually: select the row, choose Home > Format > Row Height, and enter a value. A manual height can intentionally show only part of the wrapped text, so increase it if lines are clipped. Changing the column width may also be a better choice when the sheet has become crowded with tall rows.

Common reasons wrapped text still looks cut off

When the Wrap Text button is on but the cell is not displaying all its lines, inspect the surrounding layout before reapplying the setting. These are common causes:

  • The row has a fixed height. AutoFit Row Height or a larger manual height can reveal hidden lines.
  • The cell is merged with other cells. Excel does not reliably AutoFit row height for merged cells. A manual row height may be needed.
  • The column is wider than expected. A wide column may leave the text on one line, which is wrapping behavior even if it is not visually obvious.
  • The content is not ordinary text. A narrow cell containing a number or date may display ####; widen the column or change the number format instead.
  • The cell contains a line break or unusual spacing. Existing breaks, nonbreaking spaces, or long strings without spaces can affect where text can wrap.
  • The selected cells are not the cells you are viewing. Check the active selection and confirm that the setting was applied to the correct worksheet and range.

Also check whether the row is hidden or filtered out, or whether the font is unusually large. Zoom changes how the worksheet appears on screen but does not change the cell’s actual formatting. If the text is visible in the formula bar but not in the grid, that points to a display or sizing issue rather than missing cell content.

Merged cells and other layout complications

Merged cells are a frequent source of confusion. When several cells are merged, the content is displayed in the combined area, but Excel may not calculate an appropriate row height automatically. The result can be a wrapped heading with its lower lines hidden even after AutoFit. If you need to keep the merge, set the row height manually and check the result at the worksheet’s normal zoom.

For tables and reports, consider avoiding merged cells where possible. If the goal is to center a heading across several columns, the Center Across Selection horizontal alignment option in Format Cells can often create a similar appearance without merging the cells. This keeps the cells separate, which can make sorting, filtering, selecting, and adjusting row heights easier. It is not a universal replacement: check the layout and workbook requirements before changing a design.

Text can also appear clipped if the row height is fixed while the font size or column width changes. After adjusting either, AutoFit the row again or set a suitable height. If a worksheet is intended for printing, inspect Print Preview too; page scaling and page breaks can change the printed appearance even when the worksheet grid looks correct.

Use manual line breaks when you need exact lines

Wrap Text chooses line breaks based on the available width. If you want a label to break at a particular point, insert a manual line break within the cell. In Excel for Windows, edit the cell, place the cursor where the new line should begin, and press Alt+Enter. On a Mac, the shortcut is generally Control+Option+Return. The exact key combination can depend on the keyboard and Excel version.

For example, a cell containing “North Region Sales” can be split after “Region” so that “North Region” appears on the first line and “Sales” on the second. Wrap Text can remain on, and the manual break stays at the chosen point while the remaining text wraps as needed. If the break is inserted but the second line is not visible, increase the row height or use AutoFit where it is supported.

Manual breaks are useful for short headings and labels, but they are less convenient for large sets of changing descriptions. If text is edited later, a hand-placed break may leave an awkward line length. For ordinary paragraphs in cells, automatic wrapping is usually easier to maintain.

Alternatives: widen, shrink, or align

Wrapping is not always the best way to fit content. Choose the display method that suits the worksheet:

  • Widen the column when readability matters more than keeping the sheet compact. Double-click the right boundary of the column letter to AutoFit its width to the contents, or drag the boundary to a chosen width.
  • Use Shrink to Fit when a short value must remain on one line in a fixed-width cell. Open Format Cells, choose Alignment, and select Shrink to fit. Excel reduces the displayed font size as needed; it does not change the underlying font-size setting.
  • Use Wrap Text for longer content that should remain readable at a consistent font size, especially when each row can grow.
  • Use a manual line break when a particular short heading should split at a deliberate point.

Shrink to Fit can make a long sentence very small, so it is usually less readable than wrapping. Conversely, wrapping every cell in a dense data table can make the worksheet difficult to scan because row heights vary. For many datasets, concise column headings and a suitable column width provide a better balance.

A quick troubleshooting sequence

If the setting seems ineffective, work through the checks in order. This helps distinguish a formatting problem from a content or layout issue:

  1. Select the cell and confirm that Home > Wrap Text is enabled.
  2. Check whether the cell contains text, a number, or a date. If it shows ####, widen the column.
  3. Look at the row boundary. Use Home > Format > AutoFit Row Height, unless the cell is merged.
  4. Check for merged cells and, if necessary, set the row height manually.
  5. Review the column width, font size, and any manual line breaks.
  6. Test the result at normal zoom and in Print Preview if the sheet is being printed.

If the problem affects many cells, select the full relevant range before changing alignment. Be cautious about selecting the whole sheet: applying wrapping everywhere can substantially increase row heights and make a workbook harder to navigate. You can use Undo immediately if a formatting change has an unwanted effect, or reopen Format Cells to restore the alignment options you need.

Frequently Asked Questions

Why is Excel showing only part of my wrapped text?
A fixed row height is the most common reason. Select the row and choose Home > Format > AutoFit Row Height. If the cell is merged, AutoFit may not work properly, so increase the row height manually.

Does Wrap Text make a column wider?
No. It keeps the column width and displays the content on additional lines by increasing the row height when possible. To give each line more room, widen the column.

Why does Excel show #### instead of wrapping?
Excel commonly shows number signs when a numeric value, date, or time cannot fit in the column. Widen the column or choose a more compact number format; Wrap Text is intended for displaying text on multiple lines.

Can I wrap text in a merged cell?
Yes, but Excel may not AutoFit the row height correctly for merged cells. Turn on Wrap Text and adjust the row height manually if lines are hidden.

How do I start a new line inside an Excel cell?
Edit the cell and use Alt+Enter on Windows, or generally Control+Option+Return on Mac, at the point where the line should break. Increase the row height if the new line is not visible.

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.