Can't enter data in Excel spreadsheets

Question

When I try to type data in a cell, it jumps to a different cell and won't accept new data

Answer 1

Hi @Blair, Ben,

Thank you for posting your question in the Microsoft Q&A forum.

According to your concern, there are several reasons that can cause that behavior, so can you please share more details about what action triggers the jump (when you press Enter/Tab or something else, etc.). This will help clearly clarify which is the main reason causing the situation.

In the meantime, you can try some basic troubleshooting steps:

1/ Open Excel safe mode    

• Press Windows + R to open Run dialog box and type excel /safe > press OK to run.   
• If Excel opens normally, the problem is due to an add-in.    
• Then and go to File > Options > Add-ins > select Excel Add-ins > Go > uncheck all listed add-ins and click OK. Repeat the same steps with the COM add-ins 

• Restart Excel and check if the error is gone. Then re-enable the add-ins one by one and restarting Excel each time to find which one causing the error.

2/ Reset Excel default settings 

• Press Windows + R and type regedit then OK  
• In the bar, paste this address to navigate to the correct path: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel  
• Right-click the Excel key and press Delete. After that restart Excel to see if the issue persists.  

3/ Repair Office   

• Go to Control Panel > Programs > Programs and Features.  
• Find Microsoft Office, right-click, and choose Change.   
• Select Quick Repair. If that doesn’t work, try Online Repair.   

Please understand that my initial response does not always resolve the issue immediately. However, you can try these steps and let me know if it works for you. If not, we can work together to find the solution

If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you.  

Thank you for your patience and your understanding. I look forward to your response.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

If you are experiencing issues where typing data in a cell causes the selection to jump to a different cell, it may be due to several reasons. Here are some potential solutions:

1. Check for Sticky Keys: Ensure that the Sticky Keys feature is not enabled on your keyboard, as this can cause unexpected behavior when typing.
2. Cell Protection: Make sure that the cells you are trying to edit are not locked or protected. If the worksheet is protected, you will need to unprotect it to make changes.
3. Excel Settings: Sometimes, specific settings in Excel can cause this behavior. Check your Excel options to see if any settings might be affecting cell input.
4. Excel Add-ins: Disable any add-ins that might be interfering with normal Excel operations. You can do this by going to File > Options > Add-ins and managing your add-ins.
5. Reboot Excel: Close and reopen Excel to see if the issue persists. Sometimes, a simple restart can resolve temporary glitches.
6. Update Excel: Ensure that your Excel application is up to date, as updates often fix bugs and improve functionality.

If none of these solutions work, consider checking for any known issues with your version of Excel or reaching out to Microsoft support for further assistance.

---

References:

• Error Message: That command cannot be used on multiple selections