Skip to content
AnIntent

How to Start a New Line in an Excel Cell (Windows, Mac and CHAR(10))

Add a line break inside one Excel cell with Alt+Enter on Windows, Control+Option+Return on Mac, or a CHAR(10) formula with Wrap Text on.

AnIntent Editorial · · 3 min read

black and silver laptop computer
Photo by Aedrian Salazar on Unsplash
In this article
  1. Add a line break on Windows with Alt+Enter
  2. Use Control+Option+Return on a Mac
  3. Excel for the web, iPhone, iPad and Android
  4. Insert a line break with a formula using CHAR(10)
  5. The formula break is invisible until you turn on Wrap Text
  6. If Alt+Enter is not working
Share this article

To start a new line in an Excel cell, put the cursor inside the cell and press Alt+Enter on Windows. On a Mac the shortcut is different, and if you build the text with a formula you need CHAR(10) plus Wrap Text. All three methods are below, along with the reason a formula line break often seems not to work.

Add a line break on Windows with Alt+Enter

These are the steps from Microsoft's support page on starting a new line inside a cell:

  1. Double-click the cell where you want the line break. You can also select the cell and press F2.
  2. Click the spot inside the text where the new line should start.
  3. Press Alt+Enter.

According to ExcelChamps, Alt+Enter turns on Wrap Text for the cell automatically, so the break shows up right away.

The key point is step 1. If you select the cell and press Alt+Enter without going into edit mode, you are not typing inside the cell, so no break is added.

Use Control+Option+Return on a Mac

Microsoft's support page has a macOS tab, and ExcelChamps gives the Mac shortcut as Control+Option+Return. Go into edit mode in the cell, place the cursor, and press that combination.

Excel for the web, iPhone, iPad and Android

Inline AI's Wrap Text guide says Excel for the web supports Alt+Enter, so the Windows steps should work in a browser.

On a phone or tablet there is no Alt key. Microsoft's support page describes these steps for the Office mobile apps:

  1. Double-tap within the cell.
  2. Tap and hold where you want the break.
  3. Tap New Line in the menu that appears.

Insert a line break with a formula using CHAR(10)

When you combine text from other cells, type CHAR(10) where the break should go. ExcelChamps gives this example, which joins A2 to C2 with each value on its own line and skips empty cells:

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

If you only need to join two cells, the same idea works with the & operator:

=A2&CHAR(10)&B2

Inline AI says TEXTJOIN is available in Microsoft 365 and Excel 2019 and later. On older versions, use the & version instead.

Use CHAR(10), not CHAR(13). ExcelChamps says CHAR(13) on its own does not break the line in current versions of Excel.

For tidying the joined text afterwards, see how to remove extra spaces with TRIM and CLEAN.

The formula break is invisible until you turn on Wrap Text

This is the most common problem. Your formula contains CHAR(10), but the cell shows everything on one line. Unlike Alt+Enter, a formula does not switch on Wrap Text for you. In ExcelChamps' CHAR(10) example, Wrap Text is applied manually.

The fix:

  1. Select the cells with the formula.
  2. Go to Home and click Wrap Text in the Alignment group, as described by Inline AI.

The breaks appear as soon as Wrap Text is on. If the row still looks cut off, the row may need to be taller to show every line.

If Alt+Enter is not working

Work through these in order:

  • You are not in edit mode. Double-click the cell or press F2 first, then place the cursor.
  • You are on a Mac. Alt+Enter is the Windows shortcut. Use Control+Option+Return.
  • You are using a formula. Keyboard breaks only apply to typed text. Use CHAR(10) and turn on Wrap Text.
  • You are on a phone or tablet. Use the tap-and-hold New Line option instead.

A note on sources: the Windows, Mac and mobile steps here come from Microsoft. The Wrap Text location and the formula details come from the independent guides linked above.

Common questions

Why does my CHAR(10) formula show everything on one line?

The cell needs Wrap Text turned on. Select it and click Home > Wrap Text in the Alignment group.

Can I use CHAR(13) instead of CHAR(10)?

ExcelChamps says CHAR(13) on its own does not break the line in current versions of Excel. Use CHAR(10).

Does Alt+Enter work in Excel for the web?

Yes, according to Inline AI's Wrap Text guide.

How do I add a new line in Excel on a phone?

Microsoft says to double-tap within the cell, tap and hold where you want the break, then tap New Line.

Which Excel versions have TEXTJOIN?

Inline AI says TEXTJOIN is in Microsoft 365 and Excel 2019 and later. On older versions, join cells with & and CHAR(10).

Hands typing on a laptop displaying a data spreadsheet
How-to

How to Use ARRAYFORMULA in Google Sheets (and When You Don't Need It)

Use ARRAYFORMULA to run one formula over whole ranges, learn when Sheets expands results without it, and what to do with MAP and LAMBDA.

· 4 min

More in Cloud & Productivity Software