Ask Your Question

Use enter key to move cursor down in Calc spreadsheet

asked 2019-01-06 02:14:14 +0100

mkostrem gravatar image

updated 2019-01-06 02:15:01 +0100

Under Tools - Options - General - Input Settings, there is a checkbox for Press Enter to Move Selection Down. But it doesn't accomplish what I need: to enter a value in a cell, then have the cursor go to the next cell down.

edit retag flag offensive close merge delete


What does happen when you press Enter with that option checked and with Down selected on the dropdown?

robleyd gravatar imagerobleyd ( 2019-01-06 02:57:15 +0100 )edit

Nothing. The cursor remains where it is.

mkostrem gravatar imagemkostrem ( 2019-01-06 23:16:13 +0100 )edit

Makes no sense to me. The default is to move the cell cursor to the next cell below after one closes input with Enter and that works about ~everywhere. If it doesn't work for you, then check that your Enter key is actually an Enter key.. ;-) i.e. not redefined to send some different key code.

erAck gravatar imageerAck ( 2019-01-07 16:41:39 +0100 )edit

Thank you. Now that I know it has been set to the default, I will look for other explanations such as you suggest. :>

mkostrem gravatar imagemkostrem ( 2019-01-07 20:10:31 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-04-02 02:13:04 +0100

mkostrem gravatar image

Go to Tools, Customize, Keyboard. Select Enter, and then Reset. The default value is Move Down. Hallelujah!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-06 02:14:14 +0100

Seen: 925 times

Last updated: Apr 02 '20