How I can Stay In The Same Cell After Pressing The Enter Key With Shortcut Keys?
Hello @ASIFahmed, If you need to repeatedly change values, use a cell next to the column or row headings; there you can write and accept by pressing the arrows in the direction of the titles (or with Shift+Enter or Shift+Tab if edited the cell content).
Please, click edit below your question if you want to add more information.
…Pressing The Enter Key With Shortcut Keys…
What shortcut keys are you talking of? Did you probably keep pressed a modifyer key (Shift / Ctrl / Alt) at the same time as the Enter key?
Did you disable the option >Tools>Options>LibreOffice Calc>General>>Press Enter key to move selection… ?
1 Like
Alt + Enter worked for me. Thank you. I am using Libre Office 7.0.3 on Windows 10.
Sorry! There seems to be a misunderstanding.
I did not suggest to use the Alt modifyer. It should be used for a different purpose.
I asked what keys you were talking of.
To use Enter together with the modifiers Ctrl, Alt, Shift+Ctrl is assigned to very special functionality.
Continue reading my answer.
Select the cell,Âą then you can enter values and formulas, and the cell will remain selected, regardless of whether you press Enter, Shift+Enter, Tab or Shift+Tab.
Âą Shift+Down Arrow-Up Arrow or Shift+Right Arrow-Left Arrow, Shift+Up Arrow if in row 1, Shift+Left Arrow if in column A.
Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.
Check the mark (
→ 
) to the left of the answer that solves your question.
If the answer helped you, you can mark the up arrow (
) that is on the left (to vote, you need to have karma of at least 5).
If you are annoyed by a move to a different cell after having quit editing a cell using the Enter key, the only reasonable way is, to disable the option >Tools>Options>LibreOffice Calc>General>>Press Enter key to move selection…
Ctrl+Enter would insert a hard line break into the textual content of the cell, Alt+Enter is assigned to the functionality of entering the same content into all the cells that were selected in advance, and Shift+Ctrl+Enter is specialized to entering formulas for array-evaluation.
Don’t mix all that up.