Wrap Text in Excel: Keep Long Cell Entries Visible

To keep text wrapped in Excel, select the cell or range, then choose Home > Alignment > Wrap Text. The setting stays with those cells when you edit their contents, but row height, merged cells, or pasted formatting can make wrapped text look as if it has stopped working. Adjust the row height and preserve the cell formatting to keep every line visible.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows. The main steps are similar in Excel for Mac and Excel for the web, though some shortcuts and ribbon details differ.
Permission to edit the cells. If the worksheet is protected, you may need the sheet password or an unlocked area to change formatting.

Step-by-Step

Select the cells that should retain wrapping. Click one cell to wrap that entry, drag across a range to select several cells, or click a column letter to select the whole column. If only one column contains long descriptions, selecting that column is usually safer than applying wrapping to the entire worksheet. You can also select nonadjacent cells by holding Ctrl while clicking each one on Windows; on Mac, hold Command.
Turn on Wrap Text. On the Home tab, find the Alignment group and click Wrap Text. In Excel for Microsoft 365 on Windows, the path is Home > Alignment > Wrap Text. When it is active, text breaks onto additional lines inside the cell instead of continuing across empty cells or disappearing behind content in the next cell. The cell’s value is unchanged; this is a display and formatting option, not a change to the text itself.
Give the column a useful width. Wrapping depends on the available width. Drag the boundary between column letters to widen or narrow the column, or double-click that boundary to AutoFit the column to its contents. AutoFit can make a column very wide if it contains a long entry, so for a report or printable sheet it is often better to set a practical width yourself and let the text occupy multiple lines. Check the result with the longest entry, not just the first row.
Adjust the row height so all lines show. Excel often expands a row automatically after Wrap Text is turned on, but it may not do so in every layout. Select the affected row or rows, then choose Home > Cells > Format > AutoFit Row Height. You can also move the pointer to the boundary below a row number and double-click it. To set a fixed height instead, use Home > Cells > Format > Row Height and enter a value; a fixed height can cut off lines if it is too small.
Check that the formatting remains on the cells. Click a wrapped cell and look at Home > Alignment > Wrap Text. If the button is not active, select the intended cells and click it again. Editing a cell’s text normally leaves the setting in place. If you replace a cell by pasting from another source, however, the pasted formatting may replace the existing setting. When you need to keep the destination’s formatting, use Paste Special and choose Values, or use the paste option that keeps destination formatting, rather than pasting all source formatting.
Apply the format to new or replacement entries. If you add records below an existing range, select the new cells and enable Wrap Text, or copy a correctly formatted cell and paste its formatting onto the new cells. To copy only formatting, use Home > Clipboard > Format Painter, then select the destination cells. Verify the new row height afterward, because copying the wrap setting does not guarantee a suitable height when the new text is longer.
Save and review the sheet at its intended size. Save the workbook, then look at the cells at normal zoom or in Print Preview if the sheet will be printed. A row that appears adequate at high zoom may be clipped at another view, and page scaling can change the printed appearance. If the sheet is shared, reopen it or check it in the target Excel version to confirm the layout remains readable.

For Excel for Mac, use the Home tab and its Alignment controls to turn on Wrap Text; the feature behaves much like it does on Windows. Excel for the web also has Wrap Text on the Home tab, though the ribbon may be arranged more compactly. If a ribbon command is hard to find, use Excel’s search box to search for Wrap Text.

Common Mistakes

Confusing wrapping with inserting line breaks. Wrap Text breaks lines automatically according to the column width. It does not add newline characters to the stored text. To force a break at a particular point within a cell, edit the cell and insert a line break: press Alt+Enter on Windows. On Mac, use Control+Option+Return in Excel. A manual break stays at that point even if you later change the column width, so use it only when that fixed layout is useful.
Expecting AutoFit to fix every row. AutoFit Row Height can fail to show all lines when the cell is merged, when a row has a manually fixed height, or when formatting has not recalculated after a change. Do not assume the setting is off just because the bottom line is hidden. Check the cell’s wrap setting first, then inspect the row height and whether cells are merged.
Using merged cells for a layout that needs automatic sizing. Excel does not reliably AutoFit row height for merged cells. If a wrapped heading in a merged area is clipped, unmerge the cells and consider using Center Across Selection for a centered heading, or set the row height manually. If merging is required, increase the height until every line is visible and check it again after changing the text.
Assuming blank space beside a cell means its text is wrapped. Text in an unwrapped cell can spill into adjacent empty cells. When a neighboring cell has content, that spill is blocked and the rest seems missing. Turn on Wrap Text and adjust the row height rather than inserting spaces or widening the column without checking the layout.
Applying a fixed row height that is too small. A row height set earlier can prevent new lines from showing. This is common when a worksheet has been formatted for a different font size or a shorter entry. Use AutoFit Row Height, or increase the specified height after checking the longest cell in that row.

