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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Carriage Return in Excel

April 9, 2021 by Andrew Childress
Add carriage return in Excel

A carriage return lets you add multiple lines of text inside a single spreadsheet cell. Let’s learn how to add a carriage return in Microsoft Excel.

A carriage return lets you add multiple lines of text inside a single spreadsheet cell. Let’s learn how to add a carriage return in Microsoft Excel.

How to Add a Carriage Return in Microsoft Excel

Imagine that you want to type in a city and state in Excel. You want them stacked:

Charleston,

South Carolina

But you don’t want to use multiple cells. You want all three words to exist in a single cell. Fortunately, this is easy in Excel. It’s called a carriage return, and let’s look at how to add one in a cell.

Begin by clicking into any cell in your workbook. Then, type in your first word. In this case, type Charleston.

Carriage return in Excel

Your next step will vary slightly based on whether you’re working on a Mac or PC. If you’re on Mac, press Control + Option + Return on your keyboard simultaneously. If you’re using a PC, your keyboard shortcut is Alt + Enter.

Watch as Excel adds a carriage return in the cell. Now, all you have to do is finish typing in your words. You can do this as many times in a cell as you’d like.

Add carriage return in Excel

If you don’t see your text in multiple cells, make sure that Wrap Text is activated for the cell in question. With the cell selected, go to the Home tab and click on Wrap Text if it isn’t shaded in gray.

How to add a carriage return in Excel

How to Add a Carriage Return to Existing Text

Have text already in a cell, and want to break it across multiple lines with a carriage return? Simple.

Double-click into the cell, as you would if you were changing the text inside. Then, with your arrow keys, place your cursor at the point where you want to add the carriage return. Remove the space between words, then press Control + Option + Return (Alt + Enter on Windows).

Insert carriage return in Excel

The carriage return will be inserted.

As you can see, it’s incredibly easy to add a carriage return in Excel.

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

About Andrew Childress

Previous Post:Vlookups in Microsoft ExcelVLOOKUP in Excel
Next Post:#REF! in Excel#ref! 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