How to Insert a New Line in an Excel Cell on Windows and Mac

How-to basics · Updated November 20, 2026

To insert 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 Mac, press Control+Option+Return. Turn on Wrap Text if the lines do not display fully. This keeps related text in one cell while showing it on separate lines.

What You’ll Need

  • A workbook open in Microsoft Excel. The instructions below are for Excel for Microsoft 365 on Windows; Mac and Excel for the web differences are noted.
  • A cell that you can edit. If the worksheet is protected, you may need permission or the sheet password before changing it.
  • For the keyboard method, a keyboard with the relevant keys. On some laptops, you may need to use the keyboard’s function layer to access a key.

Step-by-Step

  1. Select the cell you want to change. Click the cell that contains the text, or click an empty cell if you are starting a new entry. If the cell already has content, decide where in that text you want the new line to begin. A line break does not move text into another cell; everything stays in the same cell.
  2. Enter edit mode and position the cursor. Double-click the cell, or select it and press F2. You can also click in the Formula Bar above the worksheet to edit the contents there. Move the insertion point to the exact place where the next line should start. For example, to split a label such as Department: Sales, place the cursor just before Sales.
  3. Insert the line break. On Windows, press Alt+Enter. On a Mac, press Control+Option+Return. Excel inserts a line break at the cursor position, so text after the cursor moves onto the next line within the same cell. If you are creating the entry from scratch, type the first part, use the shortcut, then type the next part.
  4. Repeat if you need more lines. Move the cursor to another position and use the same shortcut again. For an address, for instance, you might put the street, city, and postal code on three lines by adding a break before the city and another before the postal code. Each break remains part of that one cell’s content.
  5. Finish editing the cell. Press Enter to save the change. You can also click the check mark beside the Formula Bar. If you want to cancel your current edit instead, press Esc before committing it. After saving, click the cell once to check that the line break appears as intended.
  6. Enable wrapping if necessary. Select the cell, then go to Home > Wrap Text on the ribbon. This setting lets Excel show the text on multiple lines within the cell rather than letting it appear clipped or extend visually over neighboring cells. Wrap Text does not insert a break; it controls how text is displayed. Your manually inserted break determines where a new line starts.
  7. Adjust the row height if a line is hidden. Excel often expands a row to display wrapped content, but a fixed row height can prevent that. Point to the lower edge of the row number and drag it down, or double-click that edge to AutoFit the row height. If the cell is merged with other cells, AutoFit may not work as expected; adjust the row height manually or reconsider whether the cells need to be merged.

In Excel for the web, the Windows shortcut is generally Alt+Enter while editing a cell. On a Mac using Excel for the web, try Control+Option+Return; browser and keyboard settings can affect shortcut behavior. If the shortcut is intercepted or does something unexpected, try Excel desktop or enter the line break in the Formula Bar while editing.

You can also create a displayed line break with a formula when the cell’s text comes from other cells. With the first text in A2 and the second text in B2, and with A2 containing Maya and B2 containing Chen, enter =A2&CHAR(10)&B2 in another cell. The result is Maya followed by Chen on the next line in that formula cell. Select the result cell and choose Home > Wrap Text so the break is visible. This formula displays a combined result; it does not alter the original values in A2 or B2.

Common Mistakes

  • Pressing Enter by itself. Enter normally finishes the cell edit and moves the selection; it does not add an in-cell line break. Use the platform-specific shortcut while the text cursor is active inside the cell.
  • Using the shortcut before entering edit mode. If the cell is selected but you have not started editing, the keys may not insert a break. Double-click, press F2, or click in the Formula Bar first, then put the cursor in the text.
  • Confusing Wrap Text with a manual break. Wrap Text makes text flow onto additional lines when it reaches the cell edge. It does not guarantee a break at a particular word or position. Use the shortcut to choose the exact break, then enable wrapping to display it.
  • Expecting a wider column to create a new line. Widening a column can change where wrapped text naturally flows, but it does not add a stored line break. If you need the same split regardless of column width, insert a manual break.
  • Assuming the line break creates another cell. A break is a character within the cell’s content. Formulas, sorting, copying, and references still treat the entry as one cell, not as separate rows or fields.
  • Overlooking row height or merged cells. The break can be present even when the row is too short to show it. Check the row height and merged-cell layout before inserting the shortcut again; otherwise you might create duplicate breaks.

