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.
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.
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.
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.
To insert a new line inside an Excel cell, press Alt+Enter (Windows) or Control+Option+Return (Mac) while editing. For formulas, concatenate with CHAR(10). Then turn on Wrap Text from the Home ribbon so the row grows to display every line.
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.
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.
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.
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.
Press Alt+Enter while editing a cell on Windows Excel to drop the cursor to the next line inside the same cell. Works in every desktop version from 2010 to Microsoft 365, plus Excel for the Web on Windows browsers.
On macOS Excel use Control plus Option plus Return as the modern shortcut. Older Mac versions accept Option plus Return alone. A connected Windows keyboard restores Alt+Enter behaviour.
Inside a formula use the pattern A1 & CHAR(10) & B1 to glue strings with a line-feed. TEXTJOIN(CHAR(10), TRUE, range) handles many fragments and skips empty cells cleanly.
Open Find and Replace, click into Replace with, then press Ctrl+J on Windows or Control+Option+Return on Mac to insert an invisible line-feed. Replace commas or spaces in bulk.
Wrap Text alone breaks lines automatically at the column edge without storing the breaks in the cell value. Useful for short labels, but breaks shift if you resize the column.
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.
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.
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.
Alt+Enter inserts a hard line break while editing a cell. Works in Excel 2010, 2013, 2016, 2019, 2021, and Microsoft 365. Also works in Excel for the Web on Windows browsers and Chromebooks.
Control+Option+Return is the modern shortcut on Excel for Microsoft 365 Mac. Older Mac versions accept Option+Return. If a Windows keyboard is plugged in, Alt+Enter still works.
Alt+Enter on Windows browsers and Chromebooks. Control+Option+Return on Mac browsers. The web app respects pasted line breaks from external text editors like Notepad and TextEdit.
Tap into the cell, position the cursor, and tap the line-break key on the on-screen keyboard. Behaviour varies by keyboard app; Gboard and SwiftKey expose it under the Return key long-press menu.
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.
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.
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.
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.
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.
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.