Excel do MacOS não funciona Tab nem Return para avançar células

Question

Costumamos usar o excel no MacOS com frequência e ontem me deparei com um problema inusitado, de repente, eu não conseguia mais usar o return, o Tab, ou as setas para passar de célula (isso quando a célula estava clicada, caso estivesse só passando por cima funcionava normal), não sei se isso é uma opção que foi acidentalmente ativada por mim, mas todas minhas planilhas estavam ocorrendo isso, até que decidi reiniciar o MacOS, então a princípio voltou a funcionar, mas as vezes esse problema volta a ocorrer, alguém sabe o que pode ser?

Answer 1

Dear Alexandre Breus da Cunha,

Good day to you!

I hope you are doing well. Thanks for reaching out to our Microsoft Community Forum. We will be happy to help you. 

Based on your description, you are experiencing issues with the Excel application on your macOS. This problem could be caused by factors such as Excel add-ins, conflicts between the Office version and macOS version, or specific keyboard settings.

In this situation, I would recommend you move your Excel cache folder to the Desktop. The local cache files for Excel are stored in the: “/Library/Containers/Microsoft Excel”.

Since you mentioned that the “Return” key doesn’t work intermittently, it would be helpful if you could share your current Excel settings. This will allow me to verify and provide more tailored guidance to address the issue effectively.

To share your Excel settings, please follow these steps:

1. Open the Excel application.
2. Click on the Excel tab in the menu bar.
3. Select Preferences from the dropdown menu.
4. Go to Edit and take a full screenshot of this section.

Additionally, to assist further, I would appreciate it if you could provide the following:

• A screenshot of the Excel application version you are using (you can find this under Excel > About Excel).
• Your current macOS version (to check this, click the Apple logo in the top-left corner > About This Mac).

We need to first clarify the information before we can determine the subsequent troubleshooting plan, so we are sorry that we cannot directly provide a solution.

I am looking forward to your response for further assistance.

Thank you for your understanding. Your cooperation and contributions are highly appreciated.

Best Regards,

Nahid Sultan