The simplest way to add a line break in Excel

To move text to a new line within the same cell, hold Alt and press Enter on Windows, or hold Control and press Enter on Mac. The cursor will jump to a new line inside that cell instead of moving to the next cell down. When you press Enter alone, Excel moves you to the next cell — but Alt+Enter (or Control+Enter on Mac) keeps you in the same cell and wraps the text.

This works in any version of Excel on desktop. The cell automatically expands in height to show both lines, and the text stays in one cell rather than spilling into the next column. You can add as many line breaks as you need by repeating the same key combination.

Key Takeaways

  • Press Alt+Enter on Windows or Control+Enter on Mac to create a line break inside a cell without moving to the next cell.
  • The cell height expands automatically to display all the text you've added, so you don't have to resize it manually.
  • Line breaks stay within a single cell, which keeps your data organized when you need multiple lines of information in one location.
  • You can copy and paste cells with line breaks, and the breaks will move with the text to the new location.
  • If you later delete the line break, the text flows back into a single line unless you manually add spaces or punctuation.

When you need line breaks in a cell

Line breaks are useful when you have a long note, address, or description that belongs in one cell but reads better on multiple lines. For example, a mailing address with street, city, and state on separate lines stays together in one cell instead of spreading across three rows. A product description or customer note can be easier to read when broken into shorter lines rather than one long paragraph.

Without line breaks, the text either gets cut off at the cell edge (if the column is narrow) or forces the column wider than you want. Line breaks let you control exactly where the text wraps without changing the column width for the entire spreadsheet.

How to edit or remove a line break

To edit text with a line break, double-click the cell to enter edit mode. You'll see the cursor blinking in the text. Use the arrow keys to move to the line break, then press Delete or Backspace to remove it. The two lines will merge back into one.

If you want to add a line break to existing text, position the cursor where you want the break and use Alt+Enter (Windows) or Control+Enter (Mac) just as you would when creating new text. You can also select and delete part of the text, then add a line break in a different spot.

Line breaks and copying cells

When you copy a cell that contains a line break, the line break travels with it. If you paste that cell elsewhere in the spreadsheet or into another file, the text will appear on multiple lines in the new location as well. This makes it straightforward to duplicate formatted entries without losing the structure.

If you copy the cell and paste it as values only (using Paste Special), the line breaks are preserved. However, if you paste into a program that doesn't support line breaks — like some text editors or older software — the line break may appear as a special character or disappear entirely.

What happens when you print or export

Line breaks show up correctly when you print a spreadsheet. Excel expands the row height to fit all the text, so nothing gets cut off on the printed page. The cell boundaries remain visible, and the text appears on multiple lines within that cell.

When you save the file as a PDF, line breaks are preserved and the text prints exactly as it appears on screen. If you export to CSV (comma-separated values) format, line breaks are usually kept but may be enclosed in quotation marks to preserve them during the export. When you open that CSV file in Excel again, the line breaks will be there.

Troubleshooting line breaks that don't work

If Alt+Enter doesn't create a line break, you may be in a cell that's locked or protected. Check whether the sheet has protection turned on — if it does, you won't be able to edit the cell content at all. Ask whoever set up the sheet to unprotect it, or unprotect it yourself if you have the password.

On Mac, make sure you're using Control+Enter, not Command+Enter. Command+Enter has a different function in Excel. If Control+Enter still doesn't work, check your keyboard settings to see whether another program is intercepting that key combination.

If the cell is formatted as text rather than as a general or number format, line breaks may not display correctly. Right-click the cell, select Format Cells, and change the format from Text to General or Number. Then try adding the line break again.

Frequently Asked Questions

Can I see where the line break is without entering edit mode?

No, line breaks are invisible until you double-click the cell to edit it. Once you're in edit mode, you'll see the cursor move to a new line when you navigate through the text. The cell itself just appears taller to accommodate the extra lines.

What's the difference between a line break and wrapping text?

A line break (Alt+Enter) is a hard break you place exactly where you want it. Text wrapping is automatic — it breaks the text whenever it reaches the edge of the column. Wrapping changes if you resize the column, but line breaks stay in the same place no matter how wide or narrow the column becomes.

Will line breaks work in Excel Online?

Excel Online supports line breaks, but the keyboard shortcut is different. Use Ctrl+Enter on Windows or Control+Enter on Mac in the web version as well. The process is the same — the cell expands to show the multiple lines.

Can I undo a line break if I added it by mistake?

Yes, press Ctrl+Z (Windows) or Command+Z (Mac) when ready after adding the line break to undo it. If you've already moved to another cell, double-click the cell with the unwanted line break, position your cursor at the break, and press Delete or Backspace to remove it manually.