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

To move text to a new line within the same cell, press Alt+Enter on Windows or Control+Option+Enter on Mac while you are typing or editing. The cursor jumps to the next line inside that cell instead of moving to the next cell down. Excel automatically wraps the text so both lines stay visible.

This works whether you are entering 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, and press the key combination. When you press Enter alone, the cell saves and you move down — but Alt+Enter keeps you in the same cell and creates the line break.

Key Takeaways

  • Alt+Enter (Windows) or Control+Option+Enter (Mac) creates a line break inside a cell without moving to the next cell.
  • You must turn on text wrapping in the cell format for the line break to display properly instead of hiding behind the cell border.
  • Line breaks work in any cell type and stay in place when you copy, paste, or sort the spreadsheet.
  • If a line break does not show, check the row height — Excel may have set it too short to display both lines.

Enabling text wrapping so the line break actually shows

A line break does nothing if the cell is not set to wrap text. Without wrapping, the second line exists in the cell but stays hidden because the row is not tall enough to show it. To turn on wrapping, select the cell or cells you want to wrap, then go to the Home tab and click the Wrap Text button in the Alignment group.

You can also right-click the cell, choose Format Cells, go to the Alignment tab, and check the box next to "Wrap text". Either method does the same thing. Once wrapping is on, Excel automatically makes the row taller to fit all the text, and both lines become visible.

Adjusting row height when text still does not fit

Sometimes Excel does not make the row tall enough on its own, especially if you have multiple line breaks in one cell. You can manually adjust the row height by clicking and dragging the border between row numbers on the left side of the spreadsheet. Drag down to make the row taller, and all the text in that row becomes visible.

Alternatively, double-click that same border and Excel auto-fits the row to the tallest content in it. This is faster than dragging if you have several rows to adjust. The row height change affects the entire row, so all cells in that row become taller — not just the one with the line break.

Using line breaks in formulas and pasted text

If you are building text inside a formula, use the CHAR(10) function to create a line break. For example, =A1&CHAR(10)&B1 combines the text from cells A1 and B1 with a line break between them. The cell must still have text wrapping turned on for the break to show.

When you paste text from another program like Word or a web page, line breaks sometimes come along automatically. If they do not show, turn on text wrapping for that cell. If you paste text and see strange characters instead of line breaks, the source used a different line break format — you may need to use Find and Replace to clean it up, or re-type the content in Excel.

Removing line breaks from a cell

To remove a line break, double-click the cell to enter edit mode, position your cursor right before or after the line break, and press Delete or Backspace to remove it. You are deleting the line break character itself, not the text on either side.

If you need to remove line breaks from many cells at once, use Find and Replace. Press Ctrl+H (Windows) or Command+H (Mac) to open Find and Replace, then in the Find field, press Ctrl+J (Windows) or Command+J (Mac) to insert a line break character. Leave the Replace field empty and click Replace All. Excel removes all line breaks in the selected range.

When line breaks cause problems with sorting and filtering

Line breaks usually do not interfere with sorting or filtering, but they can make data harder to read when you are scanning a column. A cell with a line break takes up more vertical space, so your spreadsheet becomes taller and you see fewer rows at once. If readability is the issue, consider using separate columns instead — one column for the first line of text and another for the second.

If you are exporting the spreadsheet to another program or format, line breaks sometimes do not transfer correctly. CSV files, for example, can break when they contain line breaks inside cells. Test your export before relying on it, and if line breaks cause problems, replace them with a separator like a comma or semicolon that your other program can read.

Frequently Asked Questions

What if Alt+Enter does not work?

Make sure you are in edit mode by double-clicking the cell first. If you press Alt+Enter while the cell is selected but not being edited, nothing happens. Also check that you are using the correct key combination for your operating system — Windows uses Alt+Enter, and Mac uses Control+Option+Enter (not Command).

Can I see where the line breaks are in my spreadsheet?

Not easily in the normal view. If you need to find cells with line breaks, use Find and Replace (Ctrl+H or Command+H), search for a line break by pressing Ctrl+J or Command+J in the Find field, and click Find All. Excel highlights every cell that contains a line break.

Does a line break count as a character in a cell?

Yes. The CHAR(10) function counts as one character, and it takes up space in the cell's character limit. This rarely matters in practice because Excel cells can hold thousands of characters, but it is worth knowing if you are working with very long text strings or using formulas that count characters.

What happens to line breaks when I copy a cell to another sheet?

Line breaks copy along with the text. When you paste the cell into another sheet, the line break stays in place. The new cell must also have text wrapping turned on to display the break, or it will be hidden the same way it would be in the original sheet.