The simplest way: press Alt+Enter while typing

To add a line break inside an Excel cell without moving to the next cell, hold Alt and press Enter. This works while you are typing in the cell or while you are editing text that is already there. The cursor jumps to the next line within that same cell, and Excel keeps all the text together as one entry.

This is different from pressing Enter alone, which confirms your entry and moves you down to the next cell. Alt+Enter tells Excel "I want another line here, but stay in this cell." The text wraps to fit the column width, and you can add as many line breaks as you need.

Key Takeaways

  • Press Alt+Enter to create a line break inside a cell while you are typing or editing.
  • Turn on text wrapping in the Format menu so multi-line cells display properly instead of cutting off text.
  • You can use the CHAR(10) function in formulas to insert line breaks automatically when combining text from other cells.
  • Make rows taller manually or use auto-fit to see all the text in cells that contain multiple lines.

Making sure your multi-line text actually shows up

Adding a line break does not automatically make Excel display all the text. If your cell looks like it is cutting off text, you need to turn on text wrapping. Click the cell or select multiple cells, then go to the Home tab, find the Alignment group, and click Wrap Text.

Once wrapping is on, Excel adjusts the row height automatically on some versions, but not all. If the text still does not show, click between two row numbers on the left side and drag down to make the row taller. Or double-click the line between row numbers and Excel will auto-fit the height to fit whatever is inside.

Using formulas to add line breaks automatically

If you are combining text from multiple cells using a formula, you can insert a line break using CHAR(10). For example, if cell A1 contains a first name and B1 contains a last name, the formula =A1&CHAR(10)&B1 puts the first name on one line and the last name on the next line within the same cell.

This is useful when you are building text from data in other places and want the result to display on multiple lines. Remember that the cell still needs text wrapping turned on to show the line break. Without wrapping, the formula creates the break in the data, but Excel will not display it visually.

Editing text that already has line breaks

To edit text inside a cell that already has line breaks, double-click the cell to enter edit mode. The cursor appears inside the cell, and you can navigate with arrow keys. Use the up and down arrows to move between lines, and Alt+Enter again to add more breaks or delete them by positioning your cursor at a line break and pressing Delete.

If you click in the formula bar at the top instead of double-clicking the cell, you can also edit the text there. Alt+Enter works in the formula bar too, so you can add or remove line breaks from either location.

Differences between Excel versions

Alt+Enter works the same way in Excel for Windows, Excel for Mac, and Excel Online. On Mac, you may need to press Control+Option+Enter instead, depending on your keyboard layout. Google Sheets uses Ctrl+Enter on Windows and Command+Enter on Mac, so if you switch between tools, the keyboard shortcut changes.

Text wrapping and the CHAR(10) function work across all versions. The menu locations might differ slightly in older versions of Excel, but the feature itself is standard.

When line breaks make sense and when they do not

Line breaks inside cells work well for notes, addresses, or any text that naturally belongs together but reads better on separate lines. They keep related information in one cell instead of spreading it across multiple columns or rows. However, if you are trying to sort or filter data, line breaks can make that harder because Excel treats the whole cell as one entry.

For structured data like names, dates, or numbers, separate columns are usually clearer. Use line breaks when the information is descriptive or when you want to keep things visually grouped. If you later need to split that text back into separate cells, you can use the Text to Columns feature under the Data tab, though it requires some setup.

Frequently Asked Questions

Why does Alt+Enter not work when I press it?

On Windows, make sure you are holding Alt while pressing Enter, not pressing them separately. On Mac, try Control+Option+Enter instead. If neither works, check whether you are in edit mode — double-click the cell first, then try the shortcut. Some keyboard layouts or programs running in the background can interfere with the shortcut.

Can I remove a line break without deleting the text?

Yes. Double-click the cell to edit it, position your cursor right before or after the line break, and press Delete or Backspace. The text on both sides of the break joins into one line. If you have multiple breaks, you can remove them one at a time this way.

Does text wrapping make my spreadsheet slower?

No. Text wrapping is just a display setting and does not affect how fast Excel processes your data. It only changes how the text appears on screen and when you print. You can turn it on or off without any performance impact.

What happens to line breaks if I copy and paste the cell?

Line breaks copy along with the text. If you paste the cell into another location, the line breaks stay in place. If you paste into a program outside Excel, the line breaks may or may not show depending on what program you are pasting into.