Insert a Line Break in an Excel Cell on Any Device

How-to basics · Updated November 21, 2026

To insert a line break inside an Excel cell, edit the cell, place the cursor where the next line should begin, and press Alt+Enter on Windows. On a Mac, press Control+Option+Return. Turn on Home > Wrap Text if the separate lines do not display as expected.

Insert a line break in a cell

A line break keeps related text in one cell while displaying it on separate lines. For example, an address can show the street on the first line and the city and postal code on the next. The data is still in one cell; Excel has not moved the second part into another row or column.

  1. Select the cell and start editing it. Double-click the cell, click in the formula bar, or select it and press F2 on Windows.
  2. Move the insertion point to the exact place where you want the next line to start. Use the arrow keys or click within the text while editing.
  3. Press Alt+Enter on Windows, or Control+Option+Return on a Mac.
  4. Press Enter to finish editing. If needed, select Home > Wrap Text to show all the lines.

For example, typing 18 Oak Street, inserting the break, then typing Apt 4 keeps both parts together in one cell. You can use more than one break in a cell to create three or more lines. The same method works in a blank cell as you type and in a cell that already contains text.

What the line break does—and what it does not do

It helps to distinguish a line break from a worksheet row break. A line break changes where text continues inside one cell; it does not split a worksheet row, create a new record, or move the text below into a separate cell. If you need each address component in its own field for sorting or filtering, put the components in separate columns instead.

A line break also differs from automatic text wrapping. A manual break fixes a new-line position at a particular point in the cell’s contents. Wrapping is a display behavior: Excel moves text to another visual line when it reaches the cell boundary. If you widen or narrow a column, wrapped text may reflow, while a manual break remains at its inserted position.

You can use both at once. A manual break can set deliberate divisions, and Wrap Text can display additional text that does not fit on the line. This is useful for labels, notes, and compact multi-line entries, but it may make a worksheet harder to scan if used on every row.

Place the break precisely while editing

The most common mistake is pressing the shortcut while the cell is selected but not being edited. In that state, Excel may interpret the keystroke differently or appear to do nothing. First enter edit mode, then confirm that the blinking insertion point is inside the cell’s text. Pressing F2 on Windows is often a reliable way to enter edit mode; the cursor position may begin at the end of the contents, so move it before inserting the break.

If you are replacing only part of a long entry, use the formula bar to see and navigate the complete contents more comfortably. You can also edit directly in the cell, provided the cell is not so narrow that positioning the cursor becomes awkward. Finish with Enter to commit the change, or press Esc to cancel the edit.

When a cell contains a formula, editing it and adding a manual break changes the formula text rather than simply changing the displayed result. If you want a formula to produce multiple lines, use a line-feed character in the formula instead; that approach is covered below.

Make every line visible

After inserting a break, Excel generally displays the cell as multiple lines, but the row may not be tall enough to show all of them. Select the cell and choose Home > Wrap Text. Then let Excel adjust the row height: point to the lower boundary of the row number and double-click it, or use Home > Format > AutoFit Row Height. You can also drag the row boundary downward to set a height yourself.

Column width affects the appearance of the text around the manual break. A narrow column can cause a single intended line to wrap onto extra visual lines; a wider column may leave more empty space but does not remove the manual break. If a row is too short, the remaining text may be hidden, especially when the cell below is occupied. Increase the row height or use AutoFit to reveal it.

AutoFit does not always behave as expected with merged cells, and a row with a manually fixed height may not expand to show all its contents. For a merged cell, adjust the row height manually or consider avoiding the merge. If you have many rows, select them first and use AutoFit Row Height so Excel can resize the selected rows together.

Create line breaks with a formula

A formula can join text from multiple cells and place a line break between the pieces. In Excel, CHAR(10) represents a line-feed character. The formula result is still a single cell value, so enable Wrap Text on the result cell to see the separate lines.

With a street name in A2 and an apartment detail in B2, enter this formula in C2:

