Excel New Line in Cell: Add Line Breaks With Alt+Enter, CHAR(10), and Wrap Text

You typed a long sentence into A1, hit Enter expecting the cursor to drop to a second line, and instead it jumped to A2. Welcome to one of the most quietly frustrating habits in Microsoft Excel. The Enter key is hard-wired to confirm the cell and move on, which is great for data entry and miserable for anyone who wants address blocks, bullet lists, or wrapped notes to sit inside a single cell. There is a fix. Actually there are five, and they all behave a little differently.

This guide walks through every reliable way to put a new line in an Excel cell across Windows, macOS, the web app, and even inside formulas. You will see the keyboard shortcuts, the CHAR(10) trick, the wrap text toggle, and the small gotchas that ruin a perfectly good spreadsheet when you copy it into Word or send it to a colleague on a different platform.

Why Enter Will Not Break a Line By Default

Excel treats the Enter key as a commit. When you press it, the current cell value is written and the active selection moves down (or sideways, depending on your settings). This behaviour is intentional. Spreadsheets are grids, and most of the time you want to fly through rows of data without lifting your hands. The trade-off is that you need a separate signal to tell Excel insert a line break here, but stay inside the cell I am editing.

That signal is a modifier key. On Windows it is Alt. On a Mac it is Control plus Option, or in some versions just Option alone. In formulas, the signal is the character code 10, which is Excel's way of writing a line-feed without typing a key at all. Once you know which signal to use for the situation in front of you, the headache disappears.

The other piece of the puzzle is wrap text. Even after you insert a line break, Excel might hide it behind the cell border. The line is still there in the underlying value, but the cell is rendered on one row of pixels. Turning on wrap text tells Excel to grow the row height so every line shows.

Method 1: Alt+Enter on Windows (the Default Move)

This is the shortcut every Excel power user reaches for first. Click into the cell, start typing, and when you reach the spot where you want the next line to begin, hold Alt and press Enter. The cursor drops down inside the cell. Keep typing. Press Enter (without Alt) when you are done to commit the value.

1. Double-click the cell, or press F2 to enter edit mode.
2. Type the first part of your text.
3. Hold Alt and tap Enter to insert a line break.
4. Type the next line and repeat as needed.
5. Press Enter or Tab to confirm the cell.

The first time you do this, the row will probably stay the same height and only the last line will show. That is the wrap-text issue mentioned earlier. Click the cell, go to the Home tab, and tap the Wrap Text button in the Alignment group. The row grows to fit every line and you finally see what you typed.

One quirk: if you paste a value from somewhere else that already contains line breaks, Excel might paste it on one row. Toggle wrap text on the destination cell and the lines snap into place. The breaks were always there; you just could not see them.

Method 2: Control+Option+Return on macOS

Mac keyboards do not have an Alt key. They have Option, and Excel for Mac uses a slightly different combination depending on the version you are running.

• Excel for Microsoft 365 (Mac): Control + Option + Return
• Older Excel for Mac (2016 and earlier): Control + Option + Return, or Option + Return
• Excel on a Mac with a Windows keyboard plugged in: Alt + Enter still works

If one combination does not break the line, try the other. The behaviour can also depend on whether Excel is running natively or through Rosetta on Apple Silicon. The fix is the same once the break appears: turn on Wrap Text from the Home ribbon, or press Command + 1 to open Format Cells and tick the Wrap text checkbox under the Alignment tab.

Method 3: Alt+Enter in Excel for the Web

Excel Online inherits the Windows shortcut. Alt + Enter inserts a line break inside the active cell. On a Chromebook the same combination works because Chrome maps Alt to Alt. On a Mac browser, you may need to use Control + Option + Return, the same as the desktop Mac app. The web version sometimes lags by a frame or two; if the break does not appear immediately, give it a beat before pressing the keys again.

