when editing a cell in Excel, how can you create a new line, since hitting ENTER just jumps to the next cell?

Question

I have text in an Excel cell, and I hit F2 so that I'm in editing the contents of this cell. I want to hit ENTER to add a new line break, but instead ENTER just makes the cursor jump down to the next cell.
How do you add a new line break within a cell when editing it?

Answer 1

Hold the ALT key and hit enter.

Answer 2

Hold the ALT key and then press ENTER in the cell you're editing. You'll need to repeat the step if you want to have one or more lines of space before entering more text.

Answer 3

While pressing Alt key, hit Enter.

Answer 4

not sure about excel, but I know in many other programs if you hold SHIFT while pressing enter it works. I use OpenOfficeOrg, which is a free 'fake' version of Microsoft products like Word and Excel, and in their 'Excel' program, holding CTRL and enter does what you are asking. So try SHIFT or CTRL, one should work

Answer 5

Just right click on the cell and next click "insert"

Answer 6

You right click and hit insert then you choose if you want one cell or entire row, . then you hit okay and it should do it

Answer 7

right click the cell and push insert

Answer 8

try shift+enter or control+enter