How to Wrap Text in Excel: Ribbon, Shortcut and Line Breaks

Q: How do I add a line break with a formula instead of Alt+Enter?

Concatenate with CHAR(10) between elements, for example A2 with CHAR(10) and B2, and make sure Wrap Text is on for that cell. For a range of values, use TEXTJOIN with CHAR(10) as the delimiter and TRUE to skip blanks.

By Dr. Zubair Khalid, DVM, MS, PhD · 2026-10-30

How to Wrap Text in Excel: Ribbon, Shortcut and Line Breaks

To wrap text in Excel, select the cells and click Wrap Text in the Alignment group on the Home tab, or press Alt, then H, then W on a Windows keyboard. To force a line break at a specific point inside one cell, press Alt+Enter while you are editing that cell.

Those two commands feel similar and behave very differently. Wrap Text is a display setting that changes how a value is drawn on screen. Alt+Enter inserts a real character into the value itself. Mixing them up is the root of most "wrap text not working" complaints, and it is the reason a spreadsheet can look perfect on one monitor and fall apart the moment the data is copied, sorted, exported, or read by another program.

This guide covers the ribbon, the keyboard routes, the Mac equivalents, manual line breaks, autofit row height, and the specific conditions under which wrapping silently stops working. It also covers where wrapping belongs in a clean data workflow and where it does not.

What Wrap Text Actually Does

Wrap Text is cell formatting, not a data operation. When you switch it on, Excel keeps the underlying value as one unbroken string and simply draws that string across multiple visual lines inside the cell boundary. The column width stays the same. The row gets taller if Excel is allowed to size it.

Because it is formatting, three consequences follow immediately.

First, the value does not change. If a cell contains a 180-character product description, =LEN(A1) still returns 180 after you wrap it. Copy that cell into Notepad and you get one long line, not four short ones.

Second, wrapping is stored with the cell, not with the file's text content. Closing and reopening the workbook preserves it. Copying the cell into a plain text editor strips it.

Third, wrapping is only visible if the row is tall enough. Excel's default row height is 15 points (about 20 pixels) at the default 11-point Calibri setting. Text that wraps to four lines needs roughly four times that height. Excel will grow the row automatically only while the row is still in its "auto" state. The moment anyone drags a row boundary, that row is pinned to a fixed height and will clip wrapped text from then on. That single behavior explains most of the troubleshooting cases below.

Excel breaks wrapped lines at spaces and at hyphens. It does not hyphenate long words. A single 60-character token with no spaces will be forced onto one visual line and will either spill into the next column (if that column is empty) or be cut off at the cell edge.

There are three separate tools that people describe as "wrapping," and keeping them straight makes everything else easier:

Wrap Text is a toggle in the Alignment group. It changes display only.
Alt+Enter inserts a line feed character (CHAR(10)) into the value. It changes the data.
Autofit Row Height controls whether the row is allowed to grow to fit whatever is displayed.

How to Wrap Text in Excel Using the Ribbon

The ribbon route is the one most people learn first and the one that survives best across Excel versions, Excel for Mac, and Excel for the web.

Select the cell, the range, or the entire column you want to format. Click the column header letter to grab a whole column, or press Ctrl+A once to select the current data region.
Open the Home tab.
Find the Alignment group, roughly in the middle of the ribbon.
Click Wrap Text. The button stays highlighted while the setting is active for the selected cells.

Wrap Text is a toggle, not a one-way switch. Clicking it a second time turns wrapping off and the text collapses back to a single line.

For finer control, press Ctrl+1 to open the Format Cells dialog, go to the Alignment tab, and tick the Wrap text checkbox. That dialog is also where you set vertical alignment to Top, which is worth doing whenever a row holds several lines. Bottom-aligned wrapped text tends to leave visible gaps above the first line and looks misaligned next to neighboring cells.

On Excel for Mac, the same button sits in the Alignment group of the Home tab. On Excel for the web, it is under Home, then Alignment. The Format Cells route works in all three.

One practical note on ranges: applying Wrap Text to an entire column formats empty cells too. That is usually harmless and often convenient, because text typed into those cells later wraps automatically. It does add formatting weight to the file, so on very large sheets it is cleaner to format only the used range.

The Excel Wrap Text Shortcut and Other Keyboard Routes

