The simplest way: Alt+Enter on Windows, Control+Option+Enter on Mac

To add a line break inside an Excel cell without moving to the next cell, hold Alt and press Enter (on Windows), or hold Control and Option and press Enter (on Mac). The cursor will drop to a new line within that same cell. Type your next line of text, and it stays in the cell.

This works whether you are typing new text or editing text that is already in the cell. Double-click the cell to enter edit mode, position your cursor where you want the break, then use the keyboard shortcut. When you press Enter alone (without the modifier keys), Excel saves the cell and moves down — that is the difference.

The text will wrap automatically if the column is narrow enough, but the line break you created with Alt+Enter stays there even if you widen the column later. This matters if you are building a template that other people will use and you want the breaks to stay in a specific place.

Key Takeaways

  • Alt+Enter (Windows) or Control+Option+Enter (Mac) creates a line break inside a cell without moving to the next row.
  • You must be in edit mode — either typing new text or double-clicking an existing cell — for the shortcut to work.
  • Pressing Enter alone saves the cell and moves down; the modifier keys are what keep you inside the same cell.
  • Cells with manual line breaks need "Wrap Text" turned on in the Format menu to display all lines, or they will be cut off on screen.

Turning on Wrap Text so the lines actually show

If you add a line break but the second line does not appear on screen, the cell has Wrap Text turned off. Select the cell, go to the Home tab, find the Wrap Text button (it looks like text with an arrow), and click it. The cell will expand vertically to show all the text.

Wrap Text is separate from the line break itself. You can have a line break in a cell and Wrap Text off — the break is there, but you will not see it unless you click into the cell to edit it. Turning Wrap Text on makes the cell tall enough to display everything at once.

If you have many cells with line breaks, select all of them at once, then turn on Wrap Text for the whole group. Click the first cell, hold Shift, and click the last cell in the range you want to format. Then click Wrap Text once, and it applies to all of them.

Why the row height matters

Even with Wrap Text on, if the row is set to a fixed height that is too short, the text will be cut off. Excel normally sets row height to auto, which means it grows to fit the content. But if someone has manually set the row to a specific height, you may need to adjust it.

Double-click the line between two row numbers on the left side of the spreadsheet to auto-fit the height to the content. Or right-click the row number, select Row Height, and type a larger number. A typical row is about 15 points tall; text with a line break usually needs 30 points or more depending on the font size.

Using CHAR(10) in a formula if you need line breaks in calculated text

If you are building a formula that combines text from other cells and you want a line break in the result, use CHAR(10) as the break character. For example, =A1&CHAR(10)&B1 will put the contents of A1 on the first line and B1 on the second line, all in one cell.

The formula result will still need Wrap Text turned on to display both lines. CHAR(10) is the line break character that Excel recognizes in formulas. It is different from typing Alt+Enter, but it does the same thing — it tells Excel to move to the next line within the cell.

This is useful when you are pulling data from other sources and need to format it for readability. For instance, if you have a first name in column A and a last name in column B, you could use =A1&CHAR(10)&B1 to stack them vertically in a single cell.

What happens when you copy or move a cell with line breaks

Line breaks stay with the cell when you copy and paste it. If you copy a cell that has Alt+Enter breaks in it and paste it elsewhere, the breaks come along. The same is true if you cut and move the cell — the line breaks are part of the cell content.

If you paste into a cell that already has Wrap Text off, the breaks are still there, but you will not see them until you turn Wrap Text on. The breaks themselves are invisible characters, so they travel with the data.

Removing line breaks if you need to undo them

To remove a line break, double-click the cell to enter edit mode, position your cursor right before or after the break, and press Delete or Backspace to remove it. The line break is just a character, so you delete it the same way you would delete any other character.

If you have many cells with line breaks and want to remove all of them at once, use Find & Replace. Press Ctrl+H (Windows) or Command+H (Mac) to open Find & Replace. In the Find field, press Ctrl+J (Windows) or Control+J (Mac) to insert a line break character. Leave the Replace field empty and click Replace All. This removes all line breaks in the selected range.

Line breaks and sorting or filtering

Excel will sort and filter cells with line breaks the same way it handles any other text — by the first line. If you have a cell with "John" on the first line and "Doe" on the second, Excel sees it as starting with "John" for sorting purposes. The line break does not affect how the data is organized.

This matters if you are using line breaks for formatting in a data table. The breaks are visual only and do not change how Excel treats the content for calculations, sorting, or filtering.

Frequently Asked Questions

Why does Alt+Enter not work in my cell?

You are probably not in edit mode. Double-click the cell first to enter edit mode, or press F2. Then position your cursor where you want the break and use Alt+Enter. If you just click the cell once and press Alt+Enter, nothing happens because Excel thinks you are trying to do something else.

Can I add a line break in a cell header or title?

Yes, the same method works. Double-click the cell, position your cursor, and press Alt+Enter (Windows) or Control+Option+Enter (Mac). Make sure Wrap Text is on so the header displays on multiple lines instead of being cut off.

What if I want to remove all line breaks from a column at once?

Use Find & Replace. Press Ctrl+H (Windows) or Command+H (Mac), then press Ctrl+J (Windows) or Control+J (Mac) in the Find field to insert a line break character. Leave Replace empty and click Replace All. This removes every line break in the selected range in one step.

Do line breaks affect how Excel calculates or counts data?

No. Line breaks are formatting only. If a cell contains "apple" on one line and "orange" on another, Excel still sees it as text and treats it the same way in formulas, counts, and calculations as it would if both words were on one line.

Can I see line breaks when I print the spreadsheet?

Yes, if Wrap Text is on and the row height is set to auto or manually increased, the line breaks will print. If Wrap Text is off or the row is too short, the second line will not print either. Preview your print before sending it to make sure the formatting looks right.