You press Alt+Enter in an Excel cell to create a line break, but the text stays on one line. This happens because the cell’s formatting does not allow text to wrap onto multiple lines. The Wrap Text feature must be turned on to display manual line breaks correctly. This article explains why this occurs and provides the steps to enable text wrapping.
Key Takeaways: Showing Line Breaks in Excel
- Home > Wrap Text: This is the primary formatting command that makes text flow within a cell and display Alt+Enter line breaks.
- Format Cells > Alignment > Wrap text: The same setting accessed through the full Format Cells dialog box for more control.
- Ctrl+1: The keyboard shortcut to open the Format Cells dialog and quickly check the text wrapping setting.
Why Wrap Text Is Required for Manual Line Breaks
Excel treats a cell like a container. By default, text in a cell flows in one continuous line, extending beyond the cell’s border if it is long. When you insert a manual line break with Alt+Enter, you are adding a special character to the text string. However, the cell’s default formatting does not instruct Excel to use that character to start a new visual line.
The Wrap Text feature changes this behavior. When enabled, it tells Excel to respect the cell’s width and the line break characters you inserted. The text will wrap at the cell’s right edge and also at every point where you pressed Alt+Enter. Without this setting turned on, the line break character is still present in the cell’s data, but it remains invisible on the screen.
Checking for Existing Line Breaks
You can confirm a line break is in the cell even if it’s not showing. Click on the cell and look at the formula bar. The text will appear on multiple lines there, with a small gap indicating the break. This proves the data is correct, and the issue is purely a display formatting problem solved by enabling Wrap Text.
Steps to Enable Wrap Text and Show Line Breaks
- Select the target cell or range
Click on the cell where your line break is not showing. To apply the fix to multiple cells, click and drag to select them all. - Go to the Home tab on the ribbon
Navigate to the main toolbar at the top of the Excel window. The Home tab contains the most common formatting commands. - Click the Wrap Text button
In the Alignment group, find the button with an icon of angled text lines. Click it once. The button will highlight, indicating the feature is active for the selected cells. - Adjust the column width if needed
After enabling Wrap Text, the cell height will automatically increase. If the text still looks cramped, position your cursor on the right border of the column header and double-click to auto-fit the width to the longest line.
Using the Format Cells Dialog Method
You can also control text wrapping through a more detailed settings menu.
- Select your cells and press Ctrl+1
This keyboard shortcut opens the Format Cells dialog box directly. - Go to the Alignment tab
Click on the Alignment tab at the top of the dialog box to see text control options. - Check the Wrap text box
In the Text control section, find the checkbox labeled “Wrap text” and click it to add a checkmark. - Click OK to apply
Click the OK button to close the dialog and apply the new formatting to your selected cells.
If Wrap Text Is On But Line Breaks Still Don’t Show
Cell Merging Overrides Line Breaks
If your cell is part of a merged cell range, Wrap Text may not work as expected. Merged cells have complex formatting rules that can ignore manual line breaks. The most reliable fix is to unmerge the cells. Select the merged cell, go to Home > Merge & Center, and click the dropdown arrow. Select “Unmerge Cells.” Then, reapply the Wrap Text setting.
Fixed Row Height Is Preventing Display
A row with a manually set height may not expand to show wrapped text. Right-click the row number, select “Row Height,” and ensure the height is set to “AutoFit” or a sufficiently large number. You can also double-click the bottom border of the row header to auto-fit the height.
Corrupted Workbook or Cell Formatting
In rare cases, specific cell formatting can become corrupted. Try copying the cell’s contents, pasting them into a new, blank workbook, and applying Wrap Text there. If it works, the issue is with the original file’s structure. Use the “Clear Formats” command on the original cell before reapplying your formatting.
Manual Line Breaks vs. Automatic Text Wrapping
| Item | Manual Line Break (Alt+Enter) | Automatic Wrap Text |
|---|---|---|
| Primary Control | User decides exact break points | Excel breaks lines at cell border |
| Keyboard Shortcut | Alt+Enter | Alt+H+W |
| Cell Content | Contains hidden line-feed character | No extra characters added |
| Use Case | For addresses, lists, or precise phrasing | For long paragraphs that fit a column width |
| Required Setting | Wrap Text must also be enabled | Wrap Text is the only setting needed |
You can now display line breaks in your Excel cells by enabling the Wrap Text feature. Use the button on the Home tab for a quick fix, or the Format Cells dialog for more control. If breaks still hide, check for merged cells or a fixed row height. For advanced control, remember that Alt+Enter and Wrap Text work together—one adds the break, the other makes it visible.