How to Insert a Return in an MS Excel Cell

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Enter a return with a keyboard shortcut.

Microsoft Excel is a program that you can use to enter, format and manipulate large amounts of data. There may be times when you want to enter several rows of data into a cell. However, while pressing the "Enter" key in a word-processing program may produce a new line, all that key does in Microsoft Excel is move you to the next cell down. In order to insert a hard return into a cell, you need a keyboard shortcut.

Advertisement

Step 1

Click on the cell where you would like to enter the return.

Video of the Day

Step 2

Press the "Alt" key and keep it held down.

Step 3

Press the "Enter" key, making sure you are holding the "Alt" key down at the same time. Excel enters a return into the cell.

Advertisement

Video of the Day

Advertisement

Advertisement

references