How Do You Create a New Paragraph in an Excel Cell?

How Do You Create a New Paragraph in an Excel Cell?

Press Alt + Enter at the point in the text where you want the break. On a Mac it is Ctrl + Option + Enter. That is the whole answer, and it is the one thing almost nobody discovers by guessing, because the key you instinctively reach for does something else entirely.

Pressing Enter on its own commits the cell and jumps down to the next row. So the natural attempt to add a second paragraph looks like it deleted your work, when in fact it just moved you somewhere else and left the cell with a single line in it.

This guide covers the keyboard method, the formula method for text Excel builds for you, why Wrap Text is a separate setting that people confuse with line breaks, and the row-height and export problems that show up once you start using multi-line cells in earnest.

The Short Answer

To create a new paragraph inside a single Excel cell:

• Double-click the cell, or select it and press F2, to enter edit mode
• Click to place the cursor where the break should go
• Press Alt + Enter on Windows, or Ctrl + Option + Enter on macOS
• Press Enter to commit the cell when you are done

The text after the break drops to a new line within the same cell. The cell still holds one value — you have added a line break character inside that value, not split it into two cells.

Excel also turns on Wrap Text for that cell automatically the first time you insert a manual break, which is why the row usually grows taller on its own.

Your spreadsheet skills are not the bottleneck on your traffic. Get a free SEO audit and find out what is.

Why Enter Alone Does Not Work

Excel treats Enter as "I am finished with this cell." It is a commit-and-move command, inherited from the earliest spreadsheet programs, and it is deliberate: in a grid built for fast numeric entry, you want to type a figure, press Enter, and land on the next row without touching the mouse.

That makes Enter unavailable for its word-processor meaning. So Excel assigns the in-cell break to a modified version of the same key.

What the Break Actually Inserts

A manual line break puts a single invisible character into the cell's text. On Windows that character is a line feed, character code 10. You can see the consequence rather than the character itself: the text reflows, and the cell's length grows by one.

This matters more than it sounds, because that character travels with the data. Copy the cell into a CSV, a database field, or a web form and the break goes too, which is either exactly what you wanted or the source of a confusing import error.

Where the Cursor Has to Be

The break is inserted at the cursor, so you have to be in edit mode first. If the cell is merely selected and you press Alt + Enter, nothing useful happens — in some versions it reapplies the last action instead.

Double-click, or press F2, and look for the blinking cursor inside the cell before you use the shortcut. This is the single most common reason people conclude the shortcut is broken.

How to Add Multiple Paragraphs, Step by Step

For a cell that needs several paragraphs — a notes field, an address block, a list of bullet items in one cell:

1. Select the cell and press F2
2. Type the first paragraph
3. Press Alt + Enter
4. Type the second paragraph
5. Repeat for as many paragraphs as you need
6. Press Enter to commit

To create a visible blank line between paragraphs rather than a single-line break, press Alt + Enter twice in a row. The cell then contains an empty line, which reads as paragraph spacing.

Adding a Break to Text That Is Already There

You do not have to retype anything. Enter edit mode, click immediately before the word that should start the new paragraph, and press the shortcut. Everything from the cursor onward moves down.

If you are working through many cells, the Find and Replace route is faster. Press Ctrl + H, put the delimiter you want to replace in the Find field — a comma followed by a space, for example — and in the Replace field press Ctrl + J. That keystroke enters a line feed character into the box. The field will look empty apart from a faint blinking dot; that is correct.

Replace All then converts every delimiter in the selection into a line break at once. Turn on Wrap Text afterwards or the cells will look unchanged.

Most sites lose traffic to problems they cannot see. Get a free SEO audit and see yours.

Breaking Lines Inside a Formula

When Excel is assembling the text for you, there is no cursor to put a break at, so you concatenate the break character explicitly using the CHAR function.

On Windows, use CHAR(10):

• =A2 & CHAR(10) & B2 joins two cells with a line break between them
• =TEXTJOIN(CHAR(10), TRUE, A2:A5) stacks a whole range into one cell, skipping blanks
• ="Name: " & A2 & CHAR(10) & "Role: " & B2 builds a small labelled block

On older Mac versions of Excel the equivalent is CHAR(13), a carriage return. Current versions of Excel for Mac accept CHAR(10), so use that unless you are maintaining a very old workbook.

Formula-generated breaks do not switch Wrap Text on for you. The formula result will appear on one line, with the break present but invisible, until you enable wrapping manually. This is the second most common reason the technique looks like it failed.

Wrap Text Is Not the Same Thing

These two features get conflated constantly, and keeping them apart will save you a lot of confusion.