Excel does not ship with a single dedicated key combination for Wrap Text. There is no Ctrl+W shortcut for it, and Ctrl+W actually closes the workbook, which surprises people who guess. The fastest built-in keyboard route uses ribbon key tips, a two-step sequence that Microsoft documents as part of the standard Excel keyboard interface.

The Alt, H, W sequence

Press Alt on a Windows keyboard. Small letters appear over the ribbon tabs.
Press H to open the Home tab.
Press W to activate Wrap Text.

The full sequence is written as Alt+H, W. You can hold Alt and tap H then W in quick succession, or press each key separately. Select your range first, then run the sequence, and every selected cell gets the format.

To unwrap, run the same sequence again on the same selection.

Putting Wrap Text on the Quick Access Toolbar

If you toggle wrapping dozens of times a day, give it a permanent key. Right-click the Wrap Text button and choose Add to Quick Access Toolbar. A small icon appears in the toolbar at the top left of the window next to the Save button. Press Alt and Excel shows a number beside each Quick Access Toolbar icon. That number becomes your shortcut, for example Alt+4 if Wrap Text is the fourth item. The position depends on what else you have added, so check the number once and it stays fixed.

Autofit row height by keyboard

Wrapped text that is still clipped usually needs a row height fix. The keyboard path is Alt, then H, then O, then A, which maps to Home, Format, AutoFit Row Height. Select the rows first.

Mac equivalents

Excel for Mac does not provide a dependable single-key route to Wrap Text. Use the ribbon button, the Format Cells dialog (Command+1), or add the command to the Quick Access Toolbar and reach it from there. The Mac shortcut for a manual line break inside a cell is different from Windows, and that is covered in the next section.

The VBA one-liners

For repeatable cleanup on large workbooks, two lines do the job:

Selection.WrapText = True applies the format to whatever is selected.
Selection.EntireRow.AutoFit resizes the rows to fit.

Run them in that order. Reversing them autofits rows before the wrapping exists, which produces a row sized for one line of text.

Line Breaks in an Excel Cell: Alt+Enter

A manual line break is the only way to control exactly where a wrapped line ends. It is also the only one of the three tools that changes the stored value.

What Alt+Enter inserts

With a cell in edit mode (double-click it, or select it and press F2), place the cursor where you want the break and press Alt+Enter on Windows. Excel inserts a line feed character, which you can reference in formulas as CHAR(10). The cell automatically switches Wrap Text on as part of that action.

On Excel for Mac, the equivalent is Control+Option+Return. On keyboards without a numeric keypad, the Windows combination still works normally because Enter is a main key.

The character is real data. It travels with the cell through copy and paste, it appears when the cell is exported to CSV (inside quoted fields), it shows up in the formula bar as an invisible break, and it can break exact-match lookups. If a VLOOKUP fails on two values that look identical, a stray CHAR(10) is a common culprit.

Telling the two line-break characters apart

Windows text files use a carriage return plus line feed pair. Cells pasted from those sources can contain CHAR(13) and CHAR(10) together. Excel's own Alt+Enter produces CHAR(10) alone. When imported text refuses to wrap cleanly, normalize both:

=SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),""),CHAR(10)," ")

That formula collapses the break into a space. Swap the space for CHAR(10) if you want to standardize on a single line feed.

Building line breaks with formulas

A break produced by a formula displays as a break only when Wrap Text is enabled on that cell. Build a two-line address label with:

=A2&CHAR(10)&B2&CHAR(10)&C2

For a whole range, TEXTJOIN is cleaner:

=TEXTJOIN(CHAR(10),TRUE,A2:A6)

The TRUE argument skips empty cells, which prevents blank lines in the middle of a stacked label.

Removing line breaks

Two approaches work. For one-off cleanup, select the range, press Ctrl+H, click in the Find what box, and press Ctrl+J. That inserts a line feed character into the search box, which looks like nothing but is genuinely there. Leave Replace with empty or type a space, then choose Replace All.

For a formula-driven fix, =SUBSTITUTE(A1,CHAR(10)," ") targets only line feeds. =CLEAN(A1) also strips them, but it removes all nonprinting characters below code 32, which can delete other things you meant to keep.

Autofit Row Height and Why Wrapped Text Needs It

