I have a calc spreadsheet that contains cells created with the intention that they be filled out in a certain order.
However, due to other factors, these cells cannot be laid out in sequence/ one after another, they must remain “jumbled up”.
So I wonder, is there any way to set the selected cell to “jump” to another cell once the “enter” key is pressed?
For example, normally when the enter key is pressed in a spreadsheet, the cursor/highlighted cell moves down to the cell directly below it, e.g when the cell A1 is highlighted then the enter key is pressed, the selected cell becomes A2.
Instead, could I, for example, set A1 to become A5 when the enter key is pressed, or B2 to become F2 etc…?