Search a topic here:

Wednesday, June 26, 2019

New Line In The Same Cell in Excel: ALT + Enter

Have you ever wondered how to create a new line in the same cell in Excel?

Let us say you want this in the same cell:

Name: John Doe
Age: 21









Maybe some of you press the space bar several times until you reach the second line.

Well you just need to press ALT+Enter at the last word of your first line (for the above example - after Doe), then it will direct you to the next line.

Try ALT+Enter

Viola!

No comments:

Post a Comment