Wrapping and row height are a pair. Turn on wrapping without letting the row resize and you get clipped text, a truncated display, and the mistaken impression that the feature is broken.

Three ways to autofit rows:

Mouse: select the rows, then double-click the boundary line between any two row headers in the selection. Excel sizes every selected row to fit its tallest wrapped content.
Ribbon: Home, then Format, then AutoFit Row Height.
Keyboard: Alt, H, O, A.

A subtle point about the mouse method: double-clicking the row boundary also returns that row to automatic sizing, which means it will keep adjusting as content changes. Dragging the boundary instead pins a fixed height. If wrapped text stops growing after you dragged a row taller once, double-click the boundary to release the pin.

Known limits and exceptions:

Merged cells never autofit. Excel cannot calculate the height needed for a merged range, so wrapped text inside a merge stays clipped. The workaround is to unmerge, or to size the row manually and accept that it will not track content changes.
Row height caps at 409 points. That fits roughly 27 lines of 11-point text. Text requiring more than that is cut off no matter what you do, and the fix is a wider column or less text per cell.
Column width caps at 255 characters. Extremely wide columns are possible but rarely readable.
A single cell holds at most 32,767 characters. Anything longer has to be split across cells or stored elsewhere.
Shrink to fit overrides wrapping. If the Shrink to fit checkbox is ticked in Format Cells, Excel reduces font size instead of growing the row. The two settings fight, and Shrink to fit wins visually.

The order of operations that produces clean results is: set column widths first, apply Wrap Text second, autofit row heights last.

Wrap Text Not Working in Excel: A Diagnostic Checklist

When the button is on and the text still looks wrong, run through this list in order. The first three cover the large majority of cases.

The row height is fixed. Hover over the row boundary. If the cursor shows a resize arrow rather than a double-arrow with a divider, drag or double-click to reset it to automatic.
The cells are merged. Wrapped text in a merged range does not expand the row. Unmerge with Home, then Merge and Center, then reapply wrapping.
Shrink to fit is ticked. Open Format Cells (Ctrl+1), Alignment tab, and clear the checkbox.
You are still inside the cell in edit mode. The ribbon button is unavailable while the cursor is active inside a cell. Press Enter or Esc first.
The sheet is protected. Protection blocks formatting changes. Review, then Unprotect Sheet, apply the format, then re-protect.
The workbook opened in Protected View or Read-Only. A yellow bar at the top explains it. Choose Enable Editing.
The column is extremely narrow. Wrapped text in a two-character-wide column stacks one or two letters per line. Widen the column.
Text sits in a text box or shape, not a cell. Shape text has its own wrapping controls and does not respond to the Home tab button.
Text was pasted from a web page with hard line breaks already in it. The value contains CHAR(10) characters that force breaks at odd positions. Strip them and rewrap.
The wrapped range is fine on screen but clipped in print. Check the print area, page scaling, and whether the row heights are set to autofit before printing.

Quick Reference: Choosing the Right Tool

Tool	Where it lives	What it changes	Best use
Wrap Text (ribbon)	Home, Alignment group	Display format only	Headers, labels, and any range where the value must stay clean
Alt+H, W	Keyboard sequence, Windows	Display format only	Fast toggling across many cells without leaving the keyboard
Quick Access Toolbar button	Top-left toolbar	Display format only	Repeated use in a working session
Alt+Enter (Control+Option+Return on Mac)	Inside cell edit mode	The stored value, inserts CHAR(10)	Addresses, stacked labels, deliberate multi-line text you control
CHAR(10) in a formula	Formula bar	The calculated result	Combining fields into a multi-line label
AutoFit Row Height (Alt+H, O, A)	Home, Format	Row sizing behavior	Making wrapped text fully visible and keeping it visible as content changes
Format Cells, Alignment tab	Ctrl+1	All alignment and text control settings	When you need wrap, vertical alignment, and shrink settings in one place

Using Wrapping Well in a Real Data Workflow

Wrapping is a presentation tool. Treat it that way and it never causes trouble.

Keep raw data sheets unwrapped and free of Alt+Enter breaks. A column of clean, single-line values sorts predictably, filters predictably, and imports cleanly into Power Query, R, Python, or a database. A column salted with invisible line feeds causes duplicate-looking records, failed joins, and export files that some tools read as extra rows.

