To put multiple lines in one Excel cell, edit the cell, place the cursor where the next line should begin, and press Alt+Enter on Windows. To show existing text on multiple lines automatically, select the cell and choose Home > Wrap Text.
What multiple lines in a cell mean
A line break starts a new line inside the same cell. It does not move text into a second cell or add a new worksheet row. For example, one cell can contain an address with the street on its first line and the city and postal code on the next. The cell still has one value, even though Excel displays that value across several lines.
This is different from text overflowing into a blank cell beside it. Overflow is only a display effect: the text remains in the original cell, and any content in the neighboring cell can hide the overflow. A line break, by contrast, is part of the cell’s contents. Wrap Text is different again: it lets Excel choose where lines wrap based on the cell’s width, without requiring you to insert a break at a particular character.
Insert a line break with the keyboard
In Excel for Microsoft 365 on Windows, you can add a break while entering new text or editing a value that’s already in a cell:
- Select a cell and start typing, or double-click it to edit its existing contents. You can also select the cell and press F2.
- Click or move the insertion point to the exact place the next line should start.
- Press Alt+Enter. Continue typing on the new line.
- Press Enter to finish editing the cell.
For instance, enter 48 Cedar Lane, press Alt+Enter, then type Portland, OR 97205. Both parts are stored in one cell on separate lines. To add more breaks, repeat the shortcut at each desired position. If you need to change a break later, edit the cell and move the cursor to the relevant line.
On Excel for Mac, the line-break shortcut is Control+Option+Return. Keyboard behavior can vary in Excel for the web because the browser may use some key combinations itself; if a desktop shortcut does not work there, try editing the cell and use the available ribbon controls, or work in the desktop app. The main Windows steps above apply to Excel for Microsoft 365 for Windows.
Use Wrap Text for automatic line breaks
Wrap Text is useful when you want a long entry to fit within a column without manually deciding where each line begins. Select one or more cells, then choose Home > Wrap Text. Excel wraps text at the cell’s boundaries, based on the column width. If you widen or narrow the column, the wrapping may change.
Wrapping is especially practical for paragraphs, notes, and descriptions that may be edited later. Unlike Alt+Enter, it does not insert a specific line-break character into the text. Excel decides the visual line endings, so a line may reflow when the sheet is resized or printed. You can use both methods together: insert deliberate breaks for a label or address, then turn on Wrap Text to display the result within the cell.
If Wrap Text appears not to work, check whether the text is in a merged cell, whether the row is too short, and whether the cell is being displayed at a very small zoom level. A neighboring filled cell does not have the same effect as an empty one: text may overflow into empty cells, but content in the next cell blocks that display. Wrapping keeps the content inside its own cell instead.
Join text from multiple cells on separate lines
You can also create a multi-line result with a formula. This is helpful when a name, address, or report label is assembled from separate fields. In the layout below, A2 contains Maya and B2 contains Chen. Enter this formula in C2:
=A2&CHAR(10)&B2
The result is Maya on the first line and Chen on the second. CHAR(10) supplies a line-feed character, and the ampersands join the two cell values with that character between them. Turn on Wrap Text for C2 so the line break is visible in the worksheet. The formula does not change the source cells.
For a list of values, the Microsoft 365 function TEXTJOIN can add a line break between entries. With items in A2:A4, enter this in B2:
=TEXTJOIN(CHAR(10),TRUE,A2:A4)
This joins nonempty cells in A2:A4 with a line break between them; the second argument, TRUE, tells Excel to ignore empty cells. If A2 is Apples, A3 is blank, and A4 is Oranges, the result has Apples and Oranges on separate lines, with no empty line for A3. Apply Wrap Text to B2. TEXTJOIN is available in Microsoft 365 and Excel 2019 or later; the CHAR(10) approach with concatenation works in older Excel versions too.
Adjust the row so every line is visible
A cell can contain line breaks even when you cannot see all its lines. The row may simply be too short. To fit it to the visible text, select the row or the affected cells and choose Home > Format > AutoFit Row Height. You can also double-click the boundary below the row number to AutoFit that row. If several rows need adjustment, select them together before using AutoFit.
To set a consistent height yourself, select the relevant row numbers and choose Home > Format > Row Height, then enter a value. A fixed height can make a report more uniform, but it can also clip lines if the content changes or the column width causes extra wrapping. AutoFit is generally the better choice for changing entries.
Excel may not automatically size a row as expected when the cell is merged across columns. Merged cells can also make alignment and sorting harder to manage. If the row needs to show all the text, consider unmerging it, adjusting the column layout, or setting the row height manually. Check the worksheet in print preview as well: a cell that looks clear on screen may break differently on a printed page because the printed column width is different.
Edit, locate, or remove line breaks
To revise a multi-line entry, edit the cell and use the arrow keys or click where you want to change the text. You can delete a break as you would other characters, or insert a new one with the keyboard shortcut. The formula bar can help when a cell is narrow, though the worksheet display is often easier for checking the final layout.
If you need to remove line breaks from a formula result, the layout below assumes A2 contains the text North, a line break, and Region. Enter this in B2:
=SUBSTITUTE(A2,CHAR(10)," ")
The result is North Region on one line. This replaces each line-feed character with a space, preventing the words from running together. If you prefer to remove breaks without adding spaces, replace the quoted space in the formula with an empty string: =SUBSTITUTE(A2,CHAR(10),""). These formulas return cleaned text in another cell; copy the result and use Paste Special > Values if you need to replace the original formula or text while retaining the cleaned result.
For a one-time cleanup, Excel’s Find and Replace can also locate line breaks. In the Windows desktop app, open Replace with Ctrl+H, click in the Find what box, and press Ctrl+J. The line break is invisible in the box, so it may look as if nothing was entered. Use care with Replace All: first select the intended range if you do not want to change the whole sheet. You can replace the breaks with a space or leave the replacement box empty.
Common problems and how to fix them
- The shortcut moves to another cell. Make sure you are editing the cell and that the insertion point is inside its text before pressing Alt+Enter. On Mac, use Control+Option+Return.
- The text still looks like one line. Turn on Wrap Text, widen the column, or increase the row height. A cell can hold a line break even if its display is clipped.
- Only part of the text is visible. Use AutoFit Row Height or set a larger height. Also check whether the row contains merged cells.
- The formula displays a small box or odd symbol. Confirm the formula uses
CHAR(10)and that Wrap Text is enabled. The line-feed character may not be shown as a visible symbol in the formula bar. - The line breaks move after resizing. Manual breaks stay at their inserted positions, while automatic wrapping responds to the column width. A combination of manual breaks and Wrap Text can therefore reflow differently as the layout changes.
Line breaks can also affect how data is copied or exported. When you copy a multi-line cell into another application, the destination may preserve the breaks, interpret them differently, or display them as separate lines. A CSV file can contain line breaks within a quoted field, but the receiving program must handle quoted fields correctly. If the data is intended for sorting, filtering, or importing, keeping each component in its own column is often more reliable than combining everything into one formatted cell.
When to use multiple lines instead of more cells
Multiple lines work well when the content belongs together and is primarily meant to be read as one item: a postal address, a compact heading, a short note, or a printed form label. They can make a worksheet easier to scan without adding many narrow columns. Deliberate breaks are best for text with a stable format, such as a two-line title; Wrap Text is usually more flexible for descriptions that change in length.
Separate cells are usually the better choice when each piece of information needs independent sorting, filtering, calculations, or validation. For example, storing street, city, and postal code in separate columns makes it easier to filter by city or check postal codes. A visually tidy cell is not always a well-structured data field. In a report, it may be sensible to keep the source data separated and create a multi-line display in a separate output area.
Frequently Asked Questions
How do I start a new line in an Excel cell?
In Excel for Windows, edit the cell, place the cursor where the new line should begin, and press Alt+Enter. On Excel for Mac, press Control+Option+Return.
Can I put multiple lines in one cell without a formula?
Yes. Type or edit the text and use the line-break shortcut at each point where you want a new line. Wrap Text can then help display the content within the cell.
Why is Alt+Enter not working in Excel?
The cell may not be in edit mode, or the cursor may not be inside its contents. Double-click the cell or press F2, position the cursor in the text, then try Alt+Enter. On a Mac, use the Mac shortcut instead.
How do I make Excel show all lines in a cell?
Enable Home > Wrap Text, then use Home > Format > AutoFit Row Height if the row is still too short. Merged cells may require manually adjusting the row height.
Can Excel put a line break between values from two cells?
Yes. Join the values with CHAR(10), such as =A2&CHAR(10)&B2, then turn on Wrap Text in the formula cell to display the result on separate lines.
Related
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
- Data Validation Reference Table in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook Email Archive: How to Save Messages SafelyTo archive an email in Outlook, select the message and choose Archive on the toolbar or ribbon; Outlook…
- Circular Reference Settings in Excel: How They WorkIn Excel for Microsoft 365 on Windows, turn on circular-reference calculations at File > Options > Formulas by…
- Excel Shortcut Keys to Highlight Cells to the End of DataIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+End to select from the active cell through the worksheet’s…
- How to Make a 4-Page Brochure in Word: Step by StepTo make a four-page folded brochure in Microsoft Word, open Layout > Margins > Custom Margins, choose Book…
- Insert Rows in Excel Multiple Times: A Step-by-Step GuideTo insert several rows in Excel at once, select the same number of row headers as the number…
- Brochure in Word: Layout, Design, and Printing TipsYes—you can make a brochure in Microsoft Word, either by customizing a brochure template or by setting up…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.