• A manual line break is a character stored inside the cell's value. It breaks the line at exactly the point you chose, and it stays there no matter how wide the column is.
• Wrap Text is a formatting setting on the cell. It breaks the line automatically wherever the text runs out of column width, and it re-flows every time you resize the column.

You need Wrap Text switched on for manual breaks to be visible, which is why they so often appear to be the same feature. But they solve different problems: Wrap Text handles overflow, and manual breaks handle structure.

Wrap Text lives on the Home tab in the Alignment group. The keyboard route is Alt + H + W on Windows.

When to Use Which

• Use Wrap Text alone for long prose where you do not care where the lines fall — a description column, a comment field
• Use manual breaks for anything where the line structure carries meaning — postal addresses, name and title pairs, a short list inside one cell
• Use both together for a notes field with deliberate paragraphs that also needs to reflow

When a Multi-Line Cell Is the Right Choice

Multi-line cells are genuinely useful in a narrow set of cases:

• Address blocks on an invoice or letter template, where the address must print as a block but belongs to one record
• Labels and headers that need two short lines rather than one wide column, which keeps a table readable without stretching it
• Print-ready forms, where the layout on the page matters more than the structure of the data
• Short notes attached to a row, where splitting them across columns would be artificial

The common thread is that the output is a document rather than a dataset. When a human reads the cell as a block of text, a line break is the right tool.

Treat your site like a spreadsheet you have never audited. Get a free SEO audit and see what is hiding in it.

Limitations and What Goes Wrong

Multi-line cells have real costs, and they arrive later than the convenience does.

Row height stops auto-fitting after you touch it. Excel auto-sizes the row the first time, but once you drag a row border manually the row is marked as having a fixed height and will no longer grow. Added paragraphs then get clipped silently. The fix is Format, then AutoFit Row Height, or double-clicking the row border.

Merged cells break auto-fit entirely. AutoFit Row Height does not work on merged cells, which is a long-standing limitation rather than a bug. If your multi-line text sits in a merged cell you will be setting row heights by hand forever. Use centre-across-selection formatting instead of merging where you can.

Sorting and filtering treat the cell as one value. A cell with four paragraphs sorts on the whole string, starting with the first character of the first line. Filtering for a term in the third paragraph works, but grouping or pivoting on any part of it does not.

Formulas see the break as a character. LEN counts it. Exact-match lookups fail against a version of the same text without the break. If VLOOKUP or XLOOKUP is mysteriously returning #N/A, a stray line break in one of the two values is a frequent cause. CLEAN(A2) strips non-printing characters including line feeds, and SUBSTITUTE(A2, CHAR(10), " ") replaces them with spaces when you need a flat version.

CSV export is where it really hurts. A line break inside a CSV field is legal only if the field is quoted, and plenty of downstream tools parse it as the start of a new record. One multi-line cell can turn a clean 500-row export into 700 malformed rows. Strip breaks before exporting data that another system will read.

Text-to-Columns can split on the break. If you need to turn the paragraphs back into separate columns, Text to Columns with a custom delimiter will not accept a typed line feed, but it does accept Ctrl + J in the Other box — the same trick as Find and Replace.

The Alternatives Worth Considering

Before committing to multi-line cells, check whether something else fits better.

• Separate columns. If the paragraphs are distinct fields — street, city, postcode — they belong in separate columns, and you can always concatenate them for display. This keeps the data sortable and the export clean. It is the right default for anything you will analyse.
• Cell comments or notes. For commentary that should not affect the data at all, a note attached to the cell keeps the grid clean and never breaks an export.
• A text box. For a block of explanatory copy on a dashboard, a floating text box is easier to position and does not interact with row heights at all.
• Increased row height plus Wrap Text, with no manual breaks. If you only want the text to be readable and do not care where the lines fall, this gets you there with none of the export problems.
• Google Sheets. The equivalent shortcut is Alt + Enter on Windows and Cmd + Enter on Mac, and CHAR(10) works in formulas the same way. If you are moving a workbook between the two, manual breaks survive the trip intact. Our guide to separating data in a cell in Excel covers the reverse operation, for when a multi-line cell needs to become columns again.

Final Thoughts

Alt + Enter is one of those shortcuts that takes four seconds to learn and quietly saves an hour a month. The reason it is hard to find is that nothing in the interface points at it: there is no button, and the obvious key does something else.

Two things are worth remembering beyond the shortcut itself. The first is that Wrap Text and manual breaks are different features that look identical, and a formula-generated break needs Wrap Text turned on by hand before you will see it. The second is that the break is a real character inside your data, so it will follow the cell into lookups, exports and other systems.

Use multi-line cells when the cell is being read as a document. Use separate columns when the cell is being read as data. Almost every problem in this article comes from applying the first pattern to the second situation.

Small fixes compound. Get a free SEO audit and find the ones worth making first.