It seems like you are experiencing an issue with Excel where the selected cell does not match the mouse position when opening another worksheet in the same workbook. This could be related to several factors such as display settings, Excel settings, or even potential bugs in the software.
Here are a few troubleshooting steps you can try:
- Check for Updates: Ensure that you have the latest updates for Office installed. Sometimes, bugs are fixed in newer updates.
- Test in Safe Mode: Open Excel in Safe Mode to see if the issue persists. You can do this by holding down the
Ctrlkey while starting Excel. If the problem does not occur in Safe Mode, it may be related to add-ins or custom settings. - Adjust Display Settings: Sometimes, display settings can cause issues with how Excel renders cells. Check your display settings in Windows and ensure they are set to recommended values.
- Change Zoom Level: As you've mentioned, changing the zoom level temporarily resolves the issue. This could indicate a rendering issue that might be addressed in future updates.
- Repair Office: You can try repairing your Office installation. Go to Control Panel > Programs > Programs and Features, select Microsoft Office, and then click on Change. Choose the Repair option.
- Contact Support: If none of the above solutions work, consider reaching out to Microsoft Support for further assistance.
If the issue persists after trying these methods, it may be a bug that needs to be reported to Microsoft.