Excel Won’t Let You Click Cells? The Fixes Most People Miss

Excel Won’t Let You Click Cells? The Fixes Most People Miss

Your Excel arrow keys suddenly scroll the whole sheet instead of moving between cells — or clicking a cell does nothing at all. Before you restart your PC for the fifth time, know this: in most cases the culprit is a single stuck key, a protected sheet, or one misbehaving add-in. Whether your Excel arrow keys aren’t working or entire cells seem greyed out and unclickable, these five fixes cover the lot — in the order you should try them.

Person working on a laptop with a spreadsheet at a desk

1. Check Scroll Lock First

If the arrow keys scroll the screen instead of moving the cell cursor, Scroll Lock is almost always to blame.

  • Look for a ScrLk key on your keyboard and press it once. On many laptops you’ll need Fn + ScrLk.
  • No ScrLk key? Open the Windows search bar, type On-Screen Keyboard, launch it, and click the ScrLk button there to toggle it off.
Close-up of a computer keyboard with the Windows key in focus

2. Unprotect the Sheet

A protected sheet limits which cells you can select or edit — sometimes it was turned on ages ago and forgotten.

  1. Go to the Review tab on the ribbon.
  2. If you see Unprotect Sheet, click it.
  3. Enter the password if prompted.

3. Clear Frozen Panes

Corrupted freeze panes can make certain areas of a sheet behave oddly when clicked.

  1. Open the View tab.
  2. Click Freeze Panes.
  3. Select Unfreeze Panes.
Professional working at a desk in a modern office

4. Disable Faulty Add-Ins

PDF converter add-ins are a known cause of broken mouse-click behavior inside Excel.

  1. Click File > Options > Add-ins.
  2. At the bottom, choose COM Add-ins and click Go.
  3. Untick anything you don’t actually need.
  4. Restart Excel and test again.
Business person reviewing financial charts on a laptop

5. Start Excel in Safe Mode

If nothing above worked, rule out corrupted Excel settings:

  1. Press Win + R.
  2. Type excel /safe and hit Enter.
  3. Test whether cell clicks work normally in Safe Mode. If they do, an add-in or setting is the cause — go back to step 4.

The Bottom Line

Nine times out of ten, a cell-selection problem in Excel comes down to Scroll Lock or a conflicting add-in. Work through these five fixes top to bottom and you’ll almost certainly be back to normal in under five minutes.

TL;DR: 90% of the time it’s Scroll Lock — check that first, then sheet protection, then add-ins.

If this guide got your spreadsheet unstuck, bookmark SmartFixDaily for more quick fixes — and share it with the coworker whose Excel is “acting weird.”

Frequently Asked Questions

How do I turn off Scroll Lock without a ScrLk key?

Launch the On-Screen Keyboard from the Windows search bar and click its ScrLk button — it toggles Scroll Lock off even on keyboards without the key.

Why can’t I click cells but typing still works?

That combination usually points to sheet protection rather than Scroll Lock. Go to Review > Unprotect Sheet to restore full cell selection.

Why are my Excel arrow keys scrolling instead of moving cells?

Scroll Lock is enabled. Press ScrLk (or Fn + ScrLk on laptops) once, and arrow-key cell navigation returns immediately.

What if Excel only works in Safe Mode?

Then an add-in is almost certainly the cause: File > Options > Add-ins > COM Add-ins > Go, disable add-ins one by one, and restart Excel after each to find the offender.

Photo credits: Pexels contributors.