Excel New Line in Cell: Add Line Breaks and Fix Them

To start a new line inside an Excel cell, edit the cell, place the cursor where the break should go, and press Alt+Enter on Windows. On a Mac, use Control+Option+Return. Turn on text wrapping if the lines do not appear properly in the worksheet.

What a new line in an Excel cell does

A line break moves the following text onto another line while keeping all the text in the same cell. This is different from pressing Enter by itself, which normally completes the cell entry and moves the selection to another cell. Line breaks are useful when a single cell needs to hold several related pieces of information without making the column excessively wide.

For example, an address can appear on three lines in one cell: a person’s name, street address, and city. A product label might put the product name above a size, or a short note might separate a heading from its explanation. The cell still has one value; the line break changes how that value is displayed, not how many cells it occupies.

In Excel, an in-cell line break is a line-feed character. It can be entered with the keyboard or included in a formula. The worksheet may need text wrapping or a taller row to show every line, so entering a break and making it visible are related but separate tasks.

Insert a line break while typing

In Excel for Microsoft 365 on Windows, follow these steps:

Select a cell and begin typing, or double-click an existing cell to edit its contents.
Move the insertion point to the exact position where the next line should begin. You can click within the formula bar or press F2 to edit the selected cell, then use the arrow keys.
Press Alt+Enter. Excel inserts a line break without finishing the entry.
Type the next part, then press Enter when the whole cell is complete.

For example, type “Shipping address,” press Alt+Enter, and then type “18 Oak Street.” The two phrases remain in one cell, displayed on separate lines when the row and wrapping allow it. The shortcut works both while creating a new entry and while editing existing text.

On Excel for Mac, the usual shortcut is Control+Option+Return. Keyboard layouts and external keyboards can affect which physical key corresponds to a shortcut, so check Excel’s current shortcut help if that combination is unavailable. Excel for the web also supports in-cell line breaks, but browser and keyboard behavior can vary; if the shortcut is intercepted, try editing in the desktop app or use a formula where appropriate.

Turn on Wrap Text and adjust the row

A line break can be present even when the cell looks as though it contains only one line. Select the cell, then choose Home > Wrap Text. Wrapping lets Excel display text on multiple lines within the column width. It also allows Excel to increase the row height to show the wrapped content.

If the new line is still hidden, check the row height. Double-click the lower edge of the row number to AutoFit the row, or drag that edge downward to make the row taller. You can also select multiple rows before AutoFitting them. A manually specified row height may prevent all lines from showing, even when Wrap Text is on.

Wrap Text off: text may appear on one line and spill into empty cells to the right, or be clipped by neighboring content.
Wrap Text on: Excel displays text on multiple lines within the cell’s column width.
Row height too small: some lines can remain out of sight even though the cell contains them.

Merged cells are a special case. Excel does not always AutoFit the height of a row containing a wrapped, merged cell as expected. If a merged heading hides lines, adjust the row height manually or consider using Center Across Selection or a wider cell layout instead of merging cells.

Add line breaks with a formula

A formula can join text from different cells and place a line break between the pieces using CHAR(10). The number 10 represents the line-feed character used for this purpose in Excel. Enable Wrap Text on the formula cell so the result displays on separate lines.

With a first name in A2 and a last name in B2, where A2 contains “Ava” and B2 contains “Chen,” enter this formula in C2:

=A2&CHAR(10)&B2

The result in C2 is “Ava” on the first displayed line and “Chen” on the second. The formula joins the first value, a line-feed character, and the second value; it does not alter the source cells. Copy the formula down to apply the same pattern to other rows, then use Wrap Text in the result column.

For an address, with a street in A2 and a city in B2, enter this formula in C2:

=A2&CHAR(10)&B2

If A2 contains “18 Oak Street” and B2 contains “Portland,” the cell displays “18 Oak Street” above “Portland.” This example uses the same structure as the name example; the displayed result depends on the contents of the referenced cells. You can add more pieces by joining additional references and CHAR(10) values. For instance, a third address component can be joined after another line-feed character.

Formula-generated breaks are useful when the source data is stored in separate columns or when you want a repeatable layout for many records. If you need to edit the finished wording manually, copy the formula results and use Paste Special > Values; the pasted cells retain the displayed text and its line breaks, but no longer update when the source cells change.

Add or remove breaks across many cells

