• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

New Line in Excel

March 22, 2021 by Andrew Childress
New line in Excel

Excel cells don't only contain one line of text each, you can add multiple lines. Let’s learn how to add a new line in Microsoft Excel.

It’s easy to think that Excel cells only contain one line of text each. But in fact, you can add multiple lines. Let’s learn how to add a new line in Microsoft Excel.

How to Add a New Line in Excel

Suppose you’re typing someone’s first and last name into a single cell in Excel. By default, they’ll appear side by side:

John Smith

But you might want it to read:

John

Smith

Of course, you could always hit Enter and simply type the last name into the cell immediately below. But in many cases, you’ll want both words in the same cell.

To add a new line in Excel, begin by simply typing in the first word or characters in your sequence. In this case, you’ll type John into cell A1. 

John new line Excel

 

Now, it’s time to deploy a quick keyboard shortcut. If you’re on Mac, press Control > Option > Return on your keyboard simultaneously. (On Windows, use Alt + Enter). You’ll see your cursor immediately jump below the word you typed, and from here, you can finish the name.

New line cursor Excel

But notice that you’re not in a new cell. You’ve added a new line to a single cell. You can do this as many times as you’d like. It’s an easy way to format your Excel data differently, without spilling into adjacent cells.

New line typed Excel

On occasion, you may find that your data still appears in a single cell. Fortunately, this is easy to fix. It’s driven by the way Excel typically displays data within cells. If you find yourself in this situation, go to the Home tab on Excel’s ribbon. Near the middle, you’ll see the Wrap Text command.

How to add new line in Excel

If you’re having an issue, be sure this is enabled. Once it is, your text will appear on a new line as intended. As you can see, it’s easy to add new lines in Excel to format your data exactly as you want it.

Category: Excel ShortcutsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Transpose data in ExcelTranspose in Excel
Next Post:Split Cells in ExcelSplit cells in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top