To wrap text in an Excel column, select the column or cells, then choose Home > Wrap Text. Excel displays long cell entries on multiple lines instead of letting them run across neighboring blank cells; you may also need to adjust row height or column width so all the wrapped lines are visible.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows. The same basic feature is available in Excel for Mac and Excel for the web, though the ribbon layout can vary slightly.
- Cells containing text that extends beyond the width of the column. You can use sample text first if you want to see how wrapping changes the layout.
- Permission to change the sheet’s formatting. If the worksheet is protected, you may need the sheet password or an authorized person to unlock it.
Step-by-Step
- Select the cells or column you want to format. To wrap every entry in a column, click its letter at the top of the worksheet, such as B. To wrap only part of a column, drag across the relevant cells or click the first cell and Shift-click the last. You can also select a range by clicking the Name Box to the left of the formula bar, typing a reference such as
B2:B50, and pressing Enter. Selecting a specific range avoids changing headings or unrelated cells elsewhere in the column. - Turn on Wrap Text. On Windows, open the Home tab and, in the Alignment group, click Wrap Text. The button may appear as a small icon showing text on multiple lines. The selected cells should now show their contents on more than one line when needed. The Windows ribbon-key sequence is Alt, H, W: press the keys in order rather than holding them all at once. On a Mac, select the cells and use Home > Wrap Text; the Windows key sequence does not apply.
- Check that the row height shows all the lines. Excel usually increases row height automatically when wrapping is enabled. If text still appears cut off, select the affected row or rows, then choose Home > Format > AutoFit Row Height. You can also move the pointer to the boundary below a row number and double-click it to fit that row to its contents. When several rows are selected, double-clicking a boundary can fit the selected rows. AutoFit changes height, not column width.
- Set a useful column width if the result is too tall or too cramped. Drag the right edge of the column letter’s header to make the column wider or narrower. A wider column generally creates fewer wrapped lines and shorter rows; a narrower one creates more lines and taller rows. You can also use Home > Format > Column Width to enter a specific width, or Home > Format > AutoFit Column Width to size the column to its contents. AutoFit Column Width may make a long-text column very wide, so dragging to a practical width is often better when the goal is to keep a readable table.
- Apply the setting to other columns when needed. Select a different column or range and click Home > Wrap Text again. To format several adjacent columns together, select all their column letters before turning on the setting. If you want to reuse the same formatting elsewhere, copy a cell with the desired formatting, select the destination cells, and use Home > Paste > Paste Special > Formats. Check the result afterward, because copied formatting can also affect other appearance settings such as alignment and number formatting.
- Review the worksheet at normal zoom. Look for entries that still have clipped lines, rows that are much taller than necessary, or columns that make the table hard to scan. If the sheet will be printed, use File > Print to preview the page layout. Wrapping controls how text appears in cells, but it does not automatically make a wide worksheet fit on one printed page.
Common Mistakes
Selecting the wrong cells: Clicking a column letter formats the entire column, including cells you may not intend to change. That is convenient for a consistent data field, but for a small table it can be tidier to select only the used range. If the result affects too much, press Ctrl+Z on Windows or Command+Z on Mac, select the intended cells, and repeat the action.
Expecting wrapping to change the column width: Wrap Text keeps the existing width and adds lines within each cell. It does not automatically widen the column. Adjust the width separately if the result is too tall or difficult to read.
Assuming the whole entry is visible as soon as wrapping is enabled: A row with a manually fixed height may not expand to show all its lines. AutoFit Row Height or a larger row height may be required. Also check for hidden rows and whether the text color is visible against the cell fill.
Using merged cells without checking row height: Excel may not AutoFit row height reliably for cells that are merged across columns. If a merged label is clipped, try unmerging the cells and using Home > Alignment > Center Across Selection when appropriate, or set the row height manually.
Confusing a line break with wrapping: Wrap Text makes Excel place text on multiple lines according to the cell width. A manual line break forces a new line at a specific place. Inserting line breaks into every entry can make later edits harder and is unnecessary for ordinary wrapping.
Tips
- Use wrapping selectively. It is especially useful for headings, addresses, notes, descriptions, and other text fields. Wrapping every column can make a data-heavy sheet unnecessarily tall.
- Choose a consistent width for similar fields. If several columns contain descriptions, matching their widths makes the table easier to compare. Select those columns together and set their width once.
- Keep headings readable. A short heading can wrap into two lines in a narrow column. To distinguish it from the data, apply bold formatting or a fill color separately; Wrap Text does not change font or color.
- Use manual line breaks only for deliberate layout. In Windows Excel, press Alt+Enter while editing a cell to start a new line at the cursor. On Mac, use Control+Option+Return in Excel for Mac. The cell may still need Wrap Text enabled, and the row may need AutoFit.
- Remember that formatting is separate from the text. Turning off Wrap Text later does not remove the cell’s contents. It simply changes how those contents are displayed, so the text may extend into adjacent blank cells or appear clipped.
- Make a copy before large layout changes. If you are formatting a report or shared template, save a copy first. This gives you a quick way to restore the original layout if a broad selection changes more cells than expected.
Troubleshooting
The text is still cut off after I click Wrap Text. Select the affected row and use Home > Format > AutoFit Row Height. If the row height was manually set, AutoFit can restore a height based on the visible contents. If the row does not change, check whether it is part of a merged range, whether the worksheet is protected, or whether the row is hidden.
Only one line is visible even though the row is taller. Confirm that Wrap Text is enabled for the actual cell, not just a nearby cell. Select the cell and look at Home > Wrap Text; click the button if it is not active. Also inspect the formula bar to confirm that the cell contains the full text rather than a shortened value.
The row is much taller than expected. The column may be very narrow, making even ordinary sentences occupy many lines. Widen the column slightly, then run AutoFit Row Height again. Check for accidental line breaks in the cell as well. If the text contains a long string with few or no spaces, it may not break into lines in the way you expect; consider adding suitable spaces or a deliberate line break, or give the column more width.
The Wrap Text button is unavailable or the formatting will not change. The worksheet may be protected, or you may be editing a cell. Press Enter or Esc to finish editing, then try again. If protection is on, use Review > Unprotect Sheet if you have permission and any required password. In a shared or read-only workbook, ask for editing access or save an editable copy.
The result looks different in Excel for the web or on another computer. Confirm that the workbook has finished saving and reopen it if needed. Row heights, fonts, and column widths can affect how many lines fit, so a different font substitution or screen layout can change the appearance. In Excel for the web, select the cells and find Wrap Text on the Home tab; if a row is clipped, adjust its height or use the available AutoFit row-height option in the row controls.
Printed text is still clipped or split across pages. First make sure the cell itself shows all lines in the worksheet. Then open File > Print and check the preview. Adjust column widths, page orientation, margins, or scaling as needed; page scaling may shrink the text, so compare the preview for readability before printing.
Frequently Asked Questions
Can I wrap text in an entire Excel column?
Yes. Click the column letter to select the full column, then choose Home > Wrap Text. This affects existing entries and cells you fill later in that column. If you only want a table section formatted, select its used cells instead.
Does Wrap Text change the value in a cell?
No. It changes the display, not the underlying text or number. The full entry remains in the cell and can still be read in the formula bar or edited normally.
How do I turn off text wrapping?
Select the wrapped cells and click Home > Wrap Text again. If the row remains tall after wrapping is off, choose Home > Format > AutoFit Row Height or adjust the row height manually.
Can I wrap text and center it in the cell?
Yes. Select the cells, enable Home > Wrap Text, then use the horizontal and vertical alignment controls in the Home tab’s Alignment group. Wrapping and alignment are separate settings, so choose the alignment you want after applying the wrap.
Why does a wrapped cell show #### instead of the value?
For numeric values and dates, a column that is too narrow can display hash marks. Widen the column or change the number format; wrapping is mainly useful for text and does not always solve a narrow numeric display.
Will wrapped text stay wrapped when I share the workbook?
Wrap Text is saved as cell formatting in the workbook, so it normally remains enabled when the file is opened in a compatible Excel version. The exact number of visible lines can still vary with column width, row height, fonts, and the application used to open the file.
Related
- Goal Seek in Excel: How to Find the Input You Need
- Goal Seek in Excel: Basics, Steps, and Practical Examples
- Generate a Heat Map in Excel: Color Scales and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add an MLA Header in Word: A Step-by-Step GuideTo add an MLA header in Microsoft Word, right-align the header, type your last name and a space,…
- How to Clear Cache Data in OutlookTo clear cache data in Outlook, first identify which Outlook version you use: in classic Outlook for Windows,…
- How to Create a Second Page of Address Labels in WordTo create a second page of address labels in Word, copy the label table from the first sheet,…
- Excel Solver Not Responding? Fixes and CausesIf Excel Solver is not responding, first give it a moment: Solver may be calculating a difficult model…
- Add a Print Area in Excel: Setup, Options, and FixesTo add a print area in Excel for Microsoft 365 on Windows, select the cells you want to…
- How to Add Speaker Notes to Your PowerPoint SlidesTo add speaker notes in PowerPoint, open your presentation in Normal view, select a slide, click Notes on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.