When a shortcut you've learned stops working, it's almost always an environment or settings issue, not an error in how you're pressing it. Work through the common causes in order.
Shortcuts you will master in this article
Ctrl + Z / Ctrl + Shift + L / Ctrl + 1
The majority of cases where Excel shortcuts suddenly stop working come down to three causes: Japanese IME input is active, a function key behavior is affected by NumLock state, or workbook/sheet protection is restricting the operation.
On Mac or the web version of Excel (Office 365 Online), key assignments differ, so shortcuts memorized on Windows may not work as expected. Identifying your environment before troubleshooting is the fastest path to a solution.
A prioritized sequence for narrowing down the cause.
Check the IME (Japanese input) stateWith IME active, shortcuts like Ctrl+H, Ctrl+F, and Ctrl+1 may not function correctly. Check the input mode in the taskbar and switch to 'A' (half-width alphanumeric) before trying again.
Tip: Ctrl+F and Ctrl+H in particular often fail to open their dialogs when IME is on.
Check the NumLock stateIf F2, F4, F5, and similar function keys don't behave as expected, NumLock may be involved. Try pressing the NumLock key to toggle its state.
Tip: On laptops, function keys may require the Fn key depending on your configuration.
Check for sheet or workbook protectionIf you see a 'Sheet is protected' message, go to Review → Unprotect Sheet.
Tip: A password is required if one has been set.
Confirm whether you're on Mac or the web versionOn Mac, many Ctrl shortcuts use Cmd instead. In the browser version of Excel, some shortcuts conflict with browser-level shortcuts.
Tip: Ctrl+F conflicts with the browser's own search shortcut, so it may not work in web Excel.
Check for conflicting shortcut assignmentsAdd-ins or VBA macros can overwrite shortcuts. Disable them from File → Options → Add-ins to test.
Tip: Starting Excel in Safe Mode (hold Windows key while launching Excel) runs it without add-ins, which helps isolate the issue.
Excel Shortcut Practice
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + Z | Undo |
Ctrl + Shift + L | Toggle AutoFilter |
Ctrl + 1 | Format Cells Dialog |
Ctrl + F | Find |
Ctrl + H | Replace |
A. This commonly happens when Japanese IME is active. Switch the input mode to half-width alphanumeric and try again.
A. Try Cmd+1 on Mac. Some shortcuts map Ctrl to Cmd, though Cmd+1 may be assigned to a different function in your setup.
A. Keys that conflict with browser-level shortcuts can't be used in web Excel. Ctrl+F (browser search) is the most common example.
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →