How to add or insert a line break or carriage return in a cell in Excel

Want to add insert line breaks and carriage returns from a cell in your Excel file?

Let’s say, we have the following example:

John Smith

But now we need these two words to appear on two separate lines instead of a single line, just like this:

John
Smith

There are two options to get the job done.

Option 1

Launch a Microsoft Word or a Notepad file. Enter the text (including the line break) that you’d like to insert into your Excel cell. Copy and paste those text into the cell.

Option 2

Use the shortcut Alt+Enter to put the last name on a new line.

This entry was posted in Functions. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*