Wrap text in Excel for the web lives in the same place: Home tab, Alignment group. The web version also respects line breaks pasted in from outside, so if you build the text in Notepad or TextEdit and paste it into Excel Online, the breaks survive the trip.

Method 4: CHAR(10) Inside a Formula

When the cell value is the result of a formula, Alt+Enter is useless. You cannot put a key press inside a function. Instead you concatenate the text with the character code for line-feed, which is 10 on Windows and macOS in modern Excel. The classic example is joining a name and address into one cell.

Suppose A2 contains "Acme Corporation", B2 contains "123 Main Street", and C2 contains "Springfield, IL". The formula:

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

returns the three values stacked. Modern Excel also gives you TEXTJOIN, which is cleaner when you have many fragments:

=TEXTJOIN(CHAR(10), TRUE, A2, B2, C2)

The second argument, TRUE, tells TEXTJOIN to skip empty cells. That matters for address blocks where line 2 might be optional. Without it, you get a blank line in the middle of the address. With it, the layout stays tight regardless of which fields are filled.

Here is the gotcha: the formula returns the line-feed character, but the cell still needs wrap text turned on to render the breaks visually. If you build a formula like the one above and the result shows up as one long string with little square boxes between the pieces, that is the line-feed displayed as a glyph because wrapping is off. Toggle wrap text and the boxes disappear.

Method 5: Format Cells > Wrap Text (Automatic Line Breaks)

If you do not care where the lines break, only that the cell shows everything, the wrap text toggle alone is enough. Excel automatically inserts soft line breaks at the right edge of the column. The breaks are not stored in the cell value; they are purely visual. Resize the column and the wrap points shift to match the new width.

Soft wraps are different from the hard breaks inserted by Alt+Enter or CHAR(10). A hard break stays in the same spot no matter how wide the column gets. A soft break floats with the column. Most users want a mix: hard breaks at logical points like paragraphs or sections, and soft wraps for everything else.

To turn on wrap text for a range, select the cells, press Command + 1 (Mac) or Control + 1 (Windows) to open Format Cells, click the Alignment tab, and tick Wrap text. Click OK. Excel grows the row heights to fit. If a row stays cramped, double-click the row border in the header to force AutoFit, or right-click the row number and choose Row Height to set it manually. For deeper control over alignment and overflow, the how to wrap text in excel walkthrough has a full ribbon-by-ribbon breakdown.

Find and Replace: Convert Commas or Spaces Into Line Breaks

You inherited a sheet where addresses live in one cell separated by commas, and you need them stacked. Manually editing every cell would take an hour. Find and Replace can do it in five seconds.

1. Select the column or range you want to fix.
2. Press Control + H (Windows) or Command + H (Mac) to open Find and Replace.
3. In the Find what field, type the comma plus space (or whatever your separator is).
4. Click into the Replace with field. Hold Control and press J (Windows) or Control + Option + Return (Mac). Nothing visible happens, but a line-feed character is now in the field.
5. Click Replace All.

Every separator turns into a line break. Turn on Wrap Text afterwards and the addresses stack neatly. The Ctrl+J shortcut is one of those tricks that experienced Excel users hoard because it almost never appears in documentation. If you ever need to use find and replace tricks for bulk cleanups, this is the most useful one.

Removing Line Breaks From a Cell

Sometimes the problem runs the other way. You pulled data from a website, and every cell has random line breaks that wreck your VLOOKUPs. Two options.

For a quick visual cleanup, use SUBSTITUTE in a helper column:

=SUBSTITUTE(A2, CHAR(10), " ")

That replaces every line-feed with a space. Copy the helper column, paste as values over the original, and delete the helper. For pure deletion, replace CHAR(10) with an empty string:

=SUBSTITUTE(A2, CHAR(10), "")

You can also use Find and Replace the same way you inserted breaks. Open Find and Replace, click into Find what, press Control + J to insert the line-feed character, leave Replace with empty (or type a space), and click Replace All. The lines collapse. For larger cleanups involving stray characters, the remove spaces in excel guide covers TRIM, CLEAN, and Find/Replace patterns that pair well with line-break removal.

