PlayInfoBox

Home /Utilities /How to Add a Line Break Inside a Cell in Excel

How to Add a Line Break Inside a Cell in Excel

Tap a step to see how to add a line break inside an Excel cell.

  1. Double-click the cell

    Double-click the cell where you want to enter text to switch it into edit mode.

  2. Place your cursor where you want the break

    Position your cursor at the point in the text where you want to start a new line.

  3. Press Alt + Enter

    On Windows, press "Alt + Enter"; on Mac, press "Option + Enter" to start a new line within the same cell.

  4. Turn on "Wrap Text" as well

    Turning on "Wrap Text" under the "Home" tab lets the cell height adjust automatically to fit the content.

  5. Why it helps

    It's useful for neatly organizing information that needs multiple lines, such as an address or a note, all within a single cell.

When Pressing Enter Just Jumps to the Next Cell

In Excel, simply pressing Enter moves you to the next cell, so you can't start a new line within the same cell that way. Remembering one keyboard shortcut solves this easily.

Check Out Filtering Too

Once your data is neatly organized across multiple lines, applying a filter can help you quickly find the specific rows you need in a larger spreadsheet.

Frequently Asked Questions

Is the shortcut different on a Mac?

Yes. On Excel for Mac, instead of "Alt + Enter," you use "Option + Enter" or "Control + Option + Return."

Can I merge a line-broken cell back into a single line?

Yes. Position your cursor at the line break and press Delete or Backspace to remove it, which merges the text back into one line.