How to Go to Next Line in Excel (Within a Cell): Complete Guide

Why Enter Doesn't Add a New Line in Excel

Hitting Enter in Excel moves you to the next cell, not the next line. That trips up almost every spreadsheet user the first time they try to write an address, a multi-line note, or stack bullet points inside one cell. The good news is Excel does support line breaks inside a single cell. You just need the right shortcut for your operating system, plus a quick understanding of how Wrap Text controls whether those breaks actually show up.

This guide walks you through every reliable way to add a new line inside an Excel cell. We cover Windows shortcuts, Mac shortcuts, the Wrap Text button, the CHAR(10) formula method for combining text from multiple cells, and even how to handle line breaks when importing or exporting CSV files. By the end, you'll know exactly which method fits your situation, and you'll stop fighting Excel every time you need a clean, readable multi-line cell.

Whether you're prepping for an Excel skills test, building a customer database, or just trying to format a quick memo, the difference between a polished spreadsheet and a messy one often comes down to small formatting tricks like this one. Excel was designed for tabular data first, so the program assumes a single piece of information per cell. But real-world data — addresses, notes, comments, bullet lists — often needs multiple lines packed into one place. Once you learn the proper shortcuts, this becomes second nature.

Let's start with the fastest method most people need: the Alt+Enter shortcut on Windows. Then we cover Mac equivalents, the often-missed Wrap Text setting, formula-based line breaks with CHAR(10), and a full troubleshooting walkthrough for when things don't behave the way you expect.

Method 1: Alt+Enter on Windows (Fastest)

On any Windows version of Excel, the universal shortcut for a line break inside a cell is Alt+Enter. The sequence is simple but the order matters. First, double-click the cell to enter edit mode, or click the cell once and press F2. You should see a blinking text cursor inside the cell. Without that cursor, Alt+Enter does nothing — that's the single most common reason people think the shortcut is broken.

Once you're in edit mode, position your cursor at the exact spot where you want the new line to start. Hold the Alt key down and tap Enter. The cursor jumps to the next visible line inside the cell. Type your next line of text. When you're completely finished, press Enter on its own (no Alt). That commits your multi-line content and moves the active cell selection down.

That's it. The cell expands vertically to show both lines, assuming Wrap Text is on. If the cell doesn't expand and you see a strange square symbol where the break should be, Wrap Text is turned off — we fix that in Method 3. The Alt+Enter trick works the same in Excel 2010, 2013, 2016, 2019, 2021, Microsoft 365, and Excel for Windows on Surface devices.

It also works inside the formula bar at the top of the screen, so you can use it when writing long IF statements that you want to read across multiple lines without changing what the formula actually does.

Method 2: Mac Shortcuts for Excel Line Breaks

Mac keyboards don't have an Alt key in the same place, and the shortcut has shifted between Excel versions over the years. In Excel for Mac 2016 and later, including the Microsoft 365 subscription version, press Control+Option+Return while editing a cell. The Option key on a Mac is the equivalent of the Alt key on Windows, but you need the Control key alongside it on Excel for Mac.

If you're still running Excel for Mac 2011 (rare these days but it exists in some offices), the shortcut is Control+Command+Return. On many newer builds, the simpler Option+Return combo also works without the Control key — try that first if Control+Option+Return feels awkward to your hand. The result is identical: a true line break character inserted inside the cell at the cursor position.

If you swapped keyboard layouts or you're using a Windows keyboard plugged into a Mac, the Alt key maps to Option and the Return key maps to Enter. So Alt+Enter on a Windows keyboard connected to a MacBook gives you the same line break behavior as the native Mac shortcut. If none of those combinations produce a line break on your Mac, open Excel → Preferences → Edit and confirm "After pressing Enter, move selection" is enabled. Some macOS shortcut conflicts (especially with text expander or window manager apps) intercept the keystroke before Excel sees it.

Method 3: Turn On Wrap Text So Line Breaks Show

Here's where most people get stuck. You press Alt+Enter, you type your second line, you press Enter to confirm — and the cell looks like one squashed string with a weird square symbol in the middle. That means Wrap Text is off. The line break character is in the underlying data, but Excel collapses it visually because the row height is too short to display more than one line. The data is fine. The display is the problem.

To fix it, click the cell (or select the whole column if you want every cell to wrap). Go to the Home tab on the ribbon. Find the Alignment group in the middle of the ribbon. Click the Wrap Text button — it has tiny arrows pointing down. The row instantly expands to show your line break, and the square symbol vanishes, replaced by the actual text from your second line.

