New Line in Cell in Excel: How to Start a New Row

A keyboard shortcut is the fastest way to do that

2 min. read

Published onSeptember 26, 2024

published onSeptember 26, 2024

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Many users don’t know that they can make a new line in a cell in Excel, and this is easier than you think. If you wish to learn how to do it, keep on reading.

How do I make a new line within a cell in Excel?

1. Use the keyboard shortcut

This shortcut will let you make a new line in the Excel cell in a matter of seconds, so don’t hesitate to try it.

2. Use the Wrap Text option

3. Use the formula

In case this looks confusing to you, this formula adds an Excel new line character, CHAR(10), in the cell between the two values.

How do you press Enter in Excel and stay in the same cell?

This is possible only if you use theAlt+Entershortcut.

As you can see, it’s pretty simple to create a new line in Excel cell, and the fastest way to do that is with a keyboard shortcut, but more advanced users might be interested in using formulas instead.

Speaking of formulas, many reported that theExcel formula is returning 0while others reported a#VALUE Error in Excel.

Lastly, don’t miss our guide on what to do if theformula omits adjacent cells in Excel.

New Line in Cell in Excel: How to Start a New Row#

How do I make a new line within a cell in Excel?#

1. Use the keyboard shortcut#

2. Use the Wrap Text option#

3. Use the formula#

How do you press Enter in Excel and stay in the same cell?#