The simplest way to put text on more than one line in a single cell

To add multiple lines within one Excel cell, press Alt + Enter (on Windows) or Control + Option + Enter (on Mac) at the point where you want the line to break. Excel will move your cursor to the next line inside that same cell instead of moving to the next cell down. When you press Enter alone, the cell saves and you move on — but Alt + Enter creates an actual line break within the cell.

This matters because Excel treats each cell as a single unit. If you type normally and press Enter, you leave that cell. If you want your text to wrap to a second or third line while staying in the same cell, you need to tell Excel explicitly where those breaks should happen.

Key Takeaways

  • Press Alt + Enter (Windows) or Control + Option + Enter (Mac) to create a line break inside a cell without moving to the next cell.
  • You can add as many line breaks as you need in a single cell, but the cell height will expand automatically to show all the text.
  • If your text is wrapping but you cannot see all of it, increase the row height by double-clicking the border between row numbers.
  • Cells with manual line breaks will not automatically adjust if you later edit the text, so plan your breaks before you finalize the entry.

When to use line breaks instead of separate cells

A single cell with multiple lines works well when you have related information that belongs together — an address with street, city, and state on separate lines, or a note with a main point and supporting details. It keeps your data organized without spreading it across multiple columns or rows.

Line breaks are also useful when you are printing a spreadsheet and want text to stay visually grouped. If you split an address across three cells, it takes up three rows and your printed page becomes harder to read. One cell with line breaks keeps the address compact.

However, if you need to sort, filter, or analyze the data later, separate cells are usually better. Excel's sorting and filtering tools work on whole cells, not on individual lines within a cell. If you put "John" and "Smith" on different lines in the same cell, Excel cannot sort by last name.

How to adjust row height so all your text shows

When you add line breaks to a cell, Excel automatically makes the row taller to fit the text. But if the row does not expand enough, or if you manually set a row height and now your text is cut off, you can fix it.

Double-click the border between two row numbers on the left side of the spreadsheet. Excel will measure the tallest cell in that row and adjust the height to fit. If you want to set the height yourself, right-click the row number, select "Row Height", and type a number in points (a standard row is about 15 points).

You can also select multiple rows at once and auto-fit them all together. Click the row number of the first row you want to adjust, hold Shift, and click the last row number. Then double-click the border between any two of those row numbers and all of them will resize.

Editing and deleting line breaks

To remove a line break from a cell, click into the cell and position your cursor right before or after the line break. Press Delete or Backspace to remove it. You will see the text from the next line move up to join the previous line.

If you want to edit text that has line breaks, click the cell and then click inside the formula bar at the top of the screen (where the cell contents appear in larger text). You can see and edit all the text there, including where the line breaks are. The formula bar makes it easier to work with long entries.

If you copy a cell with line breaks to another cell, the line breaks come along. If you paste it into a different program like Word or Google Docs, the line breaks usually stay in place too.

Why your line breaks might disappear

If you paste text into a cell and it does not keep the line breaks you added, the most common reason is that you pasted it as "values only" instead of as a full cell. When you paste, right-click and choose "Paste Special", then select "All" or make sure "Formulas" is checked, not just "Values".

Line breaks can also be lost if you use certain Excel features like "Text to Columns" or if you import data from another source. Those tools sometimes strip out formatting. If you need to preserve line breaks during an import or conversion, test it on a small sample first before you do your whole spreadsheet.

Alternatives when line breaks are not the right tool

If you have a lot of text that needs to wrap, consider using Wrap Text instead. Select the cell, go to the Home tab, and click "Wrap Text". Excel will automatically break long text across multiple lines within the cell without you having to press Alt + Enter at each break point. The row height adjusts on its own.

Wrap Text is faster for paragraphs or long descriptions, but it breaks lines based on the column width, not where you choose. If you resize the column, the breaks move. Manual line breaks (Alt + Enter) stay exactly where you put them.

For data that really belongs in separate rows — like a list of items or a series of dates — use separate cells or rows instead. Keeping each piece of information in its own cell makes your spreadsheet easier to sort, filter, and analyze later.

Frequently Asked Questions

Can I add line breaks to multiple cells at the same time?

No, you have to edit each cell individually to add manual line breaks. However, if you want text to wrap automatically in multiple cells, select all of them at once, then click Wrap Text. That applies wrapping to all selected cells in one step.

What is the difference between a line break and wrapping?

A line break (Alt + Enter) is a fixed break you place exactly where you want it. Wrapping is automatic and adjusts when you change the column width. Use line breaks for precise formatting; use wrapping when you want text to fit the available space.

Will line breaks work if I save my file as a PDF or send it to someone else?

Line breaks stay in place when you save as PDF or print. If you send the Excel file itself to someone else, the line breaks come along. If you copy and paste into another program, they usually stay too, but some programs may not display them the same way.

Can I use line breaks in a formula or in a cell that contains a formula?

You cannot add line breaks directly inside a formula. However, you can use the CHAR(10) function to create a line break within text that a formula generates. For example, =A1&CHAR(10)&B1 will put the contents of A1 and B1 on separate lines in the result cell. Make sure Wrap Text is turned on for that cell so the line break shows.