LearnExcel.io
Menu

How to Hit Enter Within a Cell in Excel

Written by ··Updated June 14, 2026
How to Hit Enter Within a Cell in Excel

To hit Enter within a cell in Excel and start a new line without leaving the cell, press Alt + Enter on Windows or Ctrl + Option + Return (or Control + Option + Enter) on a Mac. This inserts a manual line break at the cursor, moving your text to the next line inside the same cell instead of completing the entry and jumping to the cell below.

That single shortcut solves the most common version of the problem, but there are several ways to put a line break in a cell depending on whether you’re typing by hand, wrapping long text automatically, or building the text with a formula. This guide covers every method for Windows, Mac, and Excel for the web, plus troubleshooting for when the shortcut doesn’t seem to work.

Why the Enter Key Doesn’t Add a New Line by Default

By design, the Enter key in Excel commits the cell entry and moves the selection to the next cell down. This is intentional — it lets you type a value, press Enter, and keep entering data quickly down a column. The downside is that you can’t simply press Enter to start a second line of text inside the same cell the way you would in Word or a text editor.

To get a true in-cell line break, you have to tell Excel “new line here, but don’t finish the cell yet.” That’s exactly what the Alt + Enter shortcut does.

Method 1: Alt + Enter (Windows) or Ctrl + Option + Return (Mac)

This is the fastest, most reliable way to add a new line in a cell while you’re typing.

  1. Double-click the cell (or select it and press F2) to enter edit mode.
  2. Click to place your cursor exactly where you want the line to break.
  3. Press the keyboard shortcut for your platform (see the table below).
  4. Continue typing — the text appears on a new line inside the same cell.
  5. Press Enter normally when you’re finished to commit the entry.

New Line Shortcut by Platform

PlatformShortcutNotes
Excel for WindowsAlt + EnterWorks in all desktop versions
Excel for MacCtrl + Option + ReturnAlso written as Control + Option + Enter
Excel for Mac (alternate)Command (⌘) + Option + ReturnWorks in newer Mac builds
Excel for the webAlt + EnterUse the desktop app for full reliability

When you add a manual line break this way, Excel automatically turns on Wrap Text for that cell so the second line is visible. If your rows don’t grow to show the extra lines, see the troubleshooting section below.

Method 2: Wrap Text for Long Entries

If you don’t need the break at a specific spot — you just want long text to flow onto multiple lines so it all fits — use Wrap Text instead. This doesn’t insert a manual break; it lets Excel wrap the text at the cell’s edge automatically.

  1. Select the cell or range you want to wrap.
  2. Go to the Home tab.
  3. In the Alignment group, click Wrap Text.

The text now displays on as many lines as needed within the column’s current width, and the row height grows to fit. If you later widen the column, the text re-flows automatically. For a deeper walkthrough, see our guides on wrapping text in Excel cells and using the Text Wrap feature.

Wrap Text and Alt + Enter work well together: use Wrap Text for automatic flow, and add Alt + Enter manual breaks where you want a guaranteed new paragraph, such as an address block.

Method 3: Add a Line Break With a Formula (CHAR(10))

When your text is built by a formula — for example, joining a name and an address from separate columns — you can’t press Alt + Enter. Instead, insert the line-break character using CHAR(10), which is the code for a line feed.

=A2 & CHAR(10) & B2

Or with the cleaner TEXTJOIN approach, which skips empty cells:

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

For the line breaks to actually show, the result cell must have Wrap Text turned on (Method 2). Without it, the CHAR(10) is still there but renders as a single line. Learn more in our guides to the CHAR function, the CONCATENATE function, and the TEXTJOIN function.

Mac note: Excel for Mac historically used CHAR(13) (carriage return) for in-cell breaks, but CHAR(10) works on modern Excel for Mac too. If a break won’t appear, try CHAR(13) as a fallback.

Method 4: Force Wrap Text via Format Cells

You can also enable wrapping through the Format Cells dialog, which is handy when you’re already adjusting alignment or formatting a range.

  1. Select the cells.
  2. Press Ctrl + 1 (Windows) or ⌘ + 1 (Mac) to open Format Cells.
  3. Click the Alignment tab.
  4. Check the Wrap text box.
  5. Click OK.

From there, Alt + Enter line breaks and long-text wrapping will both display correctly in the selected cells.

Troubleshooting: When the New Line Won’t Appear

A line break can be present but invisible if the row or column settings hide it. Run through these fixes:

