If you’ve recently switched computers and noticed that the keyboard shortcuts for zooming in and out in Excel (Ctrl+Plus to zoom in, Ctrl+Minus to zoom out) no longer work as expected, don’t worry! This issue is common and can usually be fixed with a few simple tweaks. Instead of zooming, pressing Ctrl+Plus may input today’s date. Here’s how to resolve this and restore the correct behavior.
Why Does Ctrl+Plus Show Today’s Date?
The issue occurs because, by default, Excel assigns the ‘Ctrl+Plus’ shortcut to insert the current date (the DATE function) rather than zooming in. This happens when the zoom function is either disabled or overridden by the date shortcut due to specific settings or conflicts with other keyboard functions.
Steps to Fix the Ctrl+Plus and Ctrl+Minus Shortcuts
Follow these steps to restore the zooming functionality for Ctrl+Plus and Ctrl+Minus:
- Open Excel and go to the ‘File’ menu.
- Click on ‘Options’ to open the Excel Options window.
- Under ‘Advanced’, scroll down to the ‘Lotus Compatibility’ section.
- Ensure that ‘Use system separators’ is selected and the options are set correctly.
- In the ‘Editing options’ section, make sure ‘Zoom on roll with IntelliMouse’ is enabled (this helps with zooming when using the mouse wheel). If it’s already checked, uncheck it and then check it again to refresh the settings.
- Click ‘OK’ to save the changes.
Restore Default Keyboard Shortcuts for Zooming
If the issue persists after adjusting the settings, try the following:
- Press the ‘Ctrl’ key and ‘+’ key together to see if the zoom function returns. If not, you may need to reset your Excel settings to default.
- If you’re still facing issues, you can check for any third-party applications or add-ins that may be interfering with the shortcut keys.
Conclusion
Keyboard shortcut issues in Excel, such as the Ctrl+Plus and Ctrl+Minus not working as expected, are usually easy to fix by adjusting settings in the Excel options menu. By following these steps, you should be able to restore the zooming functionality and continue working without any interruptions. If the problem persists, make sure to check for conflicts with other software or updates for Excel that might have caused the issue.
コメント