The simplest way: Alt+Enter on Windows, Control+Option+Enter on Mac

To create a new line inside an Excel cell without moving to the next cell, hold Alt and press Enter on Windows. On a Mac, use Control+Option+Enter. The cursor will jump to a new line within that same cell, and your text will wrap to fit.

This works in any version of Excel — desktop, web, or mobile — though the keyboard shortcut differs slightly by device. The cell automatically expands vertically to show all the text you've entered, so you don't lose anything when you move to another cell.

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 down.
  • The cell will expand vertically on its own to show all the text, so you won't need to manually adjust row height.
  • You can add multiple line breaks in a single cell by pressing the keyboard shortcut as many times as you need.
  • Turning on text wrapping in the Format menu lets text break automatically at cell edges, but manual line breaks give you exact control over where breaks happen.

When to use manual line breaks versus automatic text wrapping

Manual line breaks (using Alt+Enter) let you decide exactly where the text splits. This is useful when you want a specific word or phrase on its own line — for example, breaking an address into street, city, and state on separate lines within one cell.

Automatic text wrapping, found in the Format menu under Alignment, breaks text wherever it hits the cell edge. This is faster when you have long paragraphs and don't care exactly where the breaks fall. You can turn on wrapping for a single cell or an entire column at once.

Many people use both: they set up automatic wrapping so text doesn't spill over, then add manual line breaks where they want precise control. The cell will respect both at the same time.

How to turn on text wrapping for a column or range

Select the cells or column you want to wrap. On Windows, go to the Home tab, find the Alignment group, and click Wrap Text. On Mac, use the Format menu, select Cells, go to the Alignment tab, and check the Wrap Text box. The text in those cells will now break automatically at the cell edge.

Text wrapping doesn't delete your manual line breaks — if you've already used Alt+Enter in a cell, wrapping will respect those breaks and add more as needed. You can turn wrapping on and off without losing any of your line breaks.

Adjusting row height so all your text shows

When you add line breaks or turn on wrapping, Excel usually expands the row height automatically. If it doesn't, you can do it manually: right-click the row number on the left side, select Row Height, and enter a larger number. Or double-click the border between two row numbers to auto-fit the height to whatever text is in that row.

If you have a very tall cell with lots of text, you may want to increase the row height in increments rather than all at once. This keeps your spreadsheet readable and prevents one tall cell from making the entire row take up too much space on the screen.

Editing and deleting line breaks

To edit text with line breaks, double-click the cell to enter edit mode. You'll see the cursor blinking inside the cell. Use the arrow keys to move up and down between lines, or click directly where you want to edit. Delete line breaks the same way you would delete any character — position your cursor at the break and press Backspace or Delete.

If you want to remove all line breaks from a cell at once, you can use Find and Replace. Press Ctrl+H (Windows) or Command+H (Mac) to open Find and Replace. In the Find field, press Ctrl+J (Windows) or Command+J (Mac) to insert a line break character, leave the Replace field empty, and click Replace All. This removes every line break in your selection.

Line breaks in formulas and pasted data

If you're building a formula that combines text from multiple cells, you can add a line break between them using the CHAR function. Type =A1&CHAR(10)&B1 to combine the contents of cells A1 and B1 with a line break between them. The number 10 is the code for a line break character in Excel.

When you paste data from another program — like a web page or a PDF — it sometimes includes hidden line breaks. If your pasted text looks broken up unexpectedly, use Find and Replace to remove those hidden breaks, or accept them if they match how you want the data organized.

Frequently Asked Questions

Why doesn't Alt+Enter work on my keyboard?

On some laptops, Alt+Enter is mapped to a system function instead of Excel. Try Ctrl+Alt+Enter, or check your keyboard settings to see if Alt is reserved. On Mac, make sure you're using Control+Option+Enter, not just Option+Enter. If neither works, you can use the Format menu to turn on text wrapping instead.

Can I see where my line breaks are in a cell?

Double-click the cell to enter edit mode, and you'll see the cursor move to each line break when you press the arrow keys. The line breaks themselves don't show as visible characters unless you use Find and Replace to search for them (using Ctrl+J or Command+J).

Do line breaks affect sorting or filtering?

No. Excel treats a cell with line breaks as a single cell value, so sorting and filtering work normally. The line breaks are just formatting within that cell and don't change how Excel reads the data.

What happens to line breaks when I export to CSV or PDF?

CSV files preserve line breaks as special characters, but they may not display correctly when you open the file in another program. PDFs will show the line breaks as they appear in Excel. If you're sharing data with others, test the export format first to make sure the breaks look right on their end.