Why CHAR(13) and CHAR(10) Are Not the Same

This trips up anyone who works with files coming from older systems or mainframe exports. There are two line-ending characters in the ASCII table.

• CHAR(10) is the line-feed character (LF). Excel uses this for in-cell line breaks on every platform.
• CHAR(13) is the carriage return (CR). Old Mac systems and some legacy data sources use it.
• CHAR(13) & CHAR(10) is the Windows convention for line breaks in text files (CRLF).

Inside an Excel cell, only CHAR(10) renders correctly. If you import a CSV and the cells look like they have weird characters at the end of every line, the file probably uses CRLF and Excel did not strip the CR. Run a Find and Replace targeting the CR character and leave Replace with empty. Cleaner option: open the file in a text editor that can convert line endings, save as LF-only, and reopen in Excel.

For a deeper look at how Excel handles the Return key in different edit modes, the enter in excel cell companion guide covers the keystroke logic in detail.

Practical Examples That Use Line Breaks

Beyond pretty addresses, in-cell line breaks open up a few useful patterns.

Multi-line headers. A wide column with a long title can be shortened by breaking the header into two or three short lines. The column itself stays narrow, the header still reads cleanly, and you free up screen real estate. Set the row height tall enough, turn on wrap text, and Alt+Enter the words into a stack.

Comments inside a cell. Sometimes a number needs a one-line annotation that travels with it. Type the value, Alt+Enter, then the note. The cell sorts and filters on the whole value, but the human reading it sees the explanation right there. Useful in budgets and forecasts where line-item notes matter.

Dynamic invoice blocks. Combine TEXTJOIN with IF to build invoice address blocks where optional lines (Apartment number, Country) only appear when they exist. The CHAR(10) glue keeps the layout tight and the IF logic decides whether each line is included. The same pattern works for customer profiles, shipping labels, and any dataset where presence is variable.

Bullet lists. Excel does not have native bullets inside a cell, but you can fake them. Insert a bullet character (Alt + 7 on the numeric keypad, or paste from Word), follow it with the line text, Alt+Enter, and repeat. The cell looks like a tiny list. It is not pretty for long content, but for a three-point status update next to a project name, it works.

When Line Breaks Cause Problems

Hard line breaks inside cells can also break things downstream. A few traps to watch.

VLOOKUP and XLOOKUP match on the entire cell value, including any line-feed characters. If your lookup column has stray line breaks, the function returns #N/A even when the visible text matches. Use SUBSTITUTE to clean lookup keys before comparing, or wrap your lookups in TRIM and CLEAN to scrub whitespace and non-printable characters.

CSV exports treat line-feed inside a cell as a row delimiter if the cell is not properly quoted. Excel does quote them correctly when you Save As CSV, but some third-party export tools do not. The result is a CSV that opens with broken rows. Test the round-trip before relying on it.

Pasting a multi-line cell into Word, Outlook, or another spreadsheet sometimes splits the content across multiple lines or cells, depending on the paste target. Word usually handles it gracefully. Google Sheets imports the breaks but ignores wrap text settings unless you turn wrap on manually. Outlook strips the breaks if you paste as plain text. Paste as HTML or RTF to keep them.

One More Trick: Concatenate With a Visible Separator and Then Wrap

If you do not want the maintenance overhead of CHAR(10), you can build the combined value with a comma or pipe separator, and rely on wrap text to break the line at the column edge. The line breaks will not land in the same place every time, but for short labels and tags the result is acceptable. Use this when readability is the goal rather than precise layout.

For example, =A2 & ", " & B2 & ", " & C2 with wrap text on gives a soft-wrapped result. Narrow the column and the breaks shift. Widen the column and the text returns to one line. It is the simplest version of the same idea, and sometimes that is what you need.