If you've ever typed text in an Excel cell and wanted to start a new line within the same cell, you've run into the most common Excel keyboard puzzle. Pressing the regular Enter key moves you to the next cell rather than starting a new line — that behavior is one of Excel's basic conventions, not a bug. To insert a line break inside a single cell you need a different keyboard combination, and once you know it, multi-line cell formatting becomes routine.
This guide covers how to enter a line break within an Excel cell on Windows and Mac, how to do the same thing inside a formula using CHAR(10), how to make sure your line breaks actually display (Wrap Text), how to remove line breaks with Find & Replace, and how line breaks behave when you export to CSV, PDF, or other applications.
We'll also cover the broader behavior of the Enter key in Excel — what "After enter, move selection" does, how F2 lets you edit cells in place, and the tricks that power users rely on for fast keyboard-only data entry.
The line-break shortcut is one of those small skills that pays back enormously over time. Address blocks, multi-line notes in cells, headers with two rows of text, and many other day-to-day spreadsheet tasks all need cell-internal line breaks to look right. The shortcut takes thirty seconds to learn and saves countless minutes of working around the limitation by using merged cells, multi-column layouts, or external text files just to get a paragraph break inside one cell.
The technique works the same in Excel 365, Excel 2019, Excel 2021, Excel for the Web (with caveats), and the older standalone Office versions. The keyboard shortcut differs slightly between Windows (Alt+Enter) and Mac (Cmd+Option+Enter, sometimes Control+Option+Enter depending on the version). The CHAR(10) formula approach works identically on both platforms because it's just a Unicode character code that Excel interprets the same way regardless of operating system.
For users who work mostly in Excel for the Web (browser-based Microsoft 365), the support is more limited. Modern browsers handle Alt+Enter inside Excel for the Web, but some browser extensions intercept the keystroke. If the shortcut doesn't work in the browser, the workaround is to compose the multi-line text in a desktop application or in the formula bar and paste it into the cell with the line breaks already in place. Desktop Excel remains the most reliable environment for serious multi-line cell work.
Windows: position the cursor where you want the break and press Alt+Enter. Mac: press Cmd+Option+Enter (or Control+Option+Enter on some versions). In a formula: concatenate strings with CHAR(10) and apply Wrap Text to the cell so the break displays. Display: Wrap Text must be enabled on the cell for line breaks to render visibly. Remove: Find & Replace with Ctrl+J in the Find What field replaces line breaks with whatever you specify.
The most common scenario is typing text into a cell and wanting to add a line break partway through. Click the cell, type the first portion of the text, then press Alt+Enter on Windows or Cmd+Option+Enter on Mac. The cursor moves to a new line within the same cell and you can continue typing. Press the regular Enter when you're done with the cell entirely, and Excel commits the multi-line text and moves to the next cell as usual.
You can press Alt+Enter as many times as you need within a single cell. Each press inserts another line break. There's no practical upper limit — Excel cells can hold up to 32,767 characters total, with as many line breaks as fit within that limit. The line break itself is a single character (line feed, ASCII 10) that's stored as part of the cell's text content. When you save and reopen the workbook, the line breaks persist exactly as you typed them.
If you're editing existing text and want to add a line break in the middle, double-click the cell to enter edit mode (or press F2), use the arrow keys to position the cursor at the desired break point, and press Alt+Enter. The break inserts at the cursor and pushes everything after it down to the next line. This is how you reformat long single-line cell entries into nicely structured multi-line content without retyping the whole thing from scratch.
One subtle behavior: when you press Alt+Enter, Excel automatically enables Wrap Text on the cell if it wasn't already on. This is convenient because line breaks are invisible without Wrap Text. If you later turn off Wrap Text, the line breaks remain in the underlying text but display as small box characters or vanish from sight, depending on your Excel version and font settings. Re-enabling Wrap Text restores the visual line breaks immediately without any data change.
Best for one-off entries. Click the cell, type text, press Alt+Enter where you want a break, continue typing. Works in any Excel version on Windows. Mac users press Cmd+Option+Enter or Control+Option+Enter depending on the Excel version. The simplest approach for direct data entry into a single cell with one or more line breaks within.
Best for formulas that build multi-line text from other cells. Concatenate with CHAR(10) between sections: =A1&CHAR(10)&B1 produces A1's value, a line break, then B1's value. Apply Wrap Text to the formula cell so the break displays. Useful for address-block formulas, summary cells, and any computed multi-line output anywhere in a workbook.
Best for adding or removing line breaks across many cells at once. In the Find What field, press Ctrl+J to enter a line-break character. Replace With can be empty (to remove all line breaks) or a different separator (e.g., comma, semicolon). The Ctrl+J approach also works in reverse — find a comma, replace with Ctrl+J — to convert single-line entries to multi-line.
Best for very large bulk transformations. A short macro using vbLf or Chr(10) can insert or remove line breaks across thousands of cells. Useful when the line break pattern is rule-based (after every comma, after every semicolon, etc.) rather than a single literal find-and-replace. Power users keep these macros in a personal macro workbook for repeated reuse.
Best when you have multi-line text already prepared in Word, Notepad, or another application. Copy the text including its line breaks and paste it directly into a cell. Excel preserves the line breaks. This approach is useful for porting addresses or descriptions from another document into a spreadsheet without retyping the content manually.
Best for joining many cells into one with consistent line breaks. =TEXTJOIN(CHAR(10), TRUE, A1:A5) produces all values in A1:A5 separated by line breaks, ignoring blanks. The TRUE second argument skips empty cells. Excellent for building summary cells that need to display multiple records as a multi-line list within a single output cell.
Sometimes you need a formula that produces multi-line output. The most common case is concatenating fields from multiple cells into a single cell with line breaks between them — typically address blocks. The function CHAR(10) returns a line-feed character, which Excel renders as a line break within the cell when Wrap Text is enabled. Concatenate it between text segments using the ampersand operator or the CONCAT/CONCATENATE/TEXTJOIN functions.
For example, if you have a name in A2, street in B2, city/state/ZIP in C2, the formula =A2&CHAR(10)&B2&CHAR(10)&C2 produces a three-line address block in the formula cell. The CHAR(10) calls insert line breaks at exactly the points where you want the wrapping. Apply Wrap Text to the formula cell so the breaks render visually. Without Wrap Text, the formula still produces the line-feed characters but displays them as small boxes or hides them depending on the font.
The TEXTJOIN function is even more powerful for many-row sources. =TEXTJOIN(CHAR(10), TRUE, A2:A100) joins every value in A2:A100 with a line break between each, skipping blank cells (the TRUE argument). The result is a single cell containing all the values stacked vertically. This pattern is excellent for summary cells in dashboards, where you want a list of items inline rather than in a separate range.
One thing to watch: CHAR(10) is the Unix-style line feed (LF). Some systems use CHAR(13) for carriage return (CR) or both together (CRLF). Excel on Windows and Mac both use CHAR(10) for in-cell line breaks, but if you're importing or exporting data with line breaks, you may encounter CHAR(13) characters that look strange or render unexpectedly. The fix is usually to substitute CHAR(13) with CHAR(10) using SUBSTITUTE before applying the formatting.
Build multi-line addresses by concatenating name, street, city/state/ZIP with CHAR(10) between each. Apply Wrap Text to the cell so the breaks display. The same pattern works for any structured multi-line output — order summaries, contact cards, ID labels with multiple data points stacked vertically. Use TEXTJOIN(CHAR(10), TRUE, range) when you have variable numbers of lines per record across the whole worksheet.
Two-row column headers ("Quarterly" on one line, "Revenue" on the next) are easy to create with Alt+Enter. Type "Quarterly", press Alt+Enter, type "Revenue". Apply Wrap Text to the header row. Adjust row height manually or use the AutoFit Row Height command to size the row to the content. This is a clean alternative to merged cells for compact column headers.
Some workflows use a single note cell rather than separate comment objects. Type your first note, press Alt+Enter, type the next, repeat. The result is a structured paragraph in one cell that scrolls with the row. Apply Wrap Text and adjust row height as needed. This pattern is common in project trackers, where each row's note column holds a multi-line history of updates over time.
Sometimes you want a bulleted-style list inside one cell. Type a bullet character (• or *), space, item 1, Alt+Enter, bullet, space, item 2, etc. Excel doesn't auto-bullet but the pattern works. For larger lists, paste the multi-line text from Word or Notepad with bullets already in place. Wrap Text and row height handle the visual formatting in the cell once the data lands.
Use IF inside a concatenation to add line breaks only when needed. =A2&IF(B2="","",CHAR(10)&B2) adds B2 with a line break only when B2 is non-blank. The pattern is useful for optional address lines (Apt #, Suite, etc.) that should produce a line break only when populated and disappear cleanly when blank without leaving stray blank lines.
Line breaks inside a cell are invisible until Wrap Text is enabled on that cell. Wrap Text tells Excel to render long text on multiple visual lines within the cell rather than letting it overflow into adjacent cells horizontally. Without Wrap Text, your CHAR(10) characters and Alt+Enter breaks are still in the underlying data, but they display as small box characters or vanish entirely depending on your Excel version and font.
To enable Wrap Text, select the cell or range, go to the Home tab, and click Wrap Text in the Alignment group. Alternatively, press Alt+H+W in Windows. The cell expands vertically to fit the wrapped content, but you may need to adjust row height manually if the auto-fit doesn't trigger. AutoFit Row Height (also under Home → Format) sizes rows to content automatically, which is useful after enabling Wrap Text on multiple rows.
If row height has been manually set previously, AutoFit Row Height may not adjust correctly. Reset by selecting the rows, right-clicking the row header, and choosing Row Height with a specific value, or use AutoFit Row Height from the row header context menu. Manual row height overrides automatic sizing, so resetting clears the override and lets Excel compute the right height for the wrapped content based on font size and number of visual lines.
Some users prefer the look of Wrap Text disabled with line breaks present, viewing the cell only in the formula bar. The formula bar always shows the full multi-line content even when the cell display is limited. This pattern works for backend data cells where the full text isn't meant to be visible at a glance — such as raw notes that drive other reporting cells via formulas in a different visible area of the workbook.
To remove line breaks from many cells at once, use Find & Replace. Select the range, press Ctrl+H (or Cmd+H on Mac) to open Find & Replace. Click into the Find what field. Press Ctrl+J — the field looks empty afterward, but you've actually entered a line-break character. Leave Replace With empty (or type whatever separator you want, like a comma + space) and click Replace All. Excel removes every line break across the selected range.
Ctrl+J is one of the most useful and least-known Excel shortcuts. Because the line-break character is invisible in the Find field, it's easy to think nothing happened. The fastest verification is to look at the Find What field's cursor position — it'll appear to be at the start of the field even after pressing Ctrl+J because the cursor sits on the second "line" of the empty break. The Replace All count tells you whether matches were found.
The reverse pattern is also useful. To convert a comma-separated list inside a cell into a multi-line list, put a comma in Find What and Ctrl+J into Replace With. Excel replaces every comma with a line break, producing a multi-line cell where the commas used to separate items. Apply Wrap Text after the replace to see the multi-line formatting. This pattern is common when receiving exported data with commas as separators that you want to display vertically.
For more complex transformations — say, replacing line breaks with comma-space and then comma-space pairs back to line breaks based on logic — you may need a short VBA macro or Power Query transformation. Power Query handles line-break splits cleanly through its Split Column by Delimiter → Custom → Special Characters → Line Feed option, which is more discoverable than Ctrl+J for users new to the technique and works repeatably across data refreshes.
One final tip: if you're working with text that pastes from PDFs or web pages, you may end up with strange break behavior because those sources use different line-ending conventions. Pasted content from a PDF often contains soft hyphens, non-breaking spaces, or Windows-style CRLF line endings that look right in Excel but cause issues in formulas. Use the CLEAN function to strip non-printable characters and the SUBSTITUTE function to normalize CHAR(13) to CHAR(10) before further processing in a worksheet. CLEAN handles most invisible-character problems automatically.
Beyond inserting a line break with Alt+Enter, the regular Enter key has its own settings worth knowing. By default, pressing Enter commits the current cell entry and moves the active cell down one row. You can change this in Excel Options → Advanced → Editing options with the "After pressing Enter, move selection" setting. Options are Down, Right, Up, Left, or no movement at all. Power users who tab horizontally across input forms often set Enter to move Down and let Tab handle horizontal movement instead.
If you're entering data across a range, Excel has a useful behavior: select a multi-cell range first, then start typing. Each Enter or Tab moves to the next cell within the selection rather than out of it. When you reach the end of a row inside the selection, the next Enter wraps to the beginning of the next row. This pattern lets you enter rectangular blocks of data without needing the mouse to reposition, and it's faster than typing each cell separately for repetitive data entry tasks.
Press Ctrl+Enter to enter the same value into every cell in a selected range at once. Select the range, type the value, press Ctrl+Enter, and Excel fills every cell with that value. This is faster than typing the value once and copy-pasting it. Combined with the multi-cell selection trick above, you can fill an entire range with a value in two keystrokes — handy for default-value initialization in templates and for filling many cells with a constant.
Shift+Enter moves the active cell up rather than down (or in the opposite direction of whatever After Pressing Enter is set to). Useful for backing up one row when you realize you've made a typo two cells back. F2 enters edit mode on the active cell without retyping. F4 while editing toggles absolute and relative references in formulas. These keyboard tricks compound — the more you use them, the faster you work in Excel without the mouse.
Line breaks are invisible when Wrap Text is off. Many users press Alt+Enter, see no visible change, and assume the shortcut didn't work. The fix is to enable Wrap Text on the cell from the Home tab. The breaks were always there in the underlying data, just not displayed visibly without Wrap Text turning on the multi-line rendering.
Wrap Text enabled but the row height was previously locked to a manual value. The cell can't expand vertically, so wrapped lines hide below the visible area. Use AutoFit Row Height (Home → Format → AutoFit Row Height) to reset the row to size automatically based on the content currently in the row.
Formulas that produce CHAR(10) line breaks need Wrap Text on the formula cell to display correctly. Without it, the breaks render as small box characters or vanish from view. Always pair CHAR(10) formulas with explicit Wrap Text on the destination cell to see the intended multi-line output as the formula author meant it.
Line breaks inside cells survive CSV export only when the cell is quoted. Some downstream parsers don't respect the quoting rules and misread embedded line breaks as new-row delimiters. If you're exporting CSV for downstream use, test with a small sample first or use XLSX or TSV when in-cell line breaks matter for the consumer.
For large data sets where you need to consistently process line breaks (either inserting or removing them), Power Query is more reliable than Find & Replace. Power Query is built into modern Excel via the Data tab. Load your range or table into Power Query (Data → From Table/Range), and you can split columns by line-feed delimiter, replace line feeds with custom strings, or merge multiple columns with line-feed separators using the Merge Columns command with the line-feed special character.
The Power Query approach has two advantages over Ctrl+J Find & Replace. First, transformations are reusable — they apply automatically to refreshed data, so you don't have to redo the work each time the source changes. Second, the M-language code Power Query generates is readable and editable, so you can fine-tune the transformation in ways that aren't possible through the Find & Replace dialog. For monthly reporting workflows, Power Query is the cleaner long-term solution.