Press Alt+Enter to move text to the next line inside the same cell

When you want text to wrap to a second line within a single Excel cell instead of spilling into the next cell, use Alt+Enter on Windows or Control+Option+Enter on Mac. This creates a line break inside the cell while keeping all your text in one place.

The keystroke works in any version of Excel — desktop, web, or mobile — though the exact key combination varies slightly by device. After you press the combination, your cursor moves down one line within that same cell, and anything you type appears below what you wrote before.

This is different from pressing Enter alone, which moves you to the next cell down. Alt+Enter keeps you in the same cell and just moves your text vertically within it.

Key Takeaways

  • Alt+Enter on Windows and Control+Option+Enter on Mac both create a line break inside a cell without moving to the next cell.
  • You can press the key combination multiple times in one cell to create as many lines as you need.
  • Excel automatically adjusts row height when you add a line break, but you may need to widen the column to see all your text.
  • Line breaks inside cells are saved with your spreadsheet and will appear the same way when you reopen the file.

When you need multiple lines in a single cell

You might use line breaks inside cells when you are writing instructions, notes, or descriptions that are too long to fit on one line. For example, a cell might contain an address with the street on one line and the city and state on another, or a product description split across three lines for readability.

Line breaks also help you keep related information together. Instead of spreading a single thought across multiple cells in a row, you can keep it all in one cell with internal line breaks. This makes your spreadsheet easier to read and prevents data from scattering across columns.

How to add a line break step by step

Click the cell where you want to add a line break. Type the text that will appear on the first line. When you reach the point where you want the text to move down, hold Alt and press Enter (on Windows) or hold Control and Option and press Enter (on Mac). Type the text for the second line. If you need a third line, repeat the key combination again.

Once you finish typing all your lines, press Enter alone to confirm the entry and move to the next cell. Excel will automatically make the row taller to fit all the lines you created.

Adjusting column width so all text shows

If your text disappears or appears cut off after you add a line break, the column is too narrow. Double-click the border between two column headers (the line between the letters at the top) to auto-fit the column width to your content. You can also manually drag that border to the right to make the column wider.

Row height usually adjusts on its own when you add line breaks, but if a row looks too short, you can double-click the border between two row numbers on the left side to auto-fit the row height as well.

Editing cells that already have line breaks

To edit text inside a cell that already has line breaks, double-click the cell to enter edit mode. Your cursor will appear inside the cell, and you can move between lines using the arrow keys. You can delete a line break by positioning your cursor at the end of the first line and pressing Delete, which pulls the next line up.

If you want to add another line break while editing, use the same key combination: Alt+Enter on Windows or Control+Option+Enter on Mac. When you finish editing, press Enter to confirm your changes.

Removing line breaks from cells

If you want to remove all line breaks from a cell and put the text back on a single line, double-click the cell to enter edit mode. Select all the text inside using Ctrl+A (Windows) or Command+A (Mac). Then use Find and Replace: press Ctrl+H (Windows) or Command+H (Mac) to open the Find and Replace dialog.

In the Find field, press Ctrl+J (Windows) or Command+J (Mac) to insert the line break character. Leave the Replace field empty. Click Replace All. This removes every line break in the selected cell and joins all the text into one line. You may need to widen your column afterward to see the full text.

Line breaks in formulas and imported data

If you import data from another source and it contains line breaks, Excel will preserve them. You can see these line breaks the same way you see ones you created yourself — the text wraps within the cell, and the row height expands to fit.

When you write a formula that produces text with line breaks, you can add them using the CHAR(10) function. For example, the formula =A1&CHAR(10)&B1 combines the text in cell A1, adds a line break, and then adds the text from cell B1. The result appears on two lines within a single cell.

Frequently Asked Questions

Does Alt+Enter work the same way in Excel Online?

Excel Online uses the same key combination on Windows: Alt+Enter. On Mac, use Control+Option+Enter. The line break appears when ready in the cell, and the row height adjusts automatically.

Can I copy and paste text with line breaks into Excel?

Yes. If you copy text from another program that already has line breaks, paste it into an Excel cell and the line breaks come with it. Excel recognizes the breaks and displays the text on multiple lines within the cell.

What happens to line breaks when I export my spreadsheet to another format?

Line breaks are preserved when you save as .xlsx or .xls. If you export to CSV or plain text, line breaks may cause the data to split across multiple rows instead of staying in one cell, depending on your export settings.

Can I see line breaks in a cell without opening it for editing?

Yes. If the column is wide enough and the row is tall enough, you will see the text wrapped across multiple lines within the cell. If the row is too short, the text may be hidden, but it is still there — double-click the cell to see it.