The Row Is Too Short

If you typed a break but only see one line, the row height may be fixed. Select the row, then on the Home tab choose Format → AutoFit Row Height, or double-click the boundary below the row number. Row height should expand to reveal every line.

Wrap Text Is Off

A manual Alt + Enter break needs Wrap Text enabled to be visible. Re-select the cell and confirm Wrap Text is highlighted on the Home tab, or check the box in Format Cells (Method 4).

The Column Squeezes the Text

If wrapped text looks cramped or cuts off, widen the column or use AutoFit column width — select the column and double-click its right border, or use Format → AutoFit Column Width. See our full guide to adjusting column width.

The Break Came From Imported Data

Text pasted from the web or other apps sometimes carries stray line breaks. To strip them out, use Find and Replace (Ctrl + H), put your cursor in the Find box, and press Ctrl + J to enter the line-break character, then leave Replace empty and click Replace All. Our Find and Replace guide covers this trick in detail. You can also clean text formula-side with the SUBSTITUTE function or remove extra spaces with the TRIM function.

In-Cell New Lines vs. Merging Cells

People sometimes reach for Merge Cells when they really want multiple lines of text in one cell. They solve different problems:

  • New line within a cell (Alt + Enter) keeps everything in a single cell — best for addresses, notes, and labels.
  • Merging cells combines several adjacent cells into one larger cell — best for headers spanning columns, but it can break sorting and formulas.

If you only need stacked lines of text, stick with Alt + Enter. If you do need to merge, see merging cells in Excel and how to merge cells without losing data. For more on getting several lines into one cell, our guide to making multiple lines in one cell and creating a new line in an Excel cell go further.

Quick Reference Recap

GoalWhat to do
New line while typing (Windows)Alt + Enter
New line while typing (Mac)Ctrl + Option + Return
Long text flows onto multiple linesTurn on Wrap Text (Home tab)
Line break inside a formulaCHAR(10) + Wrap Text
Break won’t showAutoFit row height + enable Wrap Text
Remove unwanted breaksFind & Replace with Ctrl + J

Frequently Asked Questions

How do I hit Enter within a cell in Excel?

Double-click the cell to start editing, place your cursor where you want the break, and press Alt + Enter on Windows or Ctrl + Option + Return on a Mac. This adds a new line inside the cell instead of moving to the next cell. Press the normal Enter key when you’re done to commit the entry.

How do I add a new line in a cell without leaving the cell?

Use Alt + Enter (Windows) or Ctrl + Option + Return (Mac) while in edit mode. Pressing plain Enter would leave the cell and move down, but the modifier key tells Excel to insert a line break and keep you in the same cell. For step-by-step help, see starting a new line in an Excel cell.

Why doesn’t pressing Enter create a new line in my cell?

By default, the Enter key commits the entry and moves to the cell below — that’s expected behavior, not a bug. To get an in-cell line break you must use Alt + Enter (Windows) or Ctrl + Option + Return (Mac). If you’ve used the right shortcut but still see one line, the row is probably too short or Wrap Text is off; AutoFit the row height and confirm Wrap Text is enabled.

What is the Mac shortcut for a new line inside a cell?

On Excel for Mac, press Ctrl + Option + Return (also written Control + Option + Enter). On newer Mac builds, ⌘ (Command) + Option + Return also works. See entering a new line in Excel for more.

How do I add a line break inside an Excel formula?

Use CHAR(10) as the line-break character and concatenate it into your text, for example =A2 & CHAR(10) & B2 or =TEXTJOIN(CHAR(10), TRUE, A2, B2). The result cell must have Wrap Text turned on for the breaks to display. Our CHAR function guide explains the character codes in detail.

How do I remove line breaks from a cell?

Open Find and Replace with Ctrl + H, click in the Find what box, press Ctrl + J to insert the invisible line-break character, leave Replace with empty, and click Replace All. Alternatively, use the SUBSTITUTE function with CHAR(10) to swap breaks for spaces or nothing.

Related guides

How To

How to Hit Enter in Excel

Learn how to hit enter in Excel and streamline your workflow! With this simple technique, you can quickly add information to your cells without disrupting your work.

May 20, 2023

How To

How to Enter in Excel

Learn how to enter data effectively in Microsoft Excel. This guide covers the basics of data entry, including best practices for formatting, entering numbers and text, and using shortcuts to streamline your workflow.

May 20, 2023

View all Excel Basics and General Knowledge guides →