Alternatively, press Ctrl+1 (Cmd+1 on Mac) to open the Format Cells dialog. Click the Alignment tab and check the box labeled "Wrap text." Both routes do the same thing — they flip the same setting under the hood. Once Wrap Text is on for a cell, every line break you add with Alt+Enter shows immediately, and the row auto-adjusts its height as you add more lines. For an entire column, click the column letter header before clicking Wrap Text — that applies the setting to every cell in that column at once, including future cells.

Method 4: CHAR(10) Formula for Combining Cells With Line Breaks

What if you have data in multiple cells and you want to merge them into one cell with a line break between each piece? That's where CHAR(10) comes in. CHAR(10) is the Excel function for the line feed character — the same invisible character that Alt+Enter inserts behind the scenes. The number 10 refers to the ASCII code for line feed; CHAR(13) is carriage return, which some older Mac builds prefer.

Say you have first name in A2, last name in B2, and city in C2. To combine them into D2 with each item on its own line, use the ampersand concatenation operator: =A2 & CHAR(10) & B2 & CHAR(10) & C2. The ampersand glues strings together and CHAR(10) injects the line break between each one. Press Enter and the formula evaluates, but you'll still see one squashed line until Wrap Text is on for D2.

For a cleaner approach with three or more cells, use TEXTJOIN: =TEXTJOIN(CHAR(10), TRUE, A2, B2, C2). TEXTJOIN takes a separator (CHAR(10) here), a TRUE/FALSE flag for whether to skip empty cells (TRUE = skip empties), and then any number of cells or ranges to combine. TEXTJOIN was added in Excel 2016 and is available in Excel for Mac, Microsoft 365, and Excel for the Web. It's far cleaner than chaining a dozen ampersands.

Important: after you enter the formula, the result still looks like one line until you turn on Wrap Text for the destination cell. CHAR(10) only inserts the line break character — Wrap Text is what makes it visually wrap. On a Mac, some older builds use CHAR(13) instead of CHAR(10). If CHAR(10) doesn't produce a visible break on Mac after enabling Wrap Text, swap to CHAR(13). Modern Microsoft 365 Mac builds have standardized on CHAR(10), matching Windows.

Method 5: Find and Replace to Add or Remove Line Breaks in Bulk

If you imported data that has all the line breaks in the wrong place — or you need to add line breaks to a whole column at once — use Find and Replace with the special character code. This is a power-user trick that saves hours when you're cleaning up imported customer lists or pasted web content.

To remove all line breaks: select the cells you want to clean up. Press Ctrl+H to open Find and Replace. Click inside the "Find what" box and press Ctrl+J — the box looks empty but a hidden line break character is now in it. Leave "Replace with" empty if you want them gone entirely, or type a space if you want a space in place of each line break. Click Replace All. Excel reports how many replacements it made and your cells consolidate to single lines.

To replace a specific character with a line break, reverse the trick: type the character (like a comma or pipe) in "Find what" and press Ctrl+J in "Replace with." Now every comma in your selection becomes a line break. Don't forget to turn on Wrap Text afterward so the new breaks display correctly. This is how power users convert single-line addresses (comma-separated) into properly stacked address blocks in just a few clicks.

On a Mac, the equivalent is Control+Option+Return inside the Find and Replace dialog, though some builds require you to actually paste a line break character copied from another cell. If Ctrl+J doesn't seem to do anything on your Mac, copy a single Alt+Enter character from a working cell, then paste it into the Find or Replace box — that works as a fallback in any Excel version.

Why Pressing Enter Goes to the Next Cell (and How to Change It)

By default, pressing Enter in Excel commits your edit and moves the selection to the cell below. That's the behavior built into the program from day one. If you'd rather have Enter not move at all — useful when you're entering long multi-line content and want full control of the active cell — you can change the setting permanently.

Go to File → Options (on Mac: Excel → Preferences). Click Advanced in the left pane. Find the section "Editing options" near the top. Uncheck "After pressing Enter, move selection" — or change the Direction dropdown to Right, Up, or Left if you prefer Enter to move sideways. Click OK to save.

Now Enter just commits your edit and keeps the active cell where it was. You can still use Tab to move right and arrow keys to navigate. This is a setting many heavy spreadsheet users prefer because it removes one source of accidental data entry in the wrong row. It's especially useful for data validation workflows where you're entering long notes and want to stay on the row to verify formatting before moving on.