For a small number of cells, inserting breaks individually gives you precise control. When the same text needs to be rearranged across many cells, Find and Replace may be faster. On Windows, press Ctrl+H to open the Replace tab of Find and Replace. You can enter a line break in a search or replacement box by pressing Ctrl+J while that box is active. The character is invisible, so the box may look empty after you type it.

For example, if imported text uses a line break between a street and a city and you want both parts on one line, enter Ctrl+J in Find what, type a space in Replace with, and choose Replace All. Select the intended range first if you do not want the change applied throughout the worksheet. Review the results, because Replace All changes every matching break in the chosen search scope.

To replace a repeated separator such as a semicolon with a new line, put the semicolon in Find what and enter Ctrl+J in Replace with. The replacement box will not show a visible symbol, so use the dialog carefully and try the operation on a copy or a small test range when the data matters. The Ctrl+J technique is primarily a Windows shortcut; the dialog and keyboard behavior can differ on Mac.

Choose the right method for your task

The best approach depends on whether the content is entered once, assembled from other cells, or being cleaned in bulk.

Use Alt+Enter or the Mac equivalent for a one-off break in text you are typing or editing.
Use CHAR(10) in a formula when the line break should be generated consistently from data in other cells, or recalculated when that data changes.
Use Find and Replace to change repeated separators or existing breaks across a selected range.
Use Wrap Text and row sizing to control whether the stored lines can be seen. These options do not insert or remove a line break.

One common misconception is that Wrap Text creates a deliberate new line at a particular character. It does not: wrapping moves text to another displayed line wherever it runs out of room. A manual break fixes the point at which the next line starts, while wrapping can create additional visual lines if the column is narrow. A cell can use both techniques at once.

Common problems and how to fix them

The shortcut moves to another cell. Make sure you are editing the cell rather than only selecting it. Double-click the cell, press F2, or click inside the formula bar before using the line-break shortcut. Pressing Enter alone ends the entry; Alt+Enter is the Windows shortcut that inserts a break while editing.

The cell still looks like one line. Select it and turn on Home > Wrap Text. Then AutoFit the row or increase its height. Also check whether text in neighboring cells, a fixed row height, or a merged-cell layout is affecting what you can see.

A formula shows a strange square or no visible break. Confirm that the formula contains CHAR(10) between the text pieces and that Wrap Text is enabled for the result cell. If you are viewing the value in a formula bar, a narrow column, or another application, its presentation may not match the worksheet display.

Sorting or filtering seems to behave unexpectedly. A line break is part of the cell’s text, not a separate row or field. If you need to sort by the parts independently, store those parts in separate columns and use line breaks only for presentation. A cell containing a multiline address is still one value for sorting and filtering.

Printing cuts off a line. Check the row height and print scaling, and use Print Preview to see the page layout. A row that displays correctly on screen can be squeezed by print settings. Adjusting column width, row height, or page scaling may help; avoid relying on a line break alone to control page layout.

Frequently Asked Questions

What is the shortcut for a new line in an Excel cell?
On Windows, edit the cell and press Alt+Enter where the break should go. On a Mac, use Control+Option+Return. Press Enter afterward to finish editing the cell.

How do I make Excel show all lines in a cell?
Select the cell and choose Home > Wrap Text. If the content remains clipped, increase the row height or AutoFit it. Merged cells may need manual row-height adjustment.

Can I put a line break in an Excel formula?
Yes. Join the text pieces with CHAR(10), then turn on Wrap Text for the result cell. The formula result remains one cell value even though it appears on multiple lines.

How do I remove a line break from a cell?
Edit the cell and delete the break as you would remove other text. For repeated breaks, use Find and Replace; on Windows, Ctrl+J enters a line break in a dialog box, though it is invisible there.

Does Wrap Text insert a line break?
No. Wrap Text changes how text is displayed to fit the column width. A manual line break sets a specific new-line position within the cell, and both can be used together.

Keep the data readable and usable

New lines are a simple way to make labels, addresses, and notes easier to read without splitting them across cells. Use a keyboard break when you need a deliberate one-time layout, a formula break when the content is assembled from data, and Find and Replace when you need a broad cleanup. In every case, check Wrap Text and row height so the stored content is also visible. If the parts will later need separate sorting, filtering, or calculations, keep them in separate columns and create a multiline display only where it helps the reader.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.