Tips

Format the whole input area in advance. If a column is reserved for notes or addresses, select the rows people will use and enable Wrap Text before entering data. This reduces inconsistent formatting and makes it less likely that an entry will overlap nearby cells. Leave some extra rows formatted if the list is likely to grow.
Choose a sensible width before adjusting individual rows. Narrow columns create many short lines and very tall rows; overly wide columns make the sheet difficult to scan. Set the column width first, then use AutoFit Row Height. This order helps Excel calculate the line count from the final available width.
Use alignment deliberately. Wrapped text can be aligned to the top of a cell using Home > Alignment > Top Align. Top alignment is helpful when neighboring rows have different heights because the first line begins at a consistent position. Horizontal alignment, such as left or center, is separate from Wrap Text and can be adjusted independently.
Keep long notes manageable. For a cell containing a very large block of text, wrapping may create an extremely tall row and make the sheet hard to navigate. Consider keeping a short summary in the table and placing the full note in a separate sheet, comment, or linked document. This is a layout choice; Wrap Text can display long entries, but it does not make them easier to scan.
Use Format Painter cautiously. It can copy Wrap Text along with other formatting, but it may also copy number formats, borders, fills, and alignment. If you only need to preserve the cell’s contents while retaining its current formatting, paste values instead. If you copy formatting, inspect the destination for unexpected changes.
Check printed pages separately. Printing may scale columns or split rows across pages. Open File > Print and review the preview. Adjust page orientation, margins, or scaling only after checking that the text is still legible; forcing an entire wide sheet onto one page can shrink wrapped text substantially.

Troubleshooting

The text is still cut off. Select the cell and confirm Home > Alignment > Wrap Text is on. Then select its row and run Home > Cells > Format > AutoFit Row Height. If the row does not expand, check for a fixed row height or merged cells. Unmerge the cells if practical; otherwise, set a larger row height manually and verify that the last line is visible.

The row does not resize after I edit the text. Select the row and run AutoFit Row Height again. This can refresh the height after edits, pasted content, or a column-width change. If you selected several rows, ensure the selection includes the entire row area rather than only a cell with a different height. Also check whether the worksheet is protected, since protection can prevent formatting changes.

Wrap Text turns off after I paste. Pasting normally can bring the source cell’s formatting with it. Undo the paste if possible, then paste the content using Paste Special > Values or the option to keep destination formatting. Turn Wrap Text back on for the affected range and use AutoFit Row Height. If the source is from a website or another program, pasting as plain text can avoid unwanted formatting.

Only some cells wrap. The setting may have been applied to a partial range, or the cells may have inconsistent formats. Select the full intended range, click Wrap Text once, and inspect several cells, including the bottom of the range. If some cells remain different, check whether the sheet has protected cells or whether a table or pasted format has overridden your selection.

The text looks different on another computer or in print. Fonts, zoom, column widths, and page scaling can affect line breaks. Use a common font, avoid relying on a barely sufficient row height, and check the workbook in the version and output format that matter. When printing, use Print Preview; when sharing electronically, save and reopen the workbook to make sure the layout is preserved.

Frequently Asked Questions

Does Wrap Text change the contents of a cell?
No. It changes how Excel displays the existing value by breaking it across lines within the cell. It does not insert line-break characters or alter the underlying text.

Will Wrap Text stay on when I change the text?
Yes, normally. It is a cell-formatting setting, so editing the value does not turn it off. A paste that includes source formatting, a format change, or a newly added cell can produce a different result, so check the setting after those actions.

Why does Excel not make the row taller automatically?
AutoFit may not work as expected with merged cells or fixed row heights, and some edits or pastes may require you to run AutoFit Row Height again. Check the row’s height and the cell’s merge status before assuming Wrap Text is broken.

Can I wrap text in an entire column?
Yes. Click the column letter to select the column, then choose Home > Alignment > Wrap Text. This also applies to cells you fill in later, but you may want to limit the selection to the worksheet’s used rows to avoid unnecessary formatting across a very large area.

How do I keep a line break in a specific place?
Edit the cell and insert a manual line break: Alt+Enter on Windows or Control+Option+Return on Mac. This is different from automatic wrapping. The manual break remains even if you make the column wider, so remove it if you want Excel to choose the line positions.

Can I wrap text in Excel for the web?
Yes. Select the cells and choose Wrap Text from the Home tab. If the control is not visible in the compact ribbon, expand the ribbon or search for the command. Row height can still need adjustment, especially when the cell is merged or the content has changed.

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.