To start a new line inside an Excel cell, edit the cell, place the cursor where the line should break, and press Alt+Enter on Windows. On a Mac, press Control+Option+Return. Turn on Home > Wrap Text if the lines do not display as expected.
Insert a line break inside a cell
A line break keeps related text together in one cell while showing it on separate lines. For example, a cell can contain a person’s name on the first line and a job title on the second. The cell is still a single value in the worksheet; the break changes how its text is arranged, not its position in the grid.
- Select the cell, then press F2 or double-click it to edit its contents.
- Move the insertion point to the exact place where you want the next line to begin. You can use the arrow keys or click within the text.
- Press Alt+Enter in Excel for Windows, or Control+Option+Return in Excel for Mac.
- Press Enter to finish editing, then select Home > Wrap Text if needed to show the lines within the cell.
If you are entering new text into a blank cell, type the first line, use the shortcut, and continue typing. Pressing Enter by itself finishes the entry and normally moves the selection to another cell; it does not add an in-cell line break.
What the line break does
An in-cell line break is a character stored within the cell’s text. It is different from moving to the cell below, and it is different from text wrapping. A manual break puts a new line at a specific point you choose. Wrapping moves text to another display line automatically when it reaches the cell’s edge, and the exact wrap point can change when you resize the column.
For instance, a cell might contain the two lines North Office and Warehouse. Both lines belong to the same cell, so selecting or copying that cell treats the content as one cell value. A formula that refers to that cell also refers to both lines together. This is useful for addresses, labels, notes, and compact reports where separate worksheet rows would be inconvenient.
A line break does not create a new paragraph with independent formatting or a new record. It is simply a new line in the same cell. If you need to sort, filter, calculate, or analyze each item separately, keeping each item in its own row or column is often a better data layout.
Show all lines with Wrap Text
Wrap Text controls whether Excel displays cell contents on multiple lines to fit the column width. Select the cell or range and choose Home > Wrap Text. The command is a toggle: selecting it again turns wrapping off. It does not add or remove the manual line-break character, so a break can remain in the cell even when wrapping is disabled.
Excel usually adjusts a row’s height when wrapped text needs more space. If the new line is hidden, select the affected row and choose Home > Format > AutoFit Row Height. You can also double-click the lower boundary of the row number. To make several rows fit their contents, select them first and use the same AutoFit command.
Column width affects both automatic wrapping and how the text appears around a manual break. A narrow column can create extra wrapped lines in addition to the line you inserted. A wider column may make automatically wrapped text fit on one line, but it will not remove a manual break. Row height can also be set to a fixed value; a fixed height may clip wrapped text rather than expand to show it.
Use a formula to add a new line
You can also put a line break in text created by a formula with CHAR(10), the line-feed character used for this purpose in Excel. For example, with the first piece of text in A2 and the second in B2, enter =A2&CHAR(10)&B2 in another cell. If A2 contains North Office and B2 contains Warehouse, the result is those two texts on separate lines in the formula cell.
Turn on Wrap Text for the formula cell so the result is visible on multiple lines, and adjust the row height if necessary. The formula joins the values with a line-break character; it does not change either source cell. If either source cell is blank, the formula still includes the break, which can leave an apparently empty line at the beginning or end. Check the source values if the result has unexpected spacing.
This approach is useful when labels or descriptions need to be assembled consistently from separate fields. However, it is a display-oriented result: for sorting and analysis, it is generally easier to keep the underlying pieces in separate columns and combine them only where a multi-line presentation is needed.
Remove, replace, or find line breaks
To remove a manual break from one cell, edit the cell, place the cursor beside the break, and use Backspace or Delete. You can replace it with a space or punctuation if joining the text directly would make the words run together. For example, changing North plus a line break plus Office to North Office preserves the separation between the words.
For a formula-generated break, change the formula rather than editing the displayed result. For a large range of ordinary text, Excel’s Find and Replace can help, but entering a line-break character in its fields is not as visible as typing normal text. On Windows, users commonly enter Ctrl+J in the Find what field to represent a line feed; the field may look blank afterward. Try the operation on a copy or a small test range first, and verify the replacement before applying it broadly. Keyboard behavior can vary by platform and editing context.
Turning off Wrap Text is not the same as removing breaks. It changes how much text is displayed in the cell, and some content may appear clipped or continue visually into an adjacent empty cell. To confirm or change the actual text, edit the cell or inspect its contents in the formula bar.
Common problems and fixes
- The shortcut moves to another cell: Make sure you are editing the cell before using the shortcut. Press F2 or double-click the cell first; a single selection is not the same as editing its text.
- The text still looks like one line: Select the cell and turn on Home > Wrap Text. Also check the row height and column width.
- Part of the text is hidden: Use AutoFit Row Height, increase the row height, or widen the column. A manually fixed row height may prevent all lines from appearing.
- Other cells show extra wrapped lines: Automatic wrapping may be adding lines beyond the manual break. Widen the column or edit the text to make the layout clearer.
- The cell looks cramped after merging: AutoFit can be unreliable for merged cells. Adjust the row height manually or reconsider whether the cells need to be merged.
- The break disappears after copying elsewhere: The destination application may interpret pasted text differently. Check the pasted content there, especially when moving data through plain-text or CSV files.
Line break versus a new cell
Choose an in-cell line break when the pieces form one readable label or note, such as a street address displayed on two lines. Choose separate cells when the pieces are separate data fields, such as street, city, and postal code. Separate fields are easier to filter, sort, validate, reuse in formulas, and export to other systems.
Similarly, a list of several products is usually better represented as one product per row than as a stack of product names in one cell. A multi-line cell may look neat in a printed summary, but it can make individual items harder to count or analyze. Consider the purpose of the worksheet: presentation favors compact formatting, while data processing usually favors one item per cell.
Excel for Mac and Excel for the web
In Excel for Mac, the usual in-cell shortcut is Control+Option+Return. The Windows shortcut is Alt+Enter. In either desktop version, the cursor must be in the cell’s text-editing context, and Wrap Text is available from the Home tab.
Excel for the web runs inside a browser, so keyboard shortcuts can interact with browser controls or differ with the operating system and keyboard. If the desktop shortcut does not insert a break, check Excel’s shortcut help for the browser and platform you are using, or open the workbook in the desktop app. The line-break character and Wrap Text behavior are concepts that apply across Excel versions, even when the keystroke differs.
Frequently Asked Questions
How do I go to the next line in the same Excel cell?
Enter edit mode, position the cursor, and press Alt+Enter on Windows. On a Mac, use Control+Option+Return. Use Wrap Text if the extra line is not visible.
Why does Enter move me to another cell?
Enter normally commits the current entry and moves the selection according to Excel’s settings. To add a line within the entry, use the in-cell line-break shortcut while editing instead.
Does Wrap Text insert a line break?
No. Wrap Text changes how Excel displays text to fit the column. A manual line break is a character in the cell’s contents and remains there independently of the Wrap Text setting.
Can I add a line break with an Excel formula?
Yes. Join the text parts with CHAR(10), such as =A2&CHAR(10)&B2, then enable Wrap Text in the result cell so the break displays as a new line.
Why can’t I see every line in the cell?
The row may be too short, Wrap Text may be off, or the column and row dimensions may not suit the content. Turn on wrapping and use Home > Format > AutoFit Row Height, or adjust the size manually.