Quick answer: Select the cells and choose Home > Wrap Text (in the Alignment group). If the text wraps but the extra lines stay hidden, the row height is fixed: select the row and choose Home > Format > AutoFit Row Height, or double-click the border under the row number. Microsoft names two reasons wrapped text stays out of sight: a row with a fixed height, and merged cells. For a merged cell, set the row height by hand.
In this guide
- Fix 1: Turn on Wrap Text for the right cells
- Fix 2: Let the row grow with AutoFit Row Height
- Fix 3: Check for merged cells
- Fix 4: Narrow the column
- Fix 5: Clear Shrink to fit in Format Cells
- Fix 6: Add your own line breaks with Alt+Enter
- Fix 7: Unprotect the sheet
- Text that spills over vs text that wraps
- Excel for the web and Excel for Mac
- Match the symptom to the fix
- Related guides
Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows. Microsoft’s Wrap text article also lists Excel for the web, which gets a short note near the end. The fixes start with the quickest checks and move on to the less obvious ones.
Fix 1: Turn on Wrap Text for the right cells
Wrap Text is a cell format, so it only affects the cells that were selected when you turned it on. If you formatted one cell and then typed into the cell next to it, the second one won’t wrap. Microsoft’s steps:
- Select the cells you want to wrap. To cover a whole column, select its letter at the top.
- On the Home tab, in the Alignment group, select Wrap Text.
The button is a toggle. If it already looks highlighted for the cell you’re on, selecting it again switches wrapping off, which can make it seem as if the button does nothing. Check its state before you click it a second time. If you’re still typing in the cell, press Enter or Esc first: Excel can leave formatting buttons unavailable while a cell is in edit mode.
According to Microsoft, wrapped text fits the width of the column, and if you change the column width, the text adjusts to the new width on its own. So where the lines break depends on the column, not on where you happened to stop typing.
Fix 2: Let the row grow with AutoFit Row Height
If the text wrapped but you still see only one line, look at the row height. Excel grows the row to fit wrapped text when the row still has its automatic height. Once someone has dragged the row border or typed a value into Row Height, the row keeps that height, and the extra lines stay hidden below the border. Microsoft lists a fixed row height as one of the reasons wrapped text isn’t visible.
To hand the row height back to Excel:
- Select the row, or several rows, by their numbers on the left.
- On the Home tab, in the Cells group, select Format.
- Under Cell Size, select AutoFit Row Height.
A quicker route from Microsoft’s column and row article: double-click the boundary below the row number. To fit every row at once, select the Select All button at the top-left corner of the sheet and double-click the boundary below any row number. If you’d rather pick a size yourself, use Home > Format > Row Height and type a value, or drag the bottom border of the row until all the text shows.
There’s a ceiling. Microsoft gives 409 points as the largest row height, and row height is measured in points. A cell with a very long block of text can need more room than that, and then part of it stays out of view however you set the row. In that case, widen the column, split the text across cells, or read it in the formula bar.
Fix 3: Check for merged cells
Microsoft’s Wrap text page names merged cells as the second reason wrapped text can stay hidden. You can wrap text in a merged cell, but don’t expect AutoFit Row Height to make room for it: Microsoft’s pages don’t say that AutoFit takes merged cells into account, so the row may not grow. Two ways around it:
- Set the height by hand. Select the row and use Home > Format > Row Height, or drag the row border down until the last line shows. Recheck it if you edit the text later, since the row won’t follow the text.
- Unmerge the cells. Select the merged cell, open the arrow next to Merge & Center and choose Unmerge Cells, then wrap the text in a single cell and widen that column. For a title across several columns, Center Across Selection gives the same look without merging; Merge and Center not working in Excel shows the steps.
Fix 4: Narrow the column
Wrapped text breaks at the column’s edge. If the column is wide enough to hold the whole entry, there’s nothing to wrap, and the cell shows one line even with Wrap Text on. That’s correct behavior, but it looks like the feature failed. Make the column narrower to force a break:
- Select the column by its letter.
- Select Home > Format > Column Width, or right-click the column letter and choose Column Width.
- Type a smaller value and select OK. Microsoft explains that the width is counted in characters of the default font; the default is 8.43.
Watch out for AutoFit Column Width (or double-clicking the boundary to the right of a column letter). It sizes the column to fit its contents, so on a column of long entries it can widen the column until the text sits on one line again, which undoes the wrapping you wanted. For wrapped text, set the width yourself and leave AutoFit to the rows.
Fix 5: Clear Shrink to fit in Format Cells
The Alignment tab of the Format Cells dialog has two options next to each other under Text control: Wrap text and Shrink to fit. Shrink to fit makes the font smaller so the entry fits on one line, which works against wrapping. The Microsoft pages cited here don’t cover these options, so check the labels on your screen:
- Select the cells and press Ctrl+1 to open Format Cells, the shortcut Microsoft lists in its Excel keyboard shortcuts page.
- Open the Alignment tab.
- Under Text control, clear Shrink to fit and select Wrap text.
- While you’re there, check that Horizontal isn’t set to Fill, which repeats the entry across the cell instead of wrapping it. General or Left is fine.
- Select OK.
The same dialog holds the font options, such as strikethrough; How to strikethrough text in Excel covers that tab.
Fix 6: Add your own line breaks with Alt+Enter
Wrap Text decides where lines break based on the column width. If you want a new line at a specific point, such as between a street and a city in an address, insert a line break yourself. Microsoft’s steps:
- Double-click the cell, or select it and press F2.
- Click at the spot where the new line should start.
- Press Alt+Enter. Microsoft’s keyboard shortcuts list gives the same key for starting a new line in the same cell.
Press Enter on its own and Excel leaves the cell instead of adding a line, which is why typing a second line can seem not to work. If a cell with line breaks still shows everything on one row, turn on Wrap Text for it (Fix 1) and let the row grow (Fix 2). To take a break out again, edit the cell, put the cursor at the start of the second line and press Backspace.
Fix 7: Unprotect the sheet
On a protected sheet, Excel can block formatting changes, and Wrap Text and the row height commands may be unavailable. The Microsoft pages used for this guide don’t cover protection, so treat this as something to check rather than a documented rule. If the Review tab shows Unprotect Sheet, the sheet is protected:
- Select Review > Unprotect Sheet and type the password if there is one.
- Wrap the text and adjust the rows.
- Protect the sheet again from Review > Protect Sheet if it needs to stay protected.
If you don’t know the password, ask the person who sent the file. A workbook in Protected View won’t accept formatting until you enable editing, and changes to a read-only workbook can’t be saved to the same file; select Enable Editing if a yellow bar offers it, or see Excel file is locked for editing by another user if Excel says someone else has it open.
Text that spills over vs text that wraps
Without Wrap Text, a long entry in a cell can run across the empty cells to its right. It looks like the text is in several cells, but it all belongs to the first one. As soon as the next cell holds anything, even a space or a formula that returns an empty string, the display should stop at the cell border and the rest of the text looks cut off. Nothing is lost: select the cell and the formula bar shows the full entry.
So if text that used to show fully now looks chopped, check whether something was entered in the cell next to it. Wrapping the long cell is the fix that doesn’t depend on its neighbors. Numbers behave differently: a number that doesn’t fit can show as ##### instead of wrapping, and widening the column is the way to see it. For wrapped text that gets clipped on paper, How to print an Excel sheet on one page covers the scaling options.
Excel for the web and Excel for Mac
Excel for the web: Microsoft’s Wrap text article lists Excel for the web but gives no separate steps for it. In the browser, Wrap Text should be on the Home tab, though its position can differ from the desktop app and the row height options may be fewer. If a row won’t grow there, open the file in the desktop app, where it’s offered, and use Fix 2.
Excel for Mac: Microsoft has a separate Wrap text article for the Mac, which wasn’t read for this guide. The same causes apply (fixed row height, merged cells, a wide column), but menu names and the keyboard shortcut for a line break can differ on a Mac, so check that article for the exact keys.
Match the symptom to the fix
The causes below are possibilities to check, not a diagnosis.
| What you see | Possible cause | What to try |
|---|---|---|
| Text wraps, but only one line shows | Row height was set by hand | AutoFit Row Height (Fix 2) |
| Merged cell cuts off wrapped text | AutoFit may not resize merged rows | Set Row Height by hand, or unmerge (Fix 3) |
| Wrap Text is on, still one line | Column is wide enough for the whole entry | Narrow the column (Fix 4) |
| Text gets smaller instead of wrapping | Shrink to fit is selected | Clear it in Format Cells (Fix 5) |
| Enter jumps to the next cell | Enter alone doesn’t add a line | Press Alt+Enter (Fix 6) |
| Wrap Text button unavailable | Edit mode or a protected sheet | Press Esc, or unprotect (Fixes 1 and 7) |
Related guides
- Merge and Center not working in Excel: how to fix it
- How to strikethrough text in Excel
- How to print an Excel sheet on one page
- Excel file is locked for editing by another user: how to fix it
- Excel tips and tricks: 10 ways to work faster in Excel
Leave a Reply