=A2&CHAR(10)&B2

If A2 contains 18 Oak Street and B2 contains Apt 4, the result in C2 displays as 18 Oak Street on the first line and Apt 4 on the second line when Wrap Text is enabled. The formula does not change the source cells. This is useful when you want the displayed multi-line text to update automatically as the source values change.

For a formula that combines several pieces, add another &CHAR(10)& between the values. Check for blank source cells: a formula can still create an empty line where a blank value falls. For a one-time entry that you do not need to update from source cells, typing the text and using the keyboard shortcut is usually simpler.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, the shortcut is Alt+Enter while editing the cell. On Mac, use Control+Option+Return. The Mac shortcut is different from the Windows one, so do not assume that pressing Option+Return alone will insert the break. In either desktop version, first place the cursor inside the cell’s contents.

Excel for the web also supports editing cell contents and using Wrap Text. Keyboard behavior can be affected by the browser or operating system, so if the desktop shortcut does not work, check that you are actively editing the cell and try the web app’s available keyboard shortcut guidance. You can still use the ribbon’s Home > Wrap Text command to control display. Formulas using CHAR(10) are another option when the text is assembled from other cells.

If you switch between Excel on different devices, the line break remains part of the cell content, but the row height and visible layout can differ because each version or screen may display columns differently. Review the sheet after opening it on another device, especially before printing or sharing a final copy.

Common problems and how to fix them

  • The shortcut moves the selection instead. Enter edit mode first and confirm the cursor is inside the text. A selected cell is not necessarily being edited.
  • The text still appears on one line. Select the cell and turn on Home > Wrap Text. Also check whether the row is tall enough to show the additional line.
  • Only part of the text is visible. Increase the row height or use AutoFit Row Height. Check for a fixed row height or merged cells that prevent automatic sizing.
  • The text wraps at unexpected places. Widen the column or remove unnecessary manual breaks. Automatic wrapping depends on the available column width, while manual breaks stay where you inserted them.
  • The formula shows a symbol or the text does not break. Verify that the formula uses CHAR(10) between the text values, then enable Wrap Text on the formula cell.

One related misconception is that pressing Enter by itself will add a line inside the cell. In normal editing, Enter finishes the edit and moves the selection, rather than inserting the intended line break. Use the platform-specific shortcut while editing for a manual break.

Remove or change a line break

To remove one break, edit the cell, place the cursor next to the break, and use Backspace or Delete. Which key removes it depends on whether the cursor is just after or just before the break. You can also select the text on both sides and replace the break with a space or other separator. Press Enter to save the revised contents.

If a formula creates the break, edit the formula and remove the relevant CHAR(10) section, or replace it with the separator you want. Turning off Wrap Text changes how text is displayed but does not delete manual line breaks from the cell. Likewise, widening the column may change automatic wrapping without removing a manually inserted break.

Frequently Asked Questions

How do I start a new line in the same Excel cell?
On Windows, edit the cell, place the cursor at the desired point, and press Alt+Enter. On Mac, press Control+Option+Return. Use Wrap Text if the new line is not visible.

Why is Alt+Enter not working in Excel?
The cell may not be in edit mode. Double-click it or press F2 on Windows, position the cursor within the contents, and try again. A browser or keyboard setup can also affect shortcuts in Excel for the web.

How do I make Excel automatically show all lines?
Select the relevant cells and choose Home > Wrap Text. Then use Home > Format > AutoFit Row Height or double-click the row boundary. Merged cells and fixed row heights may need manual adjustment.

Can I add a line break in an Excel formula?
Yes. Join the text pieces with CHAR(10), for example =A2&CHAR(10)&B2. With the text in A2 and B2, this displays the two values on separate lines when Wrap Text is enabled on the formula cell.

Does a line break put the text into a new row?
No. It creates another displayed line inside the same cell. To create a separate worksheet row or a value in another cell, move or split the data into separate cells instead.

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.