In Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, W—one key at a time—to turn on Wrap Text. This displays long cell entries on multiple lines instead of letting them run into neighboring blank cells. You do not need to install anything; just open the workbook and select the cells you want to change.
What You’ll Need
- Excel for Microsoft 365 on Windows, or another Excel version with the Home ribbon.
- A worksheet containing text or numbers that you want displayed on multiple lines.
- For the keyboard method, a keyboard with an Alt key. On a Mac, use the Mac-specific instructions below instead of the Windows key sequence.
Wrap Text changes how cell contents are displayed; it does not insert new characters or change the underlying value. Excel decides where to break the displayed lines based on the cell width. If the entry already fits on one line, turning on wrapping may not visibly change it until the column is narrower or the content is longer.
Step-by-Step
- Select the cell or range. Click a cell with the text you want to wrap. To apply the setting to several adjacent cells, drag across them or click the first cell, hold Shift, and click the last. You can also select a whole column by clicking its letter, or a whole worksheet by clicking the Select All corner above row 1 and left of column A. The setting will apply to the selection, including blank cells in it.
- Use the Windows keyboard sequence. Press and release Alt, then press and release H, then press W. Do not hold all three keys down together. Alt activates Excel’s ribbon Key Tips, H selects the Home tab, and W activates the Wrap Text command. If Key Tips appear on screen, follow the letters shown there; they can vary if the ribbon layout or language differs.
- Check that wrapping is on. Look at the selected cells. If a long entry now appears on two or more lines, the command worked. You can also look on the Home tab for the Wrap Text button in the Alignment group; its highlighted state indicates that wrapping is enabled for the active cell. If the text still fits on one line, continue to the next step before assuming the shortcut failed.
- Make the column narrow enough to reveal the effect. If the entry is short or the column is wide, Excel may still display it on one line. Drag the right edge of the column heading to make the column narrower, or double-click that edge to AutoFit the column to its contents. AutoFit usually makes the column wider, so it may reduce the number of visible wrapped lines. Choose a practical column width for the worksheet rather than expecting wrapping to force a particular line count.
- Let the row height fit the wrapped lines. Excel normally expands row height to show wrapped content. If you see only the first line, select the affected row and use Home > Format > AutoFit Row Height. You can also double-click the boundary below the row number. If the row has a manually fixed height, AutoFit can restore a height that fits the text.
- Apply the setting to other cells if needed. Select another range and repeat Alt, H, W. The shortcut acts on the current selection; it does not automatically change every cell in the workbook. If you select cells with mixed settings, the button may not communicate one simple on-or-off state. Check a particular cell after selecting it to see how its setting is displayed.
- Use the ribbon as a keyboard fallback. If Alt, H, W does not trigger the command, click Home > Wrap Text in the Alignment group. This is also useful in Excel for the web, where browser shortcuts or the browser’s handling of Alt can affect Key Tips. The ribbon button applies the same formatting without relying on the key sequence.
- On a Mac, open the alignment settings. Excel for Mac does not use the Windows Alt, H, W sequence. Select the cells and press Command+1 to open Format Cells. Choose the Alignment tab, enable Wrap text, and confirm the dialog. You can also use Home > Wrap Text when the button is available on the ribbon. Mac keyboard navigation and dialog controls can differ slightly by Excel release.
- Save and review the worksheet. Once the text is readable, check nearby rows and columns for unexpected changes. Wrapping is a cell-formatting setting, so it is saved with the workbook. If the layout is important for printing or sharing, use Print Preview or reopen the saved file to confirm that the row heights and column widths still show the full entries.
To turn wrapping off, select the relevant cells and use Alt, H, W again on Windows, or clear Wrap text in the Alignment settings on a Mac. The command toggles the setting for the selection. Turning it off does not delete text, but a long entry may once again look as if it runs beyond its cell when adjacent cells are empty.
Common Mistakes
- Holding the keys together. Alt, H, W is a ribbon sequence, not a three-key chord. Press Alt, release it, press H, release it, and then press W. If you hold the keys together, Excel may not interpret the input as the intended command.
- Selecting the wrong cells. The shortcut affects the active selection. If only one cell is selected, only that cell changes; if an entire column is selected, the setting applies throughout that column. Confirm the selection border before using the shortcut.
- Expecting wrapping to insert line breaks. Wrap Text creates visual line breaks that adjust to the column width. It does not add manual line-break characters to the cell value. To force a break at a specific point within a cell, edit the cell and use Alt+Enter on Windows. On a Mac, the manual line-break shortcut can depend on the Excel version and keyboard; use the app’s editing guidance if needed.
- Changing column width and expecting a fixed line count. A wrapped entry can occupy a different number of lines as the column width changes. If the text is edited, pasted, or the column is resized, Excel may recalculate the breaks.
- Assuming the shortcut failed because nothing moved. The column may be wide enough for the whole entry, or the selected cells may contain short text. Make a column narrower to test the display, then check the Wrap Text button or Alignment settings.
Tips
- Set a useful width before judging the result. For tables, a consistent column width often makes wrapped headers and notes easier to scan. Drag the column boundary to a sensible size, then use Wrap Text and AutoFit Row Height.
- Wrap headings selectively. A short heading such as Department may not need wrapping, while a longer heading can use two lines to keep the table compact. Select only the heading cells you want to format instead of applying the setting to the whole sheet.
- Use manual breaks only when the wording needs a specific layout. Wrap Text is better for ordinary descriptions because the breaks adapt when the column changes. A manual line break can be useful for a two-part label, but it may require editing if the column width later changes.
- Check vertical alignment. When a row becomes taller, text may sit at the top, center, or bottom of the cell depending on its alignment setting. Use the vertical alignment controls in Home > Alignment to make a table look consistent.
- Remember that wrapping is not the same as shrinking. Shrink to fit reduces the displayed text size to fit a cell on one line. Wrap Text keeps the font size and uses additional lines. For long notes, wrapping is usually easier to read; for compact identifiers, shrinking may be more suitable.
- Consider merged cells carefully. Merged cells can make automatic row-height adjustment unpredictable. If wrapped text is clipped in a merged area, try unmerging the cells, setting an appropriate column width, and using Wrap Text. If the merged layout is required, adjust the row height manually and review the result.
Troubleshooting
The shortcut opens something else or does nothing: Make sure Excel is the active window, press the keys in sequence, and look for Key Tips after pressing Alt. A laptop may require an Fn key for some function keys, but Alt, H, W normally uses letter keys rather than function keys. If the sequence is intercepted by the operating system, browser, or a customized ribbon, click Home > Wrap Text instead. In Excel for the web, the ribbon method is a dependable alternative when browser shortcut behavior differs.
Only part of the text is visible: Select the affected row and choose Home > Format > AutoFit Row Height. Check whether several rows are selected, because one row’s height can affect what you see in the selection. Also check for a manually set row height, merged cells, or text that includes a manual line break. If necessary, drag the row boundary downward to make more room.
The row does not expand after wrapping: A fixed row height may prevent Excel from showing every line. AutoFit the row, or increase its height by dragging the boundary below its row number. Merged cells and some copied formatting can also complicate automatic sizing. Try unmerging the cell temporarily or copying its text into a regular cell to identify whether the layout, rather than the wrapping setting, is the cause.
Text still appears to spill into the next cell: Wrapping may be off for that specific cell, or the content may already fit in the column. Select the cell and verify the Wrap Text button or Format Cells alignment setting. Remember that text can visually overflow into a neighboring cell only when that neighbor is empty; existing content in the neighboring cell can hide the overflow without wrapping the original text.
Some lines are hidden or the layout changes after reopening: Check row heights, column widths, and merged cells, then save the workbook and review it again. Different font availability or display scaling can slightly affect line breaks. For a printed worksheet, use Print Preview and adjust widths, margins, or page scaling so that wrapped rows remain legible.
Frequently Asked Questions
What is the keyboard shortcut to wrap text in Excel?
In Excel for Microsoft 365 on Windows, select the cells and press Alt, H, W in sequence. It is a ribbon Key Tip sequence, not a simultaneous key combination.
How do I wrap text on a Mac?
Select the cells, press Command+1, open the Alignment tab, and enable Wrap text. If the ribbon button is visible, you can also choose Home > Wrap Text.
Does Wrap Text change the cell’s value?
No. It changes how Excel displays the value in the worksheet. The underlying text remains the same unless you edit it.
Why does wrapping not make the row taller?
The text may fit on one line, the row may have a fixed height, or the cell may be merged. Use AutoFit Row Height or increase the row height manually, and check the cell layout.
Can I wrap text in several cells at once?
Yes. Select a range, row, or column first, then use the shortcut or ribbon command. Excel applies the setting to the selected cells.
How do I put a line break in a particular place?
Wrap Text chooses breaks according to the cell width. To insert a manual break while editing a cell on Windows, place the cursor where you want the break and press Alt+Enter. The manual break remains part of the cell’s content even if the column is resized.
Related
- Share an Excel Document on Google Docs: Step by Step
- Excel Color Based on Value with Conditional Formatting
- Excel Custom Number Format: How to Create and Apply It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Do Excel Cells Automatically Resize?No. In Microsoft Excel for Microsoft 365 on Windows, columns do not automatically widen and rows do not…
- How to Double Space in Word, Step by StepTo double-space text in Microsoft Word, select it and choose Home > Line and Paragraph Spacing > 2.0.…
- Excel Keyboard Shortcuts: What You Can Customize in ExcelIn Excel for Microsoft 365 on Windows, you cannot directly remap most built-in keyboard shortcuts through an Excel…
- Excel Data Validation List Autocomplete: How It WorksIn an up-to-date Microsoft 365 version of Excel, a data-validation dropdown can autocomplete by filtering its choices as…
- Create a Number List in Excel: Easy Steps and MethodsTo create a numbered list in Excel, enter 1 in the first cell and 2 in the cell…
- How to Enter a Checkbox in Google Sheets, Step by StepTo enter a checkbox in Google Sheets, select the cell or range where you want it, then choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.