Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1758955%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758955%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20enter%20data%20into%20a%20cell%20the%20cell%20prompt%20jumps%20to%20another%20cell.%20It's%20the%20same%20on%20all%20my%20workbooks%20and%20a%20new%20spreadsheet.%20How%20do%20I%20correct%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1758955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1758979%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1758979%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F824927%22%20target%3D%22_blank%22%3E%40eosman%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20the%20following%20blog%20post%20will%20help%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelforum.com%2Fexcel-general%2F700468-excel-2007-how-to-stop-cell-jumping.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excelforum.com%2Fexcel-general%2F700468-excel-2007-how-to-stop-cell-jumping.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

When I try to enter data into a cell the cell prompt jumps to another cell. It's the same on all my workbooks and a new spreadsheet. How do I correct it?

 

4 Replies
Highlighted
Highlighted

@eosman 

 

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.

Highlighted
Hi Nikolino,
Have tried that advice but no change. As soon as I enter data into a cell H6 in particular, the cursor jumps further down the spreadsheet and no data is shown in H6. Regards Eosman
Highlighted

@eosman 

 

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)