How to Enable Wrap Text in Excel and Adjust Row Height

How-to basics · Updated November 20, 2026

To enable Wrap Text in Excel for Microsoft 365 on Windows, select the cell or cells, then choose Home > Alignment > Wrap Text. Excel displays long cell contents on multiple lines within the existing column width; if the full text is still not visible, adjust the row height. You do not need to change the cell’s contents or install anything.

What You’ll Need

  • An Excel workbook you can edit, with the text you want to display on multiple lines.
  • Access to Excel for Microsoft 365 on Windows. The main steps are similar in Excel for Mac and Excel for the web, with some differences noted below.

Wrap Text is a cell-formatting setting. It changes how text is displayed, not the underlying value, so formulas and the actual text remain the same. Save a copy first if you are making extensive layout changes to an important workbook; it is not necessary for this simple formatting change.

Step-by-Step

  1. Open the workbook and find the text. Go to the worksheet containing the long entries. If the content is in a table, you can format one cell, a whole column, or a selected range. Look at the formula bar if you need to confirm which cell contains the full text; what appears in the grid may be cut off simply because the next cell contains data.
  2. Select the cell or range to format. Click one cell to wrap just that entry. To apply the setting to several cells, drag across the range or click the first cell, hold Shift, and click the last. To select a whole column, click its letter at the top of the worksheet. You can also select non-adjacent cells by holding Ctrl while clicking each one on Windows.
  3. Open the Home tab. On the ribbon, choose Home. Find the Alignment group, which contains controls for horizontal and vertical alignment and text orientation. If the Excel window is narrow, the group may be condensed; expand it or maximize the window to find the controls.
  4. Turn on Wrap Text. Click Wrap Text in the Alignment group. Excel will place parts of the cell’s text on additional lines when needed to fit the column width. The text stays in one cell; wrapping does not split it into separate rows or cells. The button is also a toggle, so clicking it again turns wrapping off for the selected cells.
  5. Check whether the full entry is visible. Look at the selected cells in the worksheet. Excel often adjusts row height automatically, but a row that has a manually set height may not expand. If text appears cut off vertically, select the affected row or rows and continue with the next step.
  6. AutoFit the row height if necessary. Select the row numbers along the left edge of the sheet. Then choose Home > Cells > Format > AutoFit Row Height. This tells Excel to size the selected rows to show their contents. For a quick adjustment, place the pointer on the lower boundary of a row number and double-click when the resize pointer appears. To AutoFit several rows, select them first, then use the ribbon command or double-click a boundary in the selection.
  7. Fine-tune the column width or alignment. If the result creates too many narrow lines, widen the column by dragging the boundary between its letter headings. A wider column usually means fewer wrapped lines and a shorter row. To position the text vertically within a taller row, use the vertical alignment controls in Home > Alignment. Save the workbook when the layout looks right.

You can also enable the same setting through the Format Cells dialog. Select the cells, press Ctrl+1 on Windows, open the Alignment tab, select the Wrap text checkbox, and choose OK. This route is useful when you are already adjusting several formatting options together. In Excel for Mac, select the cells and use Home > Wrap Text; the Format Cells dialog can generally be opened with Command+1. In Excel for the web, select the cells and choose Home > Wrap Text. The ribbon may look different depending on window size, but the command has the same purpose.

Common Mistakes

  • Expecting the column width to change. Wrap Text fits the content to the current column width; it does not widen the column. A narrow column can turn a short sentence into many lines and make its row unusually tall.
  • Assuming every wrapped row will resize automatically. A row height set to a fixed value can keep part of the text hidden. Use AutoFit Row Height or adjust the row boundary manually.
  • Applying the setting to the wrong cells. Wrap Text affects the current selection. If only one cell is selected, other cells in the same column may remain unchanged. Select the intended range or column before clicking the button.
  • Confusing clipping with missing text. A neighboring cell that contains data can prevent an unwrapped entry from visually spilling into it. The underlying text may still be present. Select the cell and inspect the formula bar before editing or replacing anything.
  • Using merged cells and expecting AutoFit to work normally. Excel may not automatically calculate a suitable row height for wrapped text in merged cells. A manually adjusted row height or a different layout may be needed.

Tips

Apply wrapping to a whole column when you expect new entries to be added there. Select the column heading and turn on Wrap Text once; cells in that column will use the formatting as new content is entered. In a structured table, you can select the relevant table cells or column and apply the same setting. Check the result after adding data, because row heights and the number of displayed lines depend on both the entry and the column width.

Consider adjusting column width before deciding on row height. For example, a notes column that is too narrow may produce a row several lines high for every entry. Widening it slightly can make the sheet easier to scan without changing any text. If you need consistent row heights for printing or a compact report, wrapping may make that difficult; shortening the displayed text or changing the page layout could be a better fit.

For a line break at a particular point, edit the cell and insert a manual line break rather than relying only on automatic wrapping. On Windows, press Alt+Enter while editing the cell; on Mac, use Control+Option+Return in many Excel versions. The exact Mac key combination can depend on the keyboard and Excel version. Wrap Text can still be enabled so the manually separated lines fit within the column. A manual break remains in the cell even if you later widen the column.

When preparing a worksheet for sharing, check the sheet at its intended zoom level and print preview. A display that looks fine on one screen can create tall rows or awkward page breaks when printed. If several rows are selected, AutoFit can resize all of them at once, but reviewing the finished layout is worthwhile, especially around headings and merged cells.

Troubleshooting

  • The text is still cut off at the bottom. Select the affected row and choose Home > Cells > Format > AutoFit Row Height. If the row is merged or has a fixed height, drag its lower boundary to increase the height. Make sure the worksheet is not protected from formatting changes.
  • The Wrap Text button does not seem to do anything. Confirm that the intended cell or range is selected and that it contains text longer than the available width. If the neighboring cell is empty, unwrapped text may spill into it, making the visual change less obvious. Click Wrap Text again to check its toggle state.
  • Only some cells in a column wrap. Formatting may differ between cells. Select the entire relevant range and click Wrap Text to apply the setting consistently. If the cells are part of a table, verify that you selected the data cells rather than only the header or a different column.
  • Text does not break where expected. Excel wraps based on the available width and the content. A long string with no spaces, such as a web address or code, may not produce the line breaks you want. Widen the column, insert a manual line break while editing, or shorten the displayed text if appropriate.
  • AutoFit makes rows too tall or changes the sheet unexpectedly. AutoFit sizes rows based on their contents, so one long entry can make its row much taller than its neighbors. Adjust the column width, edit the long entry, or set a suitable row height manually. If the workbook is protected, ask the owner for permission to change formatting.

Frequently Asked Questions

Does Wrap Text change the cell’s value?
No. It changes the display only. The complete text remains in the same cell, and formulas that refer to that cell continue to use its original contents.

Can I wrap text in multiple cells at once?
Yes. Select a range, several non-adjacent cells, or a whole column, then choose Home > Alignment > Wrap Text. The command applies to every selected cell.

Why is wrapped text hidden even after I turn on the setting?
The row may have a fixed height, or it may contain merged cells. Use AutoFit Row Height or increase the row height manually. Merged cells often need a manual height adjustment.

Does Wrap Text work in Excel for Mac and Excel for the web?
Yes. In both, select the cells and look for Wrap Text on the Home tab. Ribbon placement can vary by version or window size, and Mac keyboard shortcuts differ from Windows shortcuts.

How do I remove wrapping?
Select the wrapped cells and click Home > Alignment > Wrap Text again to turn the setting off. You may also use Ctrl+1 on Windows or Command+1 on Mac, open Alignment, and clear Wrap text.

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.