To wrap text in Excel, select the cells, go to the Home tab, and click Wrap Text in the Alignment group. The keyboard shortcut is Alt then H then W on Windows. The text now breaks onto multiple lines inside the cell instead of spilling across its neighbors, and Excel grows the row height to fit. Nothing about the underlying value changes; wrapping is purely how the cell is displayed.
This is the fix for the sheet that looks broken after a conversion. Long entries like transaction memos, item descriptions, and address lines come out of a PDF at full length, and Excel shows them running over the top of every column to their right, or chopped off at the cell border. The data is fine. The display is not.
Three ways to wrap text
| Method | How | Use it when |
|---|---|---|
| Wrap Text button | Home tab, Alignment group, Wrap Text (Alt H W) | Normal case: Excel picks the break points and sets the row height |
| Manual line break | Double click into the cell, put the cursor where you want the break, press Alt and Enter | You need the break in one exact place, like after a street address |
| Format Cells | Ctrl and 1, Alignment tab, tick Wrap text | You are setting alignment, indentation, and wrapping in one pass |
Wrap Text is a toggle. Select the cells and click it again to switch wrapping off, which is worth knowing when a converter hands you a file with wrapping already applied to columns that would read better on one line.
To wrap a whole column, click the column letter first and then apply it. That covers the rows you have and the rows you add later, which is what you want on a converted statement where the description column runs for hundreds of entries.
How do I make the row height fit the wrapped text?
Excel normally autofits the row height for you when you turn wrapping on. When it does not, the row height has been set manually at some point, and a manual height overrides autofit permanently. To hand control back, select the rows, go to Home, then Format, then AutoFit Row Height. The double click shortcut does the same thing: hover over the bottom border of the row header until the cursor turns into a double headed arrow and double click it.
The same applies to columns. Home, then Format, then AutoFit Column Width, or double click the right border of the column header. Selecting the whole sheet with Ctrl and A first and then autofitting both is the fastest cleanup on a freshly converted file, and it takes about three seconds.
Why is wrap text not working in Excel?
The most common reason wrap text appears to do nothing is that the cell is merged. Microsoft documents this directly: AutoFit does not work on a row containing cells merged across rows, or on a column containing cells merged across columns. You can switch Wrap Text on for a merged cell, and Excel will wrap the text, but it will not grow the row to reveal it, so the extra lines stay hidden behind the row border and the screen looks unchanged.
There are three other causes worth ruling out before you give up on the cell.
| Symptom | Cause | Fix |
|---|---|---|
| Wrapping is on but the text is still cut off | The cell is merged, so autofit is disabled | Unmerge, or set the row height by hand, or use Center Across Selection |
| Wrapping is on but the row never grows | The row height was set manually | Home, Format, AutoFit Row Height |
| Text is squeezed to a tiny font instead of wrapping | Shrink to fit is ticked in Format Cells | Ctrl and 1, Alignment, untick Shrink to fit, then tick Wrap text |
| Text wraps but only one line shows | The row is inside a frozen or grouped area with a fixed height | Autofit the row, or widen the column instead |
What is the alternative to merging cells if I want wrap text to work?
Use Center Across Selection. Select the cells you would have merged, press Ctrl and 1 to open Format Cells, go to the Alignment tab, and set Horizontal to Center Across Selection. The text is centered over the range and looks merged, but the cells stay separate, so autofit still works, sorting still works, and filtering still works.
This matters far beyond appearances. Merged cells break sorting with the message that all merged cells need to be the same size, and they break structured references and pivot tables. The difference between merging and Center Across Selection is the difference between a sheet you can work with and one you have to repair first. Converted PDFs are a common source of merged header bands, so it is worth checking a new file for them before you build anything on top of it.
Does wrap text change the data in the cell?
No. Wrapping is formatting, not content. The cell value is identical before and after, so formulas, sorting, filters, and lookups all behave exactly the same way. A manual line break inserted with Alt and Enter is the one exception, because it puts a real line break character into the cell, and that character travels with the value if you copy it elsewhere or export it to CSV.
That distinction matters when you are exporting. If a description field has manual line breaks in it and you save the sheet as CSV, the embedded breaks can split what should be one record across two lines in the output file. If you plan to export, wrap with the button and not with Alt and Enter. To strip existing breaks from a column, use =SUBSTITUTE(A2, CHAR(10), " ") to swap each one for a space.
Wrapping on a converted file, in the right order
Wrapping is a display fix, so it belongs near the end of cleanup rather than the start. On a file you have just pulled out of a PDF, the order that saves the most time is:
First, check the data actually landed in separate columns. If the entire row arrived in column A, wrapping will make one enormous cell instead of a readable table, and the real fix is upstream. That problem is worth solving properly, because it is the difference between a spreadsheet and a picture of one: see what to do when a PDF converts to Excel in one column.
Second, unmerge anything the converter merged, since merged cells will defeat both wrapping and autofit. Third, freeze the header row so the column labels stay visible while you scroll. Only then apply Wrap Text to the long text columns and autofit the rows.
If long memo lines are showing up mangled or spilling across columns every time, the converter is reading the text but not the table. A converter that understands table structure keeps each field in its own cell, so wrapping is cosmetic rather than a rescue operation. This is especially true of statements, where the description column is always the widest and the most fragile part of the layout, and where it pays to turn the statement into clean rows before you touch the formatting at all.
How do I wrap text in Excel on a Mac?
The Wrap Text button sits in the same place on the Home tab. The manual line break shortcut is different: use Control and Option and Enter inside the cell, rather than Alt and Enter. Autofit is under Format, then Row, then AutoFit, and double clicking the row border works the same as on Windows. Wrapping behaves identically once applied, including the merged cell limitation.
The short version
Select the cells and press Alt then H then W, or click Wrap Text on the Home tab. Excel breaks the text onto multiple lines and grows the row to fit. If nothing happens, the cell is almost certainly merged, since merged cells block autofit; unmerge them and use Center Across Selection for the same look. Use Alt and Enter only when you need a break in one specific place, and remember that break becomes part of the value.