Note this Enter-direction setting is separate from Alt+Enter behavior — Alt+Enter always inserts a line break regardless of how the plain Enter is configured. So you can disable Enter's cell movement entirely and still use Alt+Enter exactly the same way for line breaks. The two settings live in different parts of the Excel options panel and don't interact.

Fixing Common Line Break Problems in Excel

Line breaks are simple in theory but they generate a surprising number of "why doesn't this work" moments. Here are the most common issues users run into and how to fix them quickly. Save this section as your troubleshooting cheat sheet.

Problem 1: Alt+Enter does nothing. You're probably not in edit mode. Press F2 first, or double-click the cell so you see the blinking cursor inside. Single-clicking a cell selects it but doesn't put you in edit mode. This catches new users almost every time, and even experienced users who switch keyboards or workflows.

Problem 2: Line break shows as a square box. Wrap Text is off. Turn it on from the Home tab. The square box (sometimes shown as a vertical bar) is Excel's way of saying there's a line break here but I can't display it because the row is too short. Once Wrap Text flips on, the box disappears and the second line slides into view.

Problem 3: Row height doesn't expand even with Wrap Text on. The row is set to a fixed height. Right-click the row number on the left, choose Row Height → AutoFit Row Height, or use Home → Format → AutoFit Row Height. Now the row grows to fit your wrapped content automatically. If you want this behavior for every row, select the whole sheet first by clicking the corner triangle.

Problem 4: CHAR(10) shows literal text instead of a break. You probably typed CHAR(10) as text. Make sure your formula starts with an equals sign and CHAR(10) is not inside quotation marks. Also confirm Wrap Text is on for the destination cell. A common mistake is typing ="A2 CHAR(10) B2" instead of =A2&CHAR(10)&B2 — the first is a literal string, the second is a real formula.

Problem 5: Pasted data has line breaks in weird places. If you copied from a web page or PDF, paste using Paste Special → Values (Ctrl+Alt+V then V). Then use Find and Replace with Ctrl+J to clean up unwanted breaks. For pasting with line breaks preserved into one cell, double-click the destination cell first so you paste into edit mode rather than across multiple cells.

Problem 6: Line breaks disappear when sharing as PDF or printing. They shouldn't — but if they do, check that the row height is set to AutoFit and Wrap Text is enabled before exporting. Some legacy PDF printers truncate row content if the height was manually fixed. Print Preview is the quick check: if it looks right there, it'll look right in the PDF.

Problem 7: Line breaks copy out of Excel as nothing when pasted to Word or email. The receiving application may not honor CHAR(10) line breaks. Copy the cell content, paste into Word, and if breaks are lost, use Word's Find and Replace to swap `^l` (manual line break) into the right spots. Or use Notepad as a quick converter — Notepad preserves Excel line breaks well.

Putting It All Together: A Practical Workflow

Here's how to combine everything in a real spreadsheet. Suppose you're building a customer list with name, email, and address all in one cell per row for a clean printable directory that you can share with the sales team.

Open a fresh worksheet. Set column A width to about 35 characters so it can hold an address comfortably without forcing weird mid-word breaks. Select column A by clicking the column letter at the top, then click Wrap Text on the Home tab. Select all the rows by clicking the corner triangle, right-click a row number, choose Row Height → AutoFit Row Height. Now your sheet is ready to handle multi-line content cleanly.

Click A1, press F2 to enter edit mode, type the customer name, press Alt+Enter. Type the email address, press Alt+Enter. Type the street address, press Alt+Enter. Type the city, state, and ZIP, then press Enter to commit and move to A2. Repeat for each customer — or use Ctrl+D after typing one row to copy the formatting downward for batch entry.

If you need to import customer data from a different source where each piece is in its own column, switch to the formula approach. Put name in B, email in C, street in D, city in E. In column A, use =TEXTJOIN(CHAR(10), TRUE, B2, C2, D2, E2) for the first row. Drag the formula handle down to copy it to every other row. Make sure column A has Wrap Text on and AutoFit Row Height applied, and you have a clean, formula-driven multi-line directory that updates automatically as you edit the source columns.

That single combination — Alt+Enter for manual entry, CHAR(10) inside TEXTJOIN for formulas, Wrap Text for display, and AutoFit Row Height for clean rows — covers virtually every Excel line break scenario you'll ever encounter. Master those four pieces and the days of fighting with multi-line cells are over. Practice them on a few real spreadsheets, then test your Excel skills with the linked practice questions to lock the whole workflow into muscle memory. Once it's automatic, you'll wonder how you ever lived without knowing the Alt+Enter trick.