Find Wrap Text in Excel: Location and How to Use It

In Excel for Microsoft 365 on Windows, find Wrap Text on the Home tab, in the Alignment group. Select the cell or cells, then click Home > Alignment > Wrap Text to display long entries on multiple lines inside their cells. You do not need to change the cell contents; wrapping changes how they appear.

What You’ll Need

A workbook open in Microsoft Excel. The steps below are for Excel for Microsoft 365 on Windows.
The cell, range, row, or column you want to format. You can select cells that already contain text or blank cells where you plan to enter text.
If the ribbon is minimized or the window is narrow, be ready to expand the ribbon or use Excel’s Search box to locate the command.

Step-by-Step

Select the cells to format. Click a single cell to wrap only that entry. To apply wrapping to several cells, drag across the range, or click the first cell, hold Shift, and click the last. To select a whole column or row, click its letter or number heading. You can also select a range that includes currently blank cells; those cells will have wrapping enabled when you enter text later.
Open the Home tab. Look at the ribbon across the top of the Excel window and click Home if another tab is active. The Wrap Text command is in the Alignment group, alongside controls for horizontal and vertical alignment, text orientation, and indenting. If you can see the group labels, look for Alignment.
Find the Wrap Text button. In the Alignment group, look for the button labeled Wrap Text. Depending on your window size and ribbon layout, it may appear as a two-line text icon with a curved arrow. The button’s label is the reliable clue. If the ribbon is compressed, Excel may hide some controls behind a group menu or display only icons; widen the window or expand the ribbon to see the full command.
Turn wrapping on. With the intended cells selected, click Wrap Text. Excel places parts of a longer entry on additional lines within the existing column width. The text remains in one cell; it is not split into separate cells. The button is a toggle, so clicking it again turns wrapping off for the selection.
Check the row height and column width. Excel usually increases the row height to show wrapped lines. If the full entry is not visible, select the affected row and choose Home > Format > AutoFit Row Height. You can also double-click the boundary below the row number to AutoFit. If the column is too narrow or too wide for your layout, drag the boundary between its column letters to adjust it; wrapping adapts to the available width.
Confirm the result with a longer entry. Click a wrapped cell and read the text in the formula bar, which shows the full cell content even when the grid display is hard to assess. If the entry displays across several lines and the row shows those lines, wrapping is active. Try selecting the cell and clicking Wrap Text once more only if you intend to change the setting; the command toggles rather than opening a separate setup window.
Use another route if you cannot see the button. On Windows, press Alt, then H, then W to use the ribbon KeyTips and toggle Wrap Text for the selection. You can also press Ctrl+1, open the Alignment tab in Format Cells, tick Wrap text, and choose OK. If the Search box is available, click it, type Wrap Text, and select the matching command.

In Excel for Mac, select the cells and use the Home tab’s Wrap Text command; the ribbon arrangement can differ slightly from Windows. The Format Cells route is also available through Format Cells > Alignment. In Excel for the web, select the cells and choose Home > Wrap Text. If the ribbon looks different, use its search or command-help feature to find Wrap Text rather than assuming a Windows keyboard sequence will work.

Common Mistakes

Looking on the wrong tab. Wrap Text is normally on Home in the Alignment group, not on Insert or Data. The Format Cells dialog is an alternate route, but it is still an alignment setting.
Expecting the column to get wider. Wrap Text keeps the column width and moves text onto more lines. If the column is narrow, the row can become tall. Change the column width separately if that is not the layout you want.
Thinking the command failed because nothing visibly changed. Short content may fit on one line even when wrapping is enabled. Test with a longer entry or check the setting in Format Cells > Alignment.
Clicking the button without noticing it is a toggle. A second click turns wrapping off for the selected cells. If only some cells look different, select the whole intended range and apply the setting consistently.
Manually shrinking the font to solve every display issue. Font size is separate from wrapping. Small text can make a sheet difficult to read, while AutoFit Row Height or a better column width may solve the problem more cleanly.
Assuming a line break means Wrap Text is on. A manually inserted line break can make one cell display on multiple lines even when automatic wrapping is off. The Alignment setting determines whether Excel wraps the content to fit the cell width.

