How to Enter a New Line in Excel (Inside a Cell)

Pressing Enter in Excel doesn't do what most people expect. Instead of moving your cursor to the next line within the same cell, it confirms your entry and jumps you down to the next cell entirely. That's fine for data entry — but it's a problem when you need to format text, addresses, notes, or labels across multiple lines inside a single cell.

Here's exactly how line breaks work in Excel, across every major platform and version.

The Core Shortcut: Alt + Enter (Windows)

On Windows, the keyboard shortcut to insert a line break inside a cell is:

Alt + Enter

Press this while you're actively editing a cell (the cursor is inside it, not just the cell selected), and Excel inserts a manual line break at that exact position. The cell expands vertically, and your text continues on a new line within the same cell.

This works in:

• Excel for Microsoft 365 (Windows)
• Excel 2021, 2019, 2016, 2013
• Excel within Google Chrome via Microsoft 365 online (with some variation)

The Mac Equivalent: Control + Option + Return

On macOS, the shortcut is different:

Control + Option + Return

Some Mac users also report success with Command + Option + Return depending on their keyboard layout and Excel version. If one doesn't work, try the other — Mac keyboard behavior can vary slightly between MacBook and external keyboards.

How to Enter a New Line in Excel Online (Browser-Based)

Excel Online, accessed through a browser, handles this differently depending on your operating system and browser combination:

• Windows browsers: Alt + Enter usually works
• Mac browsers: Control + Option + Return or Alt + Enter may both work — behavior can be inconsistent depending on the browser intercepting keyboard shortcuts

If keyboard shortcuts fail in the browser version, a reliable workaround is to use a formula (covered below) or paste pre-formatted text.

Using a Formula to Insert Line Breaks

When you're building cell content dynamically — combining data from other cells — you can insert line breaks using the CHAR function:

• Windows: CHAR(10) represents a line break character
• Mac: CHAR(13) is sometimes used, though modern Excel for Mac also accepts CHAR(10)

Example formula:

This joins the content of A1 and B1 with a line break between them. For this to display correctly, Wrap Text must be enabled on that cell.

Common Formula Use Cases

Wrap Text: The Setting That Makes It Visible 🔧

A line break only looks like a line break if Wrap Text is turned on for that cell. Without it, the line break character exists in the cell data but the text displays as a single line (you'll see a small square symbol where the break is, or nothing at all).

To enable Wrap Text:

1. Select the cell or range
2. Go to Home tab → Alignment group → Wrap Text
3. Or right-click → Format Cells → Alignment → check "Wrap text"

Row height will adjust automatically, or you can manually resize it.

Removing Line Breaks with Find & Replace

If you've inherited a spreadsheet with unwanted line breaks, or you want to strip them out in bulk:

1. Press Ctrl + H (Windows) or Command + H (Mac) to open Find & Replace
2. In the Find what field, press Ctrl + J — this enters the line break character (it won't be visible, but it's there)
3. Leave Replace with empty (or type a space or comma)
4. Click Replace All

This is one of Excel's less obvious tricks — the Ctrl + J input is easy to miss.

Variables That Affect How This Works for You

Line breaks in Excel seem simple, but a few factors shape the actual experience:

Operating system — Windows and Mac use different shortcut keys, and the behavior in Excel Online varies further by browser.

Excel version — Older versions of Excel (pre-2013) behave the same for manual line breaks, but formula support and display rendering can differ in edge cases.

Cell formatting — If Wrap Text isn't enabled, line breaks are invisible in the display, which causes confusion. Whether your cells default to wrapped or unwrapped depends on your workbook template or existing formatting.

Formula vs. manual entry — Manually placed line breaks (Alt + Enter) and formula-generated line breaks (CHAR(10)) both insert the same character, but how you manage or remove them differs.

Shared workbooks and exports — When a file is exported to CSV, line breaks inside cells can cause parsing issues in other programs. When shared across Mac and Windows users, CHAR(10) vs. CHAR(13) differences occasionally create display inconsistencies in older software.

Google Sheets vs. Excel — If you're switching between the two, the shortcut in Google Sheets on Windows is also Ctrl + Enter, not Alt + Enter — a common source of confusion for users who work in both platforms. 📋

What "Correct" Looks Like Depends on Your Setup

The right approach — whether that's a manual Alt + Enter, a CHAR(10) formula, or a combination — depends on how your spreadsheet is structured, whether the content is static or built from other cells, what platform you're on, and whether the file moves between systems or applications. The mechanics are consistent; how they behave in your specific context is the part only you can verify by testing in your actual workbook.