To start a new line inside the same Excel cell on Windows, edit the cell, place the cursor where the break should go, and press Alt+Enter. This inserts a line break without moving to another cell. It is useful for putting an address, a label and note, or several details together while keeping them in one cell. The steps below are for Microsoft Excel for Microsoft 365 on Windows; Mac and Excel for the web notes are included too.
What You’ll Need
- An Excel workbook and the cell where you want multiple lines of text.
- A keyboard with an Alt key for the Windows shortcut. If you are using a Mac or Excel for the web, see the platform notes below.
Step-by-Step
- Select the cell. Click the cell you want to edit. If you are entering a new value, you can begin typing immediately. If the cell already contains text, double-click it, or select it and click in the formula bar above the worksheet. You need to be editing the cell’s contents, not just selecting the cell, before the shortcut will insert a break.
- Position the insertion point. For new text, type the first part and stop where the next line should begin. For existing text, click at the exact position in the cell or formula bar. You can also use the arrow keys while editing to move the cursor through the text. The break will be inserted at the cursor position, so check that it is between the words or details you intend to separate.
- Insert the line break. Press Alt+Enter on your Windows keyboard. Continue typing the next line. For example, you could type 25 Oak Street, press Alt+Enter, and then type Springfield, NY 10001. Both lines remain part of the same cell; Excel does not move the second line into the cell below.
- Repeat if you need more lines. Move the cursor to another point in the cell and press Alt+Enter again. You can use several breaks in one cell, but keep in mind that a tall cell can make a worksheet harder to scan. Break text at natural boundaries, such as between an address and a contact name, rather than splitting every few words.
- Finish editing the cell. Press Enter to commit the change. The active selection usually moves to the cell below after you press Enter. That is normal: the line break was added while you were editing, and pressing Enter afterward confirms the whole cell entry. If you want to keep the same cell selected while finishing, use Ctrl+Enter on Windows.
- Make the lines visible. Select the cell and, if needed, go to Home > Wrap Text. Excel often displays an inserted line break on separate lines automatically, but wrapping helps the cell show its contents within its column width. If text still appears cut off, adjust the row height or column width; the next section explains how to check those settings.
On a Mac, edit the cell and use Control+Option+Return to insert a line break. Keyboard layouts and Excel versions can affect shortcuts, so if that combination does not work, check the shortcut help for your installed version. In Excel for the web, use the same in-cell editing approach; on Windows, press Alt+Enter. On a Mac in a browser, try Control+Option+Return. Browser or system shortcuts may interfere, so if necessary use the desktop Excel app or consult the web app’s current keyboard shortcut list.
Common Mistakes
- Pressing Enter by itself. Enter confirms the current entry and usually moves the selection to another cell. To create a new line within the cell, first make sure you are editing its contents and use Alt+Enter instead.
- Using the shortcut while the cell is only selected. If you have clicked a cell but have not started editing it, Excel may interpret the keys differently or do nothing. Double-click the cell, click in the formula bar, or start typing before using the line-break shortcut.
- Expecting the break to create a new cell. A line break is a character inside one cell. It does not divide the contents into separate rows or columns. If each line needs to be sorted, filtered, or calculated separately, put each item in its own cell instead.
- Thinking the text disappeared when it is clipped. A narrow column or short row can hide some of the displayed lines. The content may still be in the cell. Select it and look in the formula bar, then turn on Wrap Text or resize the row or column.
- Adding spaces instead of a real break. Repeated spaces may look like a line layout at one column width, but the alignment can change when the column is resized or the workbook is opened on another screen. Use the keyboard shortcut to create a genuine line break.
Tips
- Use the formula bar for long entries. The formula bar can be easier to edit when a cell already contains several lines. Click inside its text, put the cursor at the desired position, and press Alt+Enter. The line break still belongs to the selected cell, even though you are entering it in the formula bar.
- Combine wrapping with a sensible column width. Wrap Text displays text on multiple visible lines as the column width allows. A very narrow column can create extra visual wrapping beyond the breaks you inserted. Widen the column a little if words appear crowded or the cell becomes unnecessarily tall.
- Let row height adjust when possible. Excel usually expands a row to show wrapped text. If the row has a fixed height, some lines may be hidden. Select the row and use Home > Format > AutoFit Row Height, or double-click the boundary below the row number. If the height was manually set, AutoFit may be needed again after editing.
- Check how the cell will be used. A line break works well for display text, such as a mailing address in a printable sheet. It can be inconvenient when the data will be imported into another system or processed as separate values. In those cases, use separate columns or rows, and keep the original components structured.
- Keep formatting consistent. If you are preparing a list of addresses or notes, apply the same line-break pattern to similar cells. Consistent entries are easier to read. If the cell needs more than a few short lines, consider increasing the row height or moving the longer explanation to a note or a separate column.
Troubleshooting
Alt+Enter does nothing: First check that the cell is in edit mode. Double-click the cell or click in the formula bar, then place the cursor inside the text and try the shortcut again. If you are using a laptop, confirm that you are pressing the actual Alt key and not a key combination assigned by a keyboard utility. If using Excel for the web, browser behavior or focus can affect shortcuts; click into the cell text and try again, or open the workbook in the desktop app.
The next line appears in another cell: You probably pressed Enter without the Alt key, or had not entered edit mode. Undo the unintended entry if appropriate, reopen the original cell for editing, and insert the break with Alt+Enter. Check the formula bar afterward: a line break should still be part of one cell’s contents.
The cell contains multiple lines, but only one is visible: Select the cell and choose Home > Wrap Text. Then use Home > Format > AutoFit Row Height or drag the row boundary downward. A manually fixed row height can prevent all lines from showing. Also check whether the text color matches the background or whether another cell or merged-cell layout is making the display confusing.
The text wraps at unexpected places: Excel can wrap text automatically when it reaches the edge of a column, in addition to the deliberate breaks you inserted. Widen the column to reduce automatic wrapping, or adjust the location of your manual breaks. If the cell is merged with neighboring cells, automatic sizing may not behave as expected; adjust the row height manually or avoid merging cells for content that needs to expand.
The line break looks like extra blank space: You may have inserted two breaks in a row, or the row height may be larger than necessary. Edit the cell, place the cursor on the empty line, and delete the extra break with Backspace or Delete. Be careful to remove only the blank break, not the text on either side.
Frequently Asked Questions
What is the shortcut to start a new line in an Excel cell?
In Excel for Microsoft 365 on Windows, edit the cell and press Alt+Enter at the point where you want the line to begin. Press Enter afterward to save the cell contents.
Does Alt+Enter create a new cell?
No. It adds a line break inside the current cell. The text before and after the break stays together as one cell value. Use separate cells if you need to sort or work with each item independently.
How do I add a line break to text that is already in a cell?
Double-click the cell or click in the formula bar, move the insertion point to the desired position, and press Alt+Enter on Windows. Then press Enter to commit the edit. If the cell is long, the formula bar may be easier to work in.
Why does the line break not show when I print?
Check that the cell is wrapped and that the row is tall enough to display every line. Also preview the worksheet with File > Print, because print scaling, margins, and page layout can affect how much of the sheet fits on a page.
Can I put more than one line break in a cell?
Yes. Press Alt+Enter at each point where you want a new line while editing. Use a reasonable number of lines and adjust wrapping and row height so the full entry remains readable on screen and in print.
Is the shortcut the same in Excel on Mac?
No. On a Mac, the usual shortcut is Control+Option+Return. Excel for the web and different keyboard layouts can behave differently, so make sure the cell is being edited and check the shortcut guidance for your version if needed.
Related
- How to Import an Excel Document Into Microsoft Word
- How to Highlight in Microsoft Excel
- How to Highlight in Excel Using Keyboard Shortcuts
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Analysis Methods: Tools, Steps, and ExamplesExcel analysis methods include formulas, PivotTables, charts, conditional formatting, Power Query, and statistical tools. Choose a method based…
- How to Create Columns in a Word Document: A Simple GuideTo create columns in a Word document, open the Layout tab, select Columns, and choose a layout such…
- Excel Table Color Schemes: How to Choose and ChangeTo change an Excel table’s color scheme, click inside the table, open Table Design, and choose a style…
- Select an Entire Row in Excel With Shift+SpaceTo select an entire row in Excel, click any cell in that row and press Shift+Space on Windows.…
- How to Copy in Excel and Keep FormattingTo copy cells in Excel and keep their formatting, select the cells, press Ctrl+C, click the destination, and…
- Excel Shortcut to Switch Between Worksheet TabsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next sheet tab, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.