Cellwise Start free

Excel guide · 6 min read

Excel keyboard shortcuts not working: causes and fixes

Quick answerWhen a shortcut does nothing, check which kind it is. F-key shortcuts (F2, F4) on a laptop usually need Fn or the Fn lock. If many shortcuts fail, you're probably still editing a cell: press Enter or Esc. A single dead shortcut is usually taken by something else, such as Windows' Ctrl+Shift language hotkey (which blocks Ctrl+Shift+0), Mission Control on a Mac, the browser in Excel for the web, or an add-in. Test in Safe Mode to rule out add-ins.

Still not working on your sheet? Paste your cells and the formula into Cellwise Fix. The engine shows which cause it is on your data, then you get the fix, checked. Open Cellwise Fix

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDEFGH
1DateItemQtyPriceTotalDiscount0.1
2Nov 2, 2026Printer paper box624.5147
3Nov 2, 2026Toner cartridge268136
4Nov 3, 2026Desk lamp33296
5Nov 4, 2026USB-C cable127.2587
6Nov 5, 2026Monitor stand24590

Download this sheet as an Excel practice file (.xlsx)

Quick checks

Work out first whether it's one shortcut, all the F-key shortcuts, or everything. That points straight at the cause.

  • Only F1 to F12 fail (F2 dims the screen, F4 changes volume)? It's the Fn key. See fix 1.
  • Lots of shortcuts fail and the ribbon looks greyed out? You're in edit mode. See fix 2.
  • One Ctrl+Shift shortcut fails on Windows? Check the language hotkey. See fix 3.
  • Keys act as if Shift or Ctrl is held down? Sticky Keys. See fix 4.
  • Shortcuts fail in every program, not just Excel? It's the keyboard or its software, not Excel.

1. F-keys control the laptop instead (Fn lock)

On most laptops, the top row does brightness, volume and media first, and the F1 to F12 functions only when you hold Fn. So F2 (edit cell) dims the screen and F4 (repeat, or switch $ references) does something else entirely. Hold Fn with the key, for example Fn+F4.

To make F-keys the default, turn on Fn lock. On many laptops that's Fn+Esc or a key with a padlock and "Fn" on it, but it varies by maker: some use a setting in the manufacturer's keyboard app or in the BIOS/UEFI (often called "action keys mode" or "function key behavior"). Check your laptop's manual.

On a Mac, open System Settings > Keyboard > Keyboard Shortcuts > Function Keys and turn on "Use F1, F2, etc. keys as standard function keys". F4 is the shortcut people miss most; absolute references shows what it does and Cmd+T, its Mac equivalent.

=C2*D2*(1-$H$1)

Result: 132.3

132.30: six boxes of paper at 24.50 less the 10% discount. Pressing F4 (or Fn+F4) with the cursor on H1 while typing is what adds the $ signs.

2. You're still editing a cell

While a cell is in edit mode (the status bar at the bottom left says Edit or Enter), Excel only accepts commands that make sense inside the text. Many ribbon buttons are greyed out and shortcuts that act on cells, such as inserting rows, sorting or turning on filters with Ctrl+Shift+L, do nothing.

Press Enter to keep what you typed or Esc to cancel, and try the shortcut again. This also explains "Ctrl+Z doesn't work": while you're typing, Ctrl+Z only undoes typing inside the cell.

3. Windows takes Ctrl+Shift (unhide columns)

Ctrl+Shift+0 unhides columns in Excel, but on many Windows PCs it does nothing. Windows uses Ctrl+Shift (or Left Alt+Shift) to switch input languages, and when that hotkey is set to Ctrl+Shift, it catches the combination before Excel sees it. Ctrl+Shift+9 (unhide rows) usually still works.

To fix it, change or turn off the language-switch hotkey. In Windows 11, go to Settings > Time & language > Typing > Advanced keyboard settings > Input language hot keys, choose Between input languages > Change Key Sequence, and set both options to Not Assigned or another combination. Or skip the shortcut: select the columns either side, right-click a column letter and choose Unhide.

4. Sticky Keys or Filter Keys is on

Sticky Keys keeps Shift, Ctrl or Alt "pressed" after you let go, so the next key becomes a shortcut you didn't mean. Pressing Shift five times turns it on, which is easy to do by accident. Filter Keys ignores brief or repeated keystrokes and turns on when you hold the right Shift key for 8 seconds; it can make shortcuts feel like they work only sometimes.

