Excel Cell Return: Add a Line Break Within a Cell

How-to basics · Updated November 18, 2026

To put a return, or line break, inside one Excel cell, edit the cell and press Alt+Enter on Windows; on a Mac, press Control+Option+Return. To create a break with a formula, join text with CHAR(10), then select Home > Wrap Text so the separate lines display inside the cell.

What a return inside an Excel cell does

A return inside a cell starts a new line without moving the next part of the text into another cell. For example, a single cell can show a person’s name on its first line and a job title on its second. The cell still has one value, so you can sort, copy, format, and refer to it as one unit.

This is different from pressing Enter after typing into a cell. Enter normally confirms the entry and moves the active selection to another cell. A line break instead stays within the current cell’s content. People may call it a return, carriage return, newline, or line break; for the usual Excel task, they mean a new displayed line within the same cell.

Line breaks are useful for compact addresses, labels, notes, product details, and printable forms. They can make a worksheet easier to scan, but they do not create separate fields. If you need to filter by a name or calculate using an amount, keeping those values in separate columns is usually more useful than combining them into a multiline cell.

Insert a line break while typing

On Excel for Microsoft 365 for Windows, you can add the break as you enter or edit text:

  1. Select a cell and start typing, or double-click a cell that already contains text. You can also select it and press F2 to edit the existing entry.
  2. Move the insertion point to where the next line should begin.
  3. Press Alt+Enter. Continue typing after the break.
  4. Press Enter to finish the cell entry.

For example, type “Cedar Street,” press Alt+Enter, and then type “Springfield, IL.” The cell contains both lines. If you are editing an existing value, position the insertion point between the parts of the text; pressing the shortcut at the end simply adds a new line after the existing text.

On Excel for Mac, use Control+Option+Return to insert a line break while editing a cell. Keyboard behavior can depend on the keyboard and the way Excel is being accessed, so if that shortcut does not work in your setup, use the formula method below or check the shortcut list for your Excel version. Excel for the web may also handle key combinations differently depending on the browser and operating system.

Make the break visible with Wrap Text

A line break is part of the cell’s contents, but the row may not immediately look tall enough to show every line. Select the cell or range, then choose Home > Wrap Text. This tells Excel to display the cell’s text on multiple lines within its current column width. The manual break determines where a new line starts; wrapping can also create extra lines when text is too long for the available width.

When Wrap Text is enabled, Excel often adjusts the row height to show the content. If a line is hidden, select the affected row and choose Home > Format > AutoFit Row Height. You can also drag the boundary below the row number to make the row taller. A narrow column can cause additional wrapping, while widening it may reduce the number of displayed lines.

Be aware that merged cells can make automatic row-height adjustment unreliable. If a line appears clipped in a merged cell, try adjusting the row height manually, widening the column, or avoiding the merge. Also check vertical alignment: Home > Alignment includes alignment controls that can change where the text sits within a tall cell, though they do not remove the break.

Create a line break with a formula

In formulas, Excel’s CHAR(10) represents a line-feed character, which is the line break commonly used for multiline cell text. To join two pieces of text with a break, first decide which cells supply the content, then turn on Wrap Text for the formula cell. This is helpful when the text should update automatically as its source cells change.

Assume A2 contains Cedar Street and B2 contains Springfield, IL. Enter this in C2:

=A2&CHAR(10)&B2

The result in C2 is Cedar Street on the first line and Springfield, IL on the second. The formula combines the two source values with a line-feed character between them; it does not change A2 or B2. Select C2 and choose Home > Wrap Text if the two lines do not display separately.

You can use the same approach to assemble a formatted label from other cells, but keep the pieces separate if they need to be sorted or calculated independently. For instance, a report might show a customer and account number on separate lines for readability while retaining the customer and account number in their own source columns.

Choose between a manual break and a formula