Do the wrapping on a presentation sheet. Duplicate the tab, apply column widths, wrap the header row, set vertical alignment to Top, then autofit row heights. The source data remains untouched and the report looks polished.

Plan for header height. Wrapped headers commonly need two or three lines. When autofit runs, the header row becomes 45 to 60 points tall. If that row is frozen, it eats a noticeable slice of the visible window on a laptop screen. Shorten header text where possible rather than accepting four-line headers.

Watch pivot tables. Wrapping applied inside a pivot table can be lost or reverted when the pivot refreshes or the layout changes. Apply formatting, then test a refresh before you send the file.

Test before exporting to PDF. Wrapped text prints exactly as displayed, so a row that clips on screen clips in the PDF. Autofit rows, then use Print Preview to confirm nothing is cut at the page boundary.

Expect wrapping to affect on-screen width. A wrapped cell in the rightmost column still draws inside its own column boundary. Long text will not spill into empty space to the right once wrapping is on.

Common Mistakes and Limitations

Using Alt+Enter in source data. This is the most damaging habit on the list. The line breaks become part of the values and quietly break exact-match lookups, deduplication, and text parsing. Reserve Alt+Enter for labels and final reports.

Assuming wrap text shortens the value. It does not. A 300-character cell still holds 300 characters and still exports as one long field.

Dragging a row and forgetting. A dragged row height is fixed forever. Wrapped text added later will be clipped, and the user concludes that wrapping is broken.

Wrapping merged cells and expecting growth. Merges and autofit do not cooperate. If a merged header must wrap, size the row manually and check it after every content change.

Combining Wrap Text with Shrink to fit. They compete for the same space. Pick one.

Centering wrapped text vertically. Multi-line text reads best at the top of the row. Vertical centering leaves awkward gaps and misaligns adjacent cells.

Wrapping the last column of a data table. The text has nowhere to grow and the column edge cuts it. Insert a spare column or reduce the text.

Forgetting that formatting does not travel. Copy a wrapped cell into an email or a plain text file and the line breaks vanish. Copy a cell with Alt+Enter breaks and the breaks travel. The asymmetry surprises people in both directions.

Ignoring the 409-point ceiling. On dense report sheets, a row that needs more than about 27 lines of text will clip no matter how many times you autofit. Widen the column or split the text.

Frequently Asked Questions

What is the shortcut for wrap text in Excel?

There is no default single-key shortcut, but the ribbon key sequence Alt, then H, then W toggles Wrap Text on Windows. Select the cells first, then run the sequence, and run it again to turn wrapping off.

How do I insert a line break inside an Excel cell?

Press Alt+Enter while editing the cell on Windows, or Control+Option+Return on a Mac. Excel inserts a line feed character and switches Wrap Text on for that cell automatically.

Why is wrap text not working in my spreadsheet?

The most common causes are a row height that was manually fixed, a merged cell range, or the Shrink to fit option being enabled. Reset the row height by double-clicking the row boundary, unmerge if needed, and clear Shrink to fit in the Format Cells dialog.

Does wrapping text change the cell value?

No. Wrap Text is a display format. The stored string is unchanged, LEN returns the same number, and copying the cell into a plain text editor produces a single line.

How do I remove line breaks from cells?

Use Ctrl+H, click in the Find what box, press Ctrl+J to insert a line feed character, then Replace All with a space or nothing. In a formula, =SUBSTITUTE(A1,CHAR(10)," ") removes only line feeds.

How do I autofit row heights for wrapped text?

Select the rows and use Home, then Format, then AutoFit Row Height, or press Alt, H, O, A. Double-clicking the boundary between two row headers does the same thing and also returns the rows to automatic sizing.

Can I wrap text in a merged cell?

The format applies and the text displays on multiple lines, but the row does not grow to fit it. Merged ranges cannot autofit, so you must set the row height manually and recheck it whenever the content changes.

How do I add a line break with a formula instead of Alt+Enter?

Concatenate with CHAR(10) between elements, for example =A2&CHAR(10)&B2, and make sure Wrap Text is on for that cell. For a range of values, use =TEXTJOIN(CHAR(10),TRUE,A2:A6).