Turn both off in Windows 11 under Settings > Accessibility > Keyboard. If you use them on purpose, they don't break Excel; they only change how the keys are read.

5. Another program or an add-in has the shortcut

Screen recorders, screenshot tools, clipboard managers, chat apps and graphics drivers can register global shortcuts that work in every program, Excel included. If one shortcut fails only while a certain app is running, close that app or change its shortcut settings.

Excel add-ins can also take over shortcuts. Start Excel in Safe Mode, which loads without add-ins: hold Ctrl while you open Excel and say Yes, or press Windows+R and run excel /safe. If the shortcut works there, turn add-ins off one at a time under File > Options > Add-ins (Manage: COM Add-ins > Go) to find it.

6. Mac: Mission Control and Cmd vs Ctrl

On a Mac, macOS uses Ctrl+Left and Ctrl+Right to switch desktops (Mission Control), so they never reach Excel. Use Cmd+arrow keys to jump to the edge of the data instead, or turn those shortcuts off in System Settings > Keyboard > Keyboard Shortcuts > Mission Control.

Many Windows shortcuts use Cmd on a Mac (Cmd+C, Cmd+Z), but not all. AutoSum, for example, is Alt+= on Windows and Cmd+Shift+T on a Mac. Search Excel's help for "keyboard shortcuts in Excel" and pick the Mac tab rather than guessing.

=SUM(E2:E6)

Result: 556

556: the AutoSum shortcut (Alt+= on Windows, Cmd+Shift+T on a Mac) under the totals column enters this formula for you.

7. Excel for the web: the browser gets there first

In a browser, some shortcuts belong to the browser: Ctrl+N opens a new window, Ctrl+T a new tab and Ctrl+W closes the tab, so they can't do their Excel job. Others work only while the focus is inside the grid; click a cell first.

For the full set of desktop shortcuts, open the file in the desktop app (Editing > Open in Desktop App, where available).

8. Ctrl+Z won't undo, and other single-shortcut cases

Ctrl+Z can't undo the actions of a VBA macro: running a macro clears the undo list, so after a macro button there's nothing to undo. Save a copy before running macros you don't know.

Shortcuts that change cells also do nothing on a protected sheet when the selected cells are locked. If the arrow keys scroll the sheet instead of moving the cell, that's Scroll Lock: see Excel arrow keys not working. For Tab, see Excel Tab key not working.

9. Keyboard layout and a different language

Shortcuts with symbols, like Ctrl+; (today's date) or Ctrl+Shift+: (the current time), are tied to key positions on a US layout. On other layouts the symbol may be on a different key, or need AltGr, and the shortcut may not exist as written. If a symbol shortcut fails, check which keyboard layout Windows is using (the language code on the taskbar) and look up the shortcut list for your language.

Shortcuts with letters can also change in non-English versions of Excel. If a guide's shortcut doesn't work, the ribbon KeyTips always do: press and release Alt and follow the letters shown. Starting with the basics? See Excel shortcuts for beginners.

Common mistakes

Repairing Office for an Fn key problem

If only F-keys fail on a laptop, try Fn+F2 first. It's a laptop setting, not an Excel fault.

Pressing shortcuts while the cell is still being edited

Press Enter or Esc first. The status bar shows Ready when shortcuts that act on cells will work.

Assuming Ctrl+Shift+0 is broken in Excel

It's the Windows language hotkey. Change it, or right-click the column letters and choose Unhide.

FAQ

Why are my Excel shortcuts not working?

The usual causes are the Fn key on a laptop (for F1 to F12), being in edit mode, Sticky Keys, or another program or add-in using the same keys. Test the shortcut in Safe Mode and in another program to narrow it down.

Why does F2 not work in Excel?

On most laptops F2 controls brightness unless you hold Fn or turn on Fn lock. On a Mac, F2 is also a brightness key by default; use Fn+F2 or turn on standard function keys.

Why does Ctrl+Shift+0 not unhide columns?

Windows uses Ctrl+Shift to switch keyboard languages and catches it first. Change the input-language hotkey in Windows settings or use right-click > Unhide.

How do I reset keyboard shortcuts in Excel?

Excel for Windows has no setting to remap its built-in shortcuts, so there's nothing to reset: if one has stopped working, something outside Excel, an add-in or a macro is taking it. Excel for Mac does let you change them, under Tools > Customize Keyboard, so check there for a changed shortcut.

Functions used

Related guides

Updated