To do word wrap in Excel, select the cell or cells, then choose Home > Wrap Text. Excel displays the cell’s text on multiple lines within its existing column width, increasing the row height when needed. This changes how the text appears, not the contents of the cell, and works in Microsoft Excel for Microsoft 365 on Windows, Mac, and the web.
What You’ll Need
- An Excel workbook with text in one or more cells. Wrapping is most useful for long labels, notes, addresses, or headings.
- Access to the worksheet you want to format. If the workbook is read-only or protected, you may need permission to change its formatting.
- The cells, rows, columns, or range you want to adjust. You can set wrapping before or after entering text.
Step-by-Step
- Select the cells to format. Click a single cell to wrap just that cell. To wrap several cells, drag across the range, or click the first cell, hold Shift, and click the last. To apply wrapping to a whole column or row, click its letter or number heading. To select the entire worksheet, use the small triangle at the intersection of the row and column headings, or press Ctrl+A while a cell is selected. Applying the setting to a large area is fine, but use it selectively if you do not want every cell to become taller.
- Turn on Wrap Text. On Windows, open the Home tab and, in the Alignment group, click Wrap Text. The button is a toggle: clicking it again turns wrapping off for the selected cells. The Windows ribbon key sequence is Alt, then H, then W (press the keys in sequence, not all at once). On Mac, select the cells and click Home > Wrap Text; you can also find text wrapping in the cell-formatting alignment options. In Excel for the web, select the range and use Home > Wrap Text.
- Check the row height and column width. Excel usually increases row height automatically so wrapped lines can be seen. It does not normally widen the column to accommodate the text; keeping the column narrow is what makes the text wrap. If a row still looks cramped, drag its lower boundary in the row-heading area downward. You can also choose Home > Format > AutoFit Row Height to fit the selected rows to their contents.
- Adjust the column width if the result is awkward. A very narrow column can turn a short label into many lines, making the row unnecessarily tall. Drag the boundary between column letters to widen it slightly, or double-click that boundary to use AutoFit Column Width. AutoFit bases the width on the cell contents, so it may make a column much wider than you want; drag it back to a practical width afterward. With Wrap Text still on, Excel will show the text over as many lines as the final width requires.
- Use a manual line break when you need a specific split. Wrapping chooses line breaks based on the available width, so it may not put a heading or address on the line you prefer. To insert a break while editing a cell on Windows, press Alt+Enter at the point where the next line should begin. On Mac, use Control+Option+Return while editing the cell. You can enter edit mode by double-clicking the cell or selecting it and pressing F2 on Windows. The break stays in the cell even if you later change the column width.
- Review the whole range in the worksheet. Click another cell and scan the rows for clipped text, excessive height, or unexpected alignment. If the data will be printed, open File > Print and check the preview too: page scaling and page breaks can change how a wrapped range looks on paper. Save the workbook after you are happy with the layout.
Wrapping applies to cell formatting, not just to the text that is currently in a cell. If you turn it on for a blank cell and later type a longer entry there, Excel can wrap that new entry as well. You can copy the formatting to another range with the Format Painter or by pasting formats, but check the destination because copied formatting may also include other settings.
Common Mistakes
Expecting the column to expand: Wrap Text is designed to keep text inside the current column width and use more vertical space. If the words are crammed into too many lines, adjust the column width rather than expecting the button to widen it automatically.
Confusing wrapping with shrinking text: The separate Shrink to Fit setting reduces the displayed font size to fit a cell on one line. It does not create multiple lines and can make text hard to read. If you want several readable lines, use Wrap Text instead.
Assuming the row height will always update perfectly: Most ordinary rows adjust as text wraps, but manually fixed row heights can clip the bottom of the text. Merged cells are another common exception: Excel may not automatically calculate a suitable row height for wrapped text in a merged range. Unmerge the cells if possible, or set the row height manually and check every line.
Adding line breaks when wrapping alone would work: Manual breaks are useful for intentional formatting, but they remain even after you widen the column. That can leave short, uneven lines. Remove an unwanted break by editing the cell and deleting it, or re-enter the text without the break.
Turning wrapping on for the wrong selection: The button affects the selected cells, not necessarily the whole table. If only one cell was selected, the other cells will not wrap. Select the intended range again and check the setting; the button may look different when the selection contains a mix of wrapped and unwrapped cells.
Tips
For a long column of descriptions, select just the description cells and wrap them, leaving narrow date or ID columns unwrapped. This keeps the worksheet readable without increasing the height of every row. If you have a header row, wrapping the headings can help preserve a consistent column width while displaying full labels.
Choose a column width before fine-tuning row heights. Changing the width later changes where Excel breaks lines, so you may need to AutoFit the rows again. For a quick reset after changing widths, select the affected rows and choose Home > Format > AutoFit Row Height. You can also double-click a row boundary to AutoFit that row, though this is less convenient for a large selection.
Use alignment controls to make wrapped content easier to scan. The Top Align option in the Home tab’s Alignment group can place text at the top of a taller row, which is often helpful when entries have different numbers of lines. Horizontal alignment is separate: wrapping does not automatically left-align, center, or otherwise reposition the text.
When preparing a worksheet for other people, consider whether they will view it at a different zoom level or print it. Zoom changes how much of the sheet is visible on screen but does not change the actual cell width. Print scaling, however, can shrink the whole sheet. Check both the normal worksheet view and Print Preview when the final layout matters.
If a cell contains a formula that returns text, Wrap Text can display the result across lines just as it does ordinary text. The formula itself is unchanged. If the result is a number or date, Excel’s number format and alignment may affect its appearance, but wrapping does not turn the underlying value into separate cells or change its calculation.
Troubleshooting
The text still appears on one line or seems cut off. First select the cell and confirm Home > Wrap Text is enabled. If a range has mixed formatting, toggle the setting on for the full intended range. Then check whether the row has a fixed height: select the row and choose Home > Format > AutoFit Row Height. If the text is in a merged cell, unmerge it or increase the row height manually, because automatic sizing may not work reliably for merged ranges.
The row is much taller than expected. The column may be too narrow, or the cell may contain manual line breaks. Widen the column a little and see whether the number of lines decreases. Double-click the cell to inspect its contents for intentional line breaks. If the row height was previously set by hand, choose AutoFit Row Height to recalculate it; you can then adjust the height if the automatic result is not the layout you want.
Wrap Text looks unavailable or does nothing. Confirm that you are editing a worksheet cell rather than a chart, shape, or other object. If the sheet is protected, Excel may block formatting changes; ask the workbook owner for access or use Review > Unprotect Sheet if you are authorized and have the required password. Also check that the selection is not a merged range with unusual sizing behavior. The setting affects the cell display, so it will not split the text into separate rows or columns.
The wrapped text looks different after copying or printing. Copying a cell may bring along its alignment, width-related layout, or row-height formatting. Check the destination column width and row height, and use Paste Special options if you only want certain content or formats. For printing, inspect File > Print, because page scaling may reduce the text size on paper. Adjust the print scaling or page layout if needed, then preview again.
The manual line-break shortcut does not work. Make sure the insertion point is inside the cell’s text, not merely that the cell is selected. On Windows, enter edit mode and press Alt+Enter. On Mac, use Control+Option+Return. If your keyboard or remote desktop intercepts the shortcut, insert the break while editing on another supported keyboard setup, or rely on automatic wrapping and adjust the column width.
Frequently Asked Questions
What does Wrap Text do in Excel?
It displays cell text on multiple lines within the cell’s existing column width. The underlying cell content remains a single value, and the row may become taller to show the extra lines.
Is there a keyboard shortcut for word wrap in Excel?
On Windows, press Alt, then H, then W to use the Home tab’s Wrap Text command. Mac does not use that Windows ribbon sequence; click Home > Wrap Text or use the alignment settings in cell formatting.
Can I wrap text in an entire column?
Yes. Click the column letter to select the column, then choose Home > Wrap Text. New text entered in those cells can also wrap. To avoid making every row in the column taller, apply the setting only to the rows that need it.
How do I put a new line inside one Excel cell?
Edit the cell and place the cursor where the break should go. Press Alt+Enter on Windows or Control+Option+Return on Mac. This inserts a line break in the cell’s contents, unlike automatic wrapping, which changes its line breaks as the column width changes.
Why does AutoFit not work with wrapped text in a merged cell?
Excel may not automatically calculate row height for wrapped text in merged cells. If practical, unmerge the cells and use a different layout. Otherwise, adjust the row height manually until all lines are visible, then check the result if the text or column width changes.
Does wrapping change the value or formula in a cell?
No. Wrap Text changes the display formatting. It does not edit the text, alter a formula, or change a number stored in the cell. A manual line break is different because it becomes part of the cell’s text.
Related
- How to Delete an Excel File from OneDrive Safely
- How to Delete an Excel File from SharePoint
- How to Delete an Excel Workbook Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Ribbon Keyboard Shortcuts: A Practical GuideIn Excel for Microsoft 365 on Windows, press Alt to display KeyTips: small letters or letter combinations that…
- How to Highlight Color in Excel: Cells, Rules, and MoreTo highlight cells in Excel, select the cells, open Home > Fill Color, and choose a color. For…
- How to Compress All Pictures in PowerPointTo compress every picture in a PowerPoint presentation in Microsoft 365 for Windows, select a picture, open Picture…
- Excel Hide Columns From Certain Users: What Actually WorksNo—not as a user-specific setting. In Excel for Microsoft 365, hiding a column hides it for everyone using…
- Can You Make Columns in a Text Box in Microsoft Word?Yes. In desktop Microsoft Word, select the text box and use Shape Format > Columns to divide its…
- How to Make Cell Borders White in Microsoft Excel 365To make cell borders white in Excel, select the cells, open Home > Borders > More Borders, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.