How can I make the 'enter' key on the keyboard give a line-feed rather than sending the cursor to the next cell down?

When typing in a cell in Calc the enter key sends the cursor to the next cell down the column - can I make it give a line-feed - start a new line within the cell as it would in Write?

Use Ctrl+Enter

Thanks - so simple

thank you, been trying to figure this out for awhile now!

Use Ctrl & Enter.

If this answers your question please click on the :heavy_check_mark: (upper left area of answer).

Many thanks

Replace the shortcut function of “F2” with “Enter”.

Go to Tools/Customize, delete the shortcut of “F2” and in the “Enter” shortcut insert the “Cell Edit Mode”.

Modify-OK