Use a keyboard-inserted break when you are composing a fixed note or a small amount of text directly in a cell. Use CHAR(10) when a line break belongs in a result built from other cells. The choice depends on how the information will be maintained, not just on how it looks.

  • Manual line break: Best for a heading, address, or note that someone will edit as one cell. It is quick, but the text will not automatically reflect changes in other cells.
  • Formula with CHAR(10): Best when the lines come from source cells and should update with them. The displayed result depends on the formula and the source values.
  • Separate cells or columns: Best when the parts need their own sorting, filtering, validation, or calculations. You can still use a formula or a report layout to display them together elsewhere.

A visually tidy cell is not always the best data structure. For example, putting a first name and last name on separate lines in one cell can make a printed label look polished, but it makes it harder to sort by last name. Retain structured source data and create a multiline presentation from it when both readability and analysis matter.

Common display problems and fixes

The text stays on one line. Check that the cell contains an actual line break and that Wrap Text is on. With a formula, verify that CHAR(10) is between the text pieces rather than outside the concatenation. A narrow column alone does not guarantee that a deliberate break will display as expected if wrapping is disabled.

The second line is cut off. Increase the row height or choose Home > Format > AutoFit Row Height. If the cell is merged, AutoFit may not calculate the height as expected, so adjust the row manually or change the layout.

Alt+Enter seems to do nothing. Make sure Excel is editing the cell rather than merely selecting it. Double-click the cell or press F2, place the insertion point in the text, and then use the shortcut. On a Mac, use the Mac shortcut rather than assuming the Windows key combination applies.

The formula shows the characters instead of a result. Check that the cell is not formatted as Text, and make sure the formula starts with an equals sign. If the cell was already formatted as Text, change its number format to General, then re-enter the formula. Also inspect whether Show Formulas is enabled; Ctrl+` on Windows toggles that view.

A formula-created line break does not print as expected. Check Print Preview, because a row that looks tall enough on screen can still be affected by scaling or page layout. Adjust the row height, column width, or print scaling and review the preview again before printing.

Line breaks, new rows, and imported text

A line break inside a cell is not the same as moving text to the next worksheet row. If a list of addresses needs to be sorted, one address per row is generally more manageable. If an address is intended to appear as a single label, its street, city, and region can instead be combined for display while the original parts remain in separate columns.

When copying multiline text from another application, the breaks may come along with the text. Imported data can also contain line breaks that were not obvious in its source. If a cell displays unexpectedly tall text, enter edit mode and inspect the content, or use a formula bar to review it. Decide whether the breaks are meaningful before removing or replacing them, especially if the text came from a form or data export.

For many cells with the same layout, a formula is easier to maintain than inserting each break manually. Fill the formula down the column, then apply Wrap Text to the result range. If only occasional notes need a second line, manual editing may be simpler. In either case, test a few representative rows, since longer names or addresses can need more height than shorter examples.

Frequently Asked Questions

How do I start a new line in the same Excel cell?
On Windows, edit the cell and press Alt+Enter at the point where the new line should begin. On a Mac, press Control+Option+Return. Press Enter afterward to finish editing the cell.

Why does Alt+Enter move me or not insert a line?
Excel must be in cell-edit mode, with the insertion point inside the text. Double-click the cell or select it and press F2, then place the cursor where you want the break. The Mac shortcut is different, and browser or keyboard settings can affect shortcuts in Excel for the web.

What formula puts text on two lines in one cell?
Join the text with CHAR(10). For example, if A2 and B2 hold the two parts, =A2&CHAR(10)&B2 puts a line break between them. Turn on Home > Wrap Text for the formula cell so the result is visible on separate lines.

Does a line break create another cell?
No. A line break changes how text is displayed within one cell; it does not split the contents into separate cells or records. Use separate columns or rows if you need to sort, filter, or calculate the parts independently.

How can I remove a line break?
Edit the cell and delete the break as you would delete a character, or replace the relevant text in a formula. If a large range contains unwanted breaks, inspect a small sample before using Find and Replace, since removing all breaks can join words that were meant to remain separate.

Why is the last line hidden?
The row may be too short, or merged cells may prevent automatic sizing. Turn on Wrap Text, choose Home > Format > AutoFit Row Height, and increase the height manually if needed. Check Print Preview too if the issue appears only on a printed page.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.