Tips

Use the formula bar to verify the actual content. A cell’s display can be clipped by its row height or neighboring layout, but selecting it reveals the complete entry in the formula bar. This helps distinguish a display issue from missing text.
Format a range before entering notes. Select the notes column and turn on Wrap Text in advance. New longer entries in those selected cells can then display on multiple lines without requiring you to format each one individually.
Keep the column width consistent when comparing rows. If each row has a different width or the column is resized frequently, the same sentence may use a different number of lines. Set a practical column width first, then use wrapping for the entries.
Use AutoFit carefully in a designed report. AutoFit Row Height makes all visible wrapped lines easier to read, but a very long note can create an unusually tall row. If that disrupts the sheet, widen the column, shorten the display text, or move detailed notes to a separate area.
Use manual line breaks only when you need control over phrasing. On Windows, press Alt+Enter while editing a cell to start a new line at a chosen point. Automatic wrapping can still be useful alongside manual breaks, since it responds if the column width changes.
Remember that formatting can be copied. Use Format Painter on the Home tab to copy a correctly wrapped cell’s formatting to other cells. Check the destination afterward, especially if it has a different width or row-height requirement.

Troubleshooting

The text still looks cut off. First select the cell and confirm that Wrap Text is enabled, either on the Home tab or in Ctrl+1 > Alignment. Then select the row and use Home > Format > AutoFit Row Height. A fixed row height can prevent Excel from showing all wrapped lines. If the row was manually set to a specific height, AutoFit it or drag the row boundary down to give it more space.

The row height does not adjust as expected. Try AutoFit Row Height, then inspect whether the cell is merged with adjacent cells. Excel may not automatically size the row correctly for wrapped text in merged cells. If possible, unmerge the cells and use horizontal alignment options such as Center Across Selection instead, or set the row height manually. For a worksheet shared with others, avoid merged cells in data tables because they can also make sorting and selection less convenient.

Wrap Text is missing from the ribbon. Maximize the Excel window, expand a minimized ribbon, or look for a collapsed Alignment group. You can open Format Cells with Ctrl+1 on Windows and check the Alignment tab. Alternatively, type Wrap Text in Excel’s Search box and choose the command. Ribbon placement can vary with screen size and updates, but the setting is also available in the Format Cells dialog.

The text appears on multiple lines, but the setting seems off. The cell may contain a manual line break. Select the cell and check the Wrap text option in Format Cells > Alignment to confirm the automatic setting. Manual breaks remain part of the cell’s content; toggling Wrap Text does not remove them.

Only some cells in the range change. Verify that the intended range was selected before clicking the toggle. If cells had mixed formatting, clicking once may turn wrapping on for some and off for others. Select the entire range, inspect the setting, and apply the desired format consistently. If the workbook is protected, check whether sheet protection prevents formatting changes; you may need permission to unprotect it.

Frequently Asked Questions

Where is Wrap Text in Excel?
On Windows, it is on Home > Alignment > Wrap Text. You can also find a checkbox for it in Format Cells > Alignment.

Does Wrap Text change the column width?
No. It keeps the column width and displays content on more lines within the cell. The row may become taller to show those lines.

Can I wrap text in several cells at once?
Yes. Select the range, rows, or columns you want to format, then click Wrap Text. The same setting is applied to the selection.

Why is wrapped text not fully visible?
A fixed row height, merged cells, or an unusually narrow column can affect how the text appears. Try AutoFit Row Height, adjust the width, or set the height manually.

Does Wrap Text split a cell’s contents into multiple cells?
No. The whole entry stays in one cell. Excel changes only its on-screen display; selecting the cell still shows the complete content in the formula bar.

Is there a keyboard shortcut for Wrap Text?
In Excel for Microsoft 365 on Windows, press Alt, then H, then W. These are sequential ribbon KeyTips, not keys to hold down together. Mac and web shortcuts can differ, so use the Home tab command if that sequence is unavailable.

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.