Excel: How to Add Lines in a Cell (3 Easy Ways)

How-to basics · Updated November 22, 2026

To add lines in a cell in Excel, press Alt+Enter (Windows) or Control+Option+Return (Mac) after typing the first line, then continue typing the next line. This inserts a manual line break inside the cell, and the cell will display multiple lines as long as Wrap Text is enabled (Home > Wrap Text).

Why You Would Want Multiple Lines in One Cell

Excel cells normally hold a single line of text, but real-world data often needs more. You might want to put a street address and city on separate lines within one cell to keep a mailing list tidy, or split a product description into bullet-like points. Without line breaks, long text spills over into adjacent cells or gets cut off, making your spreadsheet harder to read and print.

Using line breaks inside a cell is different from merging cells or widening columns. Merging combines multiple cells into one visual block, while line breaks keep all your text in a single cell and let you control exactly where each line starts. This is especially useful when you need to export the data to another program that expects each record in one cell, such as a CSV file or a database import.

How to Insert a Line Break in a Cell (Step-by-Step)

The quickest method works in any version of Excel for Windows or Mac:

  1. Double-click the cell where you want the break, or select it and press F2 to enter edit mode.
  2. Type the first line of text.
  3. Press Alt+Enter on Windows, or Control+Option+Return on Mac. A new line starts immediately.
  4. Type the second line, and repeat the shortcut for each additional line.
  5. Press Enter to finish, then make sure Wrap Text is turned on (Home tab > Wrap Text) so the cell shows all lines.

If you prefer using the ribbon, you can also go to Home > Wrap Text after entering the break—the break is stored in the cell even if wrapping is off, but the second line will be hidden until you enable it.

Using Wrap Text and Adjusting Row Height

Line breaks work hand-in-hand with Wrap Text. When Wrap Text is on, Excel automatically wraps any text that exceeds the column width onto new lines, and it also respects manual line breaks. Without Wrap Text, only the first line appears; the rest is hidden until you click into the cell.

After you add lines, the row height may not adjust automatically. To fix that:

  • Select the row, then go to Home > Format > AutoFit Row Height.
  • Or manually drag the row boundary to set a custom height.
  • If you have many rows, select them all and use AutoFit once.

Note that if you set a specific row height manually, AutoFit will not override it until you reset the height to automatic (by double-clicking the row boundary).

Adding Lines with a Formula (e.g., Concatenating with CHAR(10))

You can also create line breaks dynamically using a formula. The key is the CHAR(10) function, which returns a line feed character in Windows Excel (on Mac, use CHAR(13) for a carriage return, though CHAR(10) often works too).

Example: Suppose cell A1 contains “123 Main St” and cell B1 contains “Springfield, IL”. To combine them with a line break in cell C1:

  • In C1, enter: =A1 & CHAR(10) & B1
  • Press Enter, then enable Wrap Text for C1.
  • The result shows “123 Main St” on the first line and “Springfield, IL” on the second.

For a list of items, you can use the TEXTJOIN function (Excel 2016 and later) with the delimiter CHAR(10). For example, if you have items in A1:A3, use:

=TEXTJOIN(CHAR(10), TRUE, A1:A3)

This joins the three cells with line breaks, ignoring empty cells. Remember to turn on Wrap Text to see the result.

Common Problems and How to Fix Them

Line break not showing: The most common issue is that Wrap Text is off. Turn it on from the Home tab. Also check that the row height isn’t too small to display all lines.

Alt+Enter not working: If you’re in a cell but the shortcut inserts a newline in the formula bar instead, make sure you are editing the cell directly (double-click or F2). On some laptops, you may need to press Fn+Alt+Enter.

Line breaks disappear after sorting or filtering: They don’t actually disappear; they are still in the cell. If you copy data from another source, the line breaks may be lost if you paste as values. Use Paste Special > Values to preserve them.

Row height won’t auto-fit: If you previously set a fixed row height, Excel won’t override it. Select the row, go to Home > Format > AutoFit Row Height, and if that doesn’t work, double-click the boundary between row numbers.

Alternatives: Merged Cells, Text Boxes, and Comments

Line breaks are not the only way to show multiple lines. Depending on your goal, you might consider:

  • Merged cells: Combine several cells into one large cell to hold longer text, but merging can complicate sorting, filtering, and copying data. Use sparingly.
  • Text boxes: Insert a text box (Insert > Text Box) for free-floating notes, but they don’t reside in a cell and aren’t part of the grid data.
  • Cell comments: Add a comment (Review > New Comment) to store extra details that appear on hover, but that’s not visible in the printed sheet.
  • Alt+Enter in formulas: You can also embed line breaks directly in a formula string using CHAR(10) as shown above, which is useful for dynamic reports.

For most data-entry scenarios, manual line breaks are the simplest and most reliable.

Frequently Asked Questions

How do I remove a line break from a cell? Click into the cell, place the cursor at the end of the line you want to remove, press Backspace to delete the break, or use Find & Replace: select the range, press Ctrl+H, put the cursor in “Find what”, press Ctrl+J (this inserts a line break character), leave “Replace with” empty, and click Replace All.

Can I add a line break in a cell on Excel for the web? Yes, press Alt+Enter on Windows or Option+Enter on Mac while editing a cell. The web version supports line breaks, but some keyboard shortcuts may vary by browser.

Why does my line break show as a small square or box? That usually happens when the font doesn’t support the line feed character, or when you copy text from another program. Try changing the font to a standard one like Arial or Calibri, and ensure Wrap Text is on.

Can I use a formula to add a line break after every word? Not directly, but you can use SUBSTITUTE to replace spaces with CHAR(10). For example, with text in A1, use =SUBSTITUTE(A1, " ", CHAR(10)) and enable Wrap Text. This will put each word on its own line.

Will line breaks affect sorting or filtering? No, sorting and filtering treat the cell as a single value, so the line breaks don’t interfere. However, if you sort by that column, the entire cell content moves together.

Summary and Quick Reference

To add lines in a cell, remember the core shortcut: Alt+Enter (Windows) or Control+Option+Return (Mac). Always enable Wrap Text to see all lines, and use AutoFit Row Height if the row doesn’t expand. For dynamic line breaks, use CHAR(10) in formulas. With these tools, you can keep your data organized and readable without leaving the grid.

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.