Excel Text on a New Line in the Same Cell: A Guide

Yes. In Excel for Microsoft 365 on Windows, edit the cell, place the cursor where the next line should begin, and press Alt+Enter. On a Mac, use Control+Option+Return. If the line break is there but the text does not display on separate lines, turn on Home > Wrap Text.

Insert a line break while typing

A line break lets you keep related text together in one cell while displaying it on multiple lines. For example, a cell can show a person’s first and last name on separate lines, or an address with the street on one line and the city on the next. The cell still contains one value; the break changes how that value is arranged inside the cell.

Select the cell and start editing it. You can double-click the cell, click in the formula bar, or select the cell and press F2 on Windows.
Move the insertion point to the exact place where the new line should start. If the cell already contains text, click or use the arrow keys to position the cursor between characters.
Press Alt+Enter on Windows, or Control+Option+Return on Mac.
Type the text for the next line, then press Enter to finish editing.

For instance, enter “Northwind” and then “Accounts” with the shortcut between them. Both words remain in one cell, with “Accounts” on the line below. To add more lines, repeat the shortcut at each desired break. The shortcut works while you are editing a cell; pressing it when a cell is merely selected may not insert a break because Excel has not put the cursor inside the text.

Make every line visible with Wrap Text

Wrap Text controls whether Excel displays a cell’s contents on multiple lines within its current column width. Select the cell or cells, then choose Home > Wrap Text. This setting is often needed for a line break to be easy to see, and it also wraps long text automatically when it reaches the edge of a cell. It does not add a manual break at a particular word: the width determines where automatic wrapping happens.

After inserting a manual break, check the row height. Excel usually expands a row to show wrapped content, but the full text can remain hidden if the row has a fixed height or if the layout prevents automatic adjustment. To fit the row, select it and choose Home > Format > AutoFit Row Height, or drag the row boundary downward. You can also double-click the boundary below the row number. Widening the column may change where automatically wrapped lines fall, but it will not remove a manual break.

Where the line break is stored

An in-cell line break is a character in the cell’s content, not a new worksheet row or a second cell. That distinction matters when you sort, filter, or refer to the cell in a formula: Excel treats the entire multi-line entry as one cell value. The break affects display, but does not split the text into separate records.

Pressing Enter after you finish editing moves the selection to another cell; it does not create another line in the cell. Similarly, widening a column or turning on Wrap Text cannot put a deliberate break at a chosen position. Use the keyboard shortcut for a fixed line break, and use Wrap Text when you want Excel to adjust line placement to fit the available width.

Create a new line with a formula

A formula can join text with a line-feed character when the content comes from other cells or needs to update automatically. For example, with a first name in A2 and a last name in B2, enter =A2&CHAR(10)&B2 in C2. If A2 contains “Ada” and B2 contains “Lovelace,” C2 displays “Ada” and “Lovelace” on separate lines once Wrap Text is enabled for C2. The result is one combined text value in C2, and it changes if either source cell changes.

CHAR(10) represents a line-feed character in Excel. The ampersands join the first name, the line break, and the last name in that order. If you see the two names run together or the second line is not visible, select the formula cell and choose Home > Wrap Text; the formula itself does not apply that display setting. You can copy the formula down a column to combine corresponding names in later rows.

Formula-based breaks are useful for labels, addresses, and reports assembled from separate fields. Manual breaks are usually simpler for a one-off note. If you later need to separate the combined result into different columns, the embedded break is part of the text, so you may need to use a text-splitting method or edit the source cells rather than treating the display as though it created new cells.

Paste text that already has multiple lines

Text copied from a document, email, or another spreadsheet may include line breaks. If you paste it into a cell while editing that cell, the breaks can become part of that cell’s contents. If you paste while a cell is selected but not being edited, spreadsheet software may instead interpret lines or tab-separated values as a multi-cell range. The result depends on how the copied content is structured and how it is pasted.

When preserving a multi-line entry is important, edit the destination cell first and paste into its text, or test the paste in an unused area. Check the formula bar or enter edit mode to confirm that the breaks are in the value rather than in separate worksheet rows. For a small amount of text, it can be clearer to paste the first part, insert the line break with the shortcut, and then paste or type the next part.

Fix common line-break problems

The text appears on one line. Select the cell and enable Home > Wrap Text. Also check whether the row is tall enough to show all lines.
Some lines are cut off. Use AutoFit Row Height or increase the row height manually. A manually set height can prevent the row from expanding to fit the wrapped text.
The shortcut moves to another cell. Make sure you are editing the cell, not just selecting it. Click inside the text or press F2 on Windows before using Alt+Enter.
The formula shows a single line. Confirm that the formula includes CHAR(10) between the pieces and that Wrap Text is on for the formula cell.
The line break appears in the wrong place. Edit the cell and reposition the cursor, or adjust the formula so the line-feed character is between the intended text parts.

Merged cells can make automatic row sizing less dependable, so a merged layout may need a manual row-height adjustment. Also remember that a formula-generated break and a manually typed break are different ways to create the same kind of display: if the content is formula-driven, changing the source cells is generally more reliable than editing the result cell.

Printing, sharing, and copying the result

Wrapped lines generally appear in a worksheet printout when the row height shows the full content. Before printing, use Print Preview to check that the row is not clipped and that the column is wide enough for a readable layout. Page scaling can shrink the entire sheet, so a cell that looks clear on screen may become difficult to read if many columns are forced onto one printed page.

In an Excel workbook, the cell’s content and line break are preserved. Other programs may display or interpret pasted text differently, particularly when copying a cell into a document or exporting data. CSV files can represent line breaks inside quoted fields, but other applications do not always handle those records consistently. If preserving the workbook’s layout matters, keep a copy in the Excel workbook format rather than relying only on a plain-text export.

Frequently Asked Questions

How do I go to the next line in an Excel cell without moving to another cell?
On Windows, edit the cell and press Alt+Enter at the insertion point. On Mac, use Control+Option+Return. Press Enter afterward to finish editing.

Why does Alt+Enter not work in Excel?
It may not work if the cell is not in edit mode, because the shortcut is intended to insert a break within the cell’s text. Start editing by double-clicking the cell or pressing F2, then place the cursor where the break belongs.

Do I need Wrap Text for a manual line break?
Wrap Text is recommended so the cell displays multiple lines clearly, but it does not insert the break itself. The shortcut inserts the break; Wrap Text and row height affect how much of the content you can see.

Can a formula put text on a new line in the same cell?
Yes. Join the text parts with CHAR(10), such as =A2&CHAR(10)&B2 when the two parts are in A2 and B2. Turn on Wrap Text for the formula cell to display the result on separate lines.

How do I remove a line break?
Edit the cell, place the cursor at the start of the line after the break, and press Backspace; or place it at the end of the line before the break and press Delete. For a formula-generated break, remove or change the CHAR(10) part of the formula instead.

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.