Tips

  • Use breaks to improve readability, not to structure a dataset. A multi-line address in a printable contact list can be useful. If you need to sort, filter, or analyze street, city, and postal code separately, store each part in its own column instead.
  • Keep the cursor placement precise. In edit mode, use the arrow keys to move through the text and then insert the break. This can be easier than trying to click between two closely spaced characters, especially in a narrow cell.
  • Check the result at the intended column width. A cell can look tidy at one width and crowded at another. After inserting breaks, view the sheet at its normal working width and confirm the full text is visible without excessive blank space.
  • Use AutoFit thoughtfully. Double-clicking the row boundary can reveal hidden lines, but a long entry may make the row very tall. If that disrupts the sheet, widen the column, reduce the text, or choose a layout that puts parts of the information in separate cells.
  • Consider what happens when you copy the cell. Copying and pasting the cell into another Excel cell normally preserves its line breaks. Pasting into email, a text editor, a website, or another spreadsheet may display the breaks differently, so check the destination if the formatting matters.
  • Use the Formula Bar for long entries. The Formula Bar can be expanded using its expand control, giving you more space to edit text. You can click at the insertion point there and use the same line-break shortcut. The worksheet cell remains the source of the content.

Troubleshooting

The shortcut moves the selection instead of adding a line. Make sure the cell is in edit mode: double-click it, press F2, or click inside the Formula Bar. Then place the cursor within the text and try again. If the cell is locked on a protected sheet, resolve the protection issue before editing. On Mac, verify that you are using Control+Option+Return, rather than the Windows shortcut.

The break seems to have worked, but the text still looks like one line. Select the cell and turn on Home > Wrap Text. Then increase the row height if the second line is cut off. Also check that the cell is wide enough to make the new line easy to see and that the cell is not using a restrictive fixed height. Click the cell and inspect the Formula Bar if you need to confirm that the text is present.

Only part of the text appears, or the row will not expand. Drag the row boundary to increase its height. If the cell is merged, Excel may not calculate the required height automatically; unmerge it if appropriate, or set the row height by hand. Be careful not to change a shared template’s layout without checking how the rest of the sheet is meant to look.

The formula result does not show on separate lines. Confirm that the formula cell is using Home > Wrap Text, then expand the row height. Check that the formula’s input cells contain the expected text and that you entered the formula in a different cell from its inputs. A formula can include a line-feed character, but the display settings still affect whether you can see the lines.

The line break appears in the wrong place or appears twice. Edit the cell again and inspect the text around the intended split. Move the cursor to the unwanted break and remove it with Backspace or Delete, then insert a single break at the correct position. If you are unsure where breaks are, widen the Formula Bar or edit the cell and move through the text with the arrow keys.

Frequently Asked Questions

What is the shortcut to start a new line in an Excel cell?
In Excel for Windows, edit the cell and press Alt+Enter. In Excel for Mac, use Control+Option+Return. The cursor must be inside the cell’s text.

Does Alt+Enter work in Excel for the web?
It generally works in Excel for the web on Windows while you are editing a cell. If a browser or device intercepts the shortcut, try editing through the Formula Bar or use Excel desktop. Mac browser behavior can vary, so try the Mac shortcut and check the result.

Do I need to turn on Wrap Text?
Not to insert the break itself, but Wrap Text is usually needed to display all lines within the cell. If the row has a fixed height, you may also need to increase it so no lines are hidden.

Can I put several line breaks in one cell?
Yes. Insert the shortcut at each place where a new line should begin. You can use multiple breaks for an address or a short list, but keep in mind that every line remains part of one cell and may make its row taller.

Can a formula insert a line break between two pieces of text?
Yes. Join the text with CHAR(10) between the values, as in the example above, then turn on Wrap Text for the formula cell. This changes the displayed result, not the original source cells.

Will a line break affect sorting or filtering?
The cell remains a single value, so Excel sorts and filters it as one cell. If you need to sort or filter each part independently, put those parts in separate columns rather than separating them with line breaks.

Related

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.