To add a new line inside an Excel cell on Windows, edit the cell, place the cursor where the break should go, and press Alt+Enter. On a Mac, press Control+Option+Return. The new line stays within the same cell; turn on Wrap Text if you cannot see all the lines.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows, or Excel for Mac if you are using a Mac. The basic steps work in desktop Excel, though the keyboard shortcut differs.
- A worksheet and the cell you want to edit. If it contains important information, make a copy of the workbook or cell content before changing it.
- Optional: the two pieces of text you want to put on separate lines. You can type both while editing, or combine text from other cells with a formula.
You do not need to change a workbook-wide setting or insert another row. A line break is a character within the cell, so the cell remains one cell and can still be sorted, formatted, and referenced as usual.
Step-by-Step
- Select the cell. Click the cell where you want the multi-line text. If you are entering new text, you can start typing right away. If the cell already has content, double-click it, click in the formula bar, or select it and press F2 on Windows to edit its contents. On a Mac, double-click the cell or click in the formula bar; shortcut availability can vary with keyboard settings.
- Position the insertion point. Click or use the arrow keys to put the cursor exactly where the next line should begin. For example, in a cell containing an address, place the cursor after the street address and before the city. When replacing or editing existing text, check that the cursor is inside the cell’s text, not merely selecting the cell on the worksheet.
- Insert the line break. On Windows desktop Excel, press Alt+Enter. In Excel for Mac, press Control+Option+Return. You should see the insertion point move to a new line while remaining in the same cell. If you are composing new content, type the first line, use the shortcut, and then type the next line.
- Finish editing without adding another break. Type the rest of your text, then press Enter to commit the edit. The regular Enter key ends cell editing; it does not create the in-cell line break. Click elsewhere or use the appropriate navigation key if you prefer to finish editing and move to another cell.
- Turn on Wrap Text if needed. Select the cell, then choose Home > Wrap Text. A line break may be present even when the cell does not display the full content clearly. Wrap Text lets the cell show multiple lines within its column width; it does not insert the break for you.
- Adjust the row height. If the bottom line is hidden, make the row taller. Point to the boundary below the row number and drag it down, or double-click the boundary to fit the row height to its contents. You can also use Home > Format > AutoFit Row Height in Excel for Windows. If the row height has been set manually, AutoFit or dragging the boundary may be needed to reveal all the text.
- Check the result. Click another cell and confirm that each part appears on its own line within the original cell. Click the cell again and look at the formula bar if you need to verify the complete text. The formula bar may show the content on one line even when the worksheet cell displays a line break, so use the cell itself to check the layout.
For instance, you could keep a contact name and job title together in one cell, with the name on the first line and the title on the second. The same approach works for a delivery address, a short list, or a label with a heading and detail. Put breaks only where you want a new displayed line; Excel will not automatically decide which parts belong together.
You can also create a line break from text stored in separate cells. With the first text in A2 and the second text in B2, enter this formula in the cell where you want the combined result:
=A2&CHAR(10)&B2
For example, if A2 contains North Office and B2 contains Receiving, the result is North Office followed by Receiving on the next line in the formula cell. Select that result cell and turn on Home > Wrap Text so both lines display. This formula joins the values; it does not change the source cells. If either source cell is blank, the formula still includes the line break, which may leave an empty line at the beginning or end.
Common Mistakes
- Pressing Enter instead of the line-break shortcut. Regular Enter normally commits the edit and moves the selection. Use Alt+Enter on Windows or Control+Option+Return on a Mac while the cell is being edited.
- Using the wrong platform shortcut. The Windows and Mac combinations are different. If a key combination seems to finish editing or do nothing, check which version of Excel and which operating system you are using before trying again.
- Expecting Wrap Text to insert a manual break. Wrap Text controls how text fits the column. It can wrap a long line at changing positions when the column width changes; use the keyboard shortcut when you need a break at a specific point.
- Forgetting row height. A line can exist but be hidden because the row is too short. Increase the row height or use AutoFit Row Height rather than repeatedly adding breaks.
- Adding several breaks accidentally. If you press the shortcut more than once, you create blank lines. Edit the cell, place the cursor next to an unwanted break, and remove it with Backspace or Delete.
- Editing the wrong place. If a formula is in the cell, typing directly into it may replace the formula. Check the formula bar first and consider using a formula to combine source values instead of overwriting a calculated result.
Tips
- Plan the break before editing. Decide where the text should split, especially for names, addresses, and labels. This makes the result easier to scan and avoids unnecessary blank lines.
- Use Wrap Text with a sensible column width. A very narrow column can make even a few lines tall and difficult to read. Widen the column first, then keep the manual break where it adds meaning.
- Use consistent formatting for a list. If you put multiple short items in one cell, use one item per line and consistent punctuation. Remember that the items still belong to a single cell, not separate rows, so sorting or filtering cannot treat them individually.
- Keep source data separate when you need to analyze it. A multi-line cell is useful for display, but separate columns or rows are usually easier to filter, count, and summarize. Use an in-cell break for presentation rather than as a substitute for a structured table.
- Copy the cell carefully. Copying and pasting a cell normally preserves its line break and formatting. If you paste into another application, how the break appears depends on that application. If you paste into a plain-text editor, the content may display as multiple lines, which is expected.
- Use a formula for repeatable combinations. If many cells need the same two-line layout and the source values change, a formula using
CHAR(10)keeps the displayed text updated. Apply Wrap Text to the formula cells, then check a few results before filling the formula down.
Troubleshooting
The shortcut moves me out of the cell. First make sure you are editing the cell rather than simply selecting it. Double-click the cell, click in its formula bar, or use F2 on Windows, then place the insertion point inside the text and try the correct shortcut. On a Mac, use the Mac combination rather than the Windows one. If you are using Excel for the web, browser and keyboard settings can affect shortcuts; try editing the cell directly and use the shortcut supported by your setup, or open the workbook in the desktop app.
I inserted a break, but the text still looks like one line. Select the cell and choose Home > Wrap Text. Check that the cell actually contains a manual break by editing it and moving the cursor through the text. Also widen the column or increase the row height. If the cell is merged with neighboring cells, automatic row sizing may not behave as expected, so adjust the height manually or consider unmerging it.
The last line is cut off. Increase the row height by dragging the row boundary. You can double-click that boundary to AutoFit in many ordinary, unmerged cells. If the row has a fixed height, change it or use AutoFit Row Height. Also check the vertical alignment and font size; large text may need more space than the default row height provides.
The formula displays the text without a visible break. Confirm that the formula includes CHAR(10) between the two text references, and enable Wrap Text in the cell containing the formula. A formula bar may show the combined content differently from the worksheet, so inspect the displayed cell. If the source values are blank, the resulting blank line may make it seem as though the break is in the wrong place.
My Mac shortcut does not work. Confirm that you are in Excel for Mac and that the cursor is actively editing the cell. The usual in-cell line-break shortcut is Control+Option+Return. Depending on the Mac keyboard and system settings, key labels or behavior may differ; try the Return key on the main keyboard and verify that Excel has focus. As an alternative for joined values, use a formula with CHAR(10) and turn on Wrap Text.
Frequently Asked Questions
How do I start a new line in an Excel cell without moving to another cell?
While editing the cell, press Alt+Enter on Windows or Control+Option+Return on a Mac. Then press regular Enter when you are ready to finish editing.
Does adding a line break create a new row?
No. It adds a line break inside the current cell. The worksheet still treats the content as one cell, and the row height may need to increase to display all the lines.
Is Wrap Text the same as inserting a new line?
No. Wrap Text displays text on multiple lines as space requires, and the wrapping position can change with the column width. A manual line break fixes a new line at the point where you insert it. You can use both together.
Can I add a line break with a formula?
Yes. Join the text with CHAR(10) between the parts, as in the example above, and turn on Wrap Text for the result cell. The formula updates when its referenced cells change.
Will the line break remain if I change the column width?
A manual break stays at the same position in the cell’s text. The way the text fits around that break can change as the column width changes, and a narrow column may cause additional automatic wrapping.
Can a cell contain more than two lines?
Yes. Insert another manual break at each point where you want a new line. Keep the row tall enough to show the content, and use extra lines only when they make the information easier to read.
Related
- Can Google Sheets Open Excel Files?
- Google Search for Excel Files: Find Spreadsheets
- Google Excel Calendar Template: Find, Build, and Use One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Remove Page Break View in Excel: Normal ViewTo remove Page Break Preview in Excel for Microsoft 365 on Windows, select View > Normal. If you…
- Checklist Template Excel: Set Up, Track, and Reuse TasksA checklist template in Excel is a worksheet with one row per task and columns for details such…
- Excel and Google Sheets Templates: Uses and ChoicesExcel and Google Sheets templates are prebuilt spreadsheets you can copy and adapt for tasks such as budgeting,…
- Tableau Export to Excel: Steps, Limits, and OptionsTo export a Tableau view to Excel, open the view and choose Download > Crosstab, then select the…
- How ROUNDUP Works in Excel: Syntax and ExamplesIf A2 contains 12.341, enter =ROUNDUP(A2,2) to get 12.35: ROUNDUP moves a number away from zero to the…
- Put Currency in Google Sheets: Format Cells and ConvertTo put currency in Google Sheets, select the cells, then choose Format > Number > Currency. To choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.