Oct 08 2020 06:59 AM
Hello @eosman,
Perhaps the following blog post will help:
https://www.excelforum.com/excel-general/700468-excel-2007-how-to-stop-cell-jumping.html
Oct 08 2020 07:10 AM
If I may suggest, It's always good to add your operating system and Excel version.
If you press the "Enter" key in Excel after entering values or characters in a cell, the cell selection automatically moves on. In the standard setting this will be the cell below. This "jump direction" can be changed manually if necessary.
In the "Tools" menu, click on "Options" and then on the "Edit" tab. Under the "Settings" entry you will find the option "Move highlighting after pressing Enter". Activate the option, if not already done, with a tick.
In the selection menu on the right, you can now specify the direction in which the cell marking should jump, "Down", "Right", "Up" or "Left". Other interesting settings can also be made on this tab, for example you can specify a fixed number of decimal places for your numerical values.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Oct 09 2020 03:08 AM
Oct 09 2020 04:32 AM
With your permission, if I can recommend, It can help us all if you upload an Excel file (without sensitive data), no picture. So you could get a precise solution much faster. This would also be a blessing for us, as we can understand the problem much better, a win-win situation for everyone.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)