Press Alt+Enter to break text into multiple lines within one cell

When you need text to wrap to a second or third line inside 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 within the cell while keeping all the text in one place. The cell automatically expands vertically to show all the lines you create.

This is different from pressing Enter alone, which moves you to the next cell down. Alt+Enter stays inside the cell and moves your cursor to the next line within it.

Key Takeaways

  • Alt+Enter (Windows) or Control+Option+Enter (Mac) creates a line break inside a cell without moving to the next cell.
  • The cell height expands automatically to fit multiple lines, but column width stays the same unless you adjust it.
  • You can use line breaks in any cell type — text, numbers formatted as text, or formulas that produce text.
  • Turning on text wrapping makes the cell easier to read but does not create line breaks; Alt+Enter does both.

Step-by-step: Creating a line break in a cell

Click the cell where you want the line break. Type the first part of your text. At the point where you want the new line to start, hold Alt and press Enter (on Windows), or hold Control+Option and press Enter (on Mac). Type the rest of your text. Press Enter when you are done to confirm the entry and move to the next cell.

If you are editing a cell you already filled, double-click it to enter edit mode, position your cursor where you want the break, and use the same key combination. The cell will expand to show both lines as soon as you press the key combination.

The difference between line breaks and text wrapping

Text wrapping automatically breaks long text across multiple lines based on the column width. You turn it on through the Format menu (Format > Cells > Alignment tab, then check "Wrap text"). Text wrapping is useful when you have a narrow column and do not want to manually decide where each line ends.

Line breaks created with Alt+Enter let you choose exactly where each line starts and stops. You control the layout. A cell can have both — you can create manual line breaks with Alt+Enter and also turn on text wrapping so that any remaining text that does not fit wraps automatically.

Text wrapping alone does not create visible line breaks in the cell; it just makes text flow across multiple lines based on space. If you want to force a break at a specific word, Alt+Enter is the tool to use.

When to use line breaks in a cell

Line breaks work well for lists or instructions that belong in one cell. For example, a cell containing shipping instructions might read "Ship to warehouse" on the first line and "Hold for pickup" on the second. A cell with contact details might have a name on one line and a phone number on the next.

They are also useful in headers or labels where you want to save column width. Instead of making a column very wide to fit "Quarterly Sales Report Q1 2024" on one line, you can break it into two or three lines within the same cell and keep the column narrower.

Line breaks are less useful when you plan to sort or filter the data. Sorting treats the entire cell as one unit regardless of how many lines it contains, so the line breaks themselves do not affect the sort order — but they can make the data harder to read while sorting is happening.

Editing and removing line breaks

To edit a cell with line breaks, double-click it to enter edit mode. Use the arrow keys to move between lines. Position your cursor at the end of a line and press Delete to remove the line break and pull the next line up, or position it at the start of a line and press Backspace to remove the break before it.

To remove all line breaks from a cell at once, you can use Find & Replace. Press Ctrl+H (Windows) or Command+H (Mac) to open Find & Replace. 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. This removes every line break in the selected cells.

Line breaks in formulas and imported data

If you are building a formula that produces text across multiple lines, use the CHAR(10) function to insert a line break. For example, the formula =A1&CHAR(10)&B1 combines the contents of cells A1 and B1 with a line break between them. The cell must have text wrapping turned on to display the break visually.

When you import data from another program, line breaks sometimes come along as CHAR(10) characters. Excel displays them as line breaks if the cell has text wrapping on. If you see strange symbols or the text does not break where expected, check whether text wrapping is enabled and whether the imported data contains hidden line break characters.

Troubleshooting line breaks that do not appear

If you create a line break with Alt+Enter but do not see it in the cell, the most common reason is that text wrapping is off. Turn it on by selecting the cell, opening the Format menu, choosing Cells, clicking the Alignment tab, and checking "Wrap text". The line break will become visible when ready.

Another reason line breaks may not show is that the column is too wide and the text fits on one line anyway. Narrow the column to see the break, or accept that the text will display on one line if there is room. Line breaks are still there in the cell data even if they are not visible on screen.

Frequently Asked Questions

Can I use line breaks in a cell that contains a formula?

Yes. If the formula produces text, you can use CHAR(10) inside the formula to create a line break. For example, =IF(A1>100,"Over limit"&CHAR(10)&"Review needed","OK") will show "Over limit" on one line and "Review needed" on the next if A1 is greater than 100. The cell must have text wrapping on to display the break.

What happens to line breaks when I copy and paste a cell?

Line breaks copy along with the text. When you paste the cell, the line breaks stay in place. If the destination cell does not have text wrapping on, the breaks will not be visible until you turn wrapping on.

Can I see line breaks in the formula bar?

Yes. When you click a cell with line breaks and look at the formula bar at the top, you will see the text with small gaps where the line breaks are. The formula bar does not display them as actual line breaks, but you can see where they are.

Do line breaks affect how Excel sorts or filters data?

No. Excel treats the entire cell content as one unit when sorting or filtering, regardless of line breaks. The breaks do not change the sort order. However, line breaks can make data harder to read while you are working with it.