Arrow Keys not Working in Excel (Not Moving Cells)

If you press the down arrow key in Excel and the cursor stays put, or the whole sheet scrolls instead, it can feel like the keyboard has stopped working. In most cases, the keyboard is fine.

Excel has a few modes and settings that take over the arrow keys, and each one shows a clue somewhere on the screen.

In this tutorial, I’ll show you how to spot which one is causing the problem and how to fix it. The first fix (Scroll Lock) sorts it out for most people.

First, Check Why the Arrow Keys Are Not Moving Cells

Before you change any settings, look at three things on the screen. Together they tell you which fix you need, so you don’t have to try all of them.

Below I have a small grocery order list in cells A1:D11. Cell A2 is selected, and pressing the down arrow should take me to A3.

Here is what to look at:

1. The Name Box. This is the small box at the top left, just above column A. It shows the address of the active cell. Press an arrow key and watch it. If it changes from A2 to A3, the arrow keys are fine. If it stays on A2, the cursor isn’t moving.
2. The status bar. Look at the bottom left corner of the Excel window. It normally says Ready. If it shows Scroll Lock, Edit, Point, or Extend Selection, that tells you what’s going on.
3. The mouse. Click any cell. If the mouse can’t select a cell either, the sheet is protected and the keyboard was never the problem.

Here is the same thing as a quick lookup:

What happens when you press an arrow key	Likely cause	Fix
The sheet scrolls but the Name Box shows the same cell	Scroll Lock is on	Turn off Scroll Lock
The cursor moves inside the cell text, or a cell reference gets added to a formula	You’re in Edit or Point mode	Press Esc
The selection grows by one cell with every press	Extend Selection mode is on	Press F8
A shape, chart, or picture nudges around instead	An object is selected	Click a cell
Nothing moves and the mouse can’t select a cell either	The sheet is protected	Unprotect the sheet
Nothing moves, the mouse works, and the status bar says Ready	An add-in is interfering	Disable add-ins

The fixes below are in the order I would try them, with the most common one first.

Turn Off Scroll Lock to Fix the Arrow Keys in Excel

Scroll Lock is the cause most of the time. When it’s on, the arrow keys scroll the worksheet instead of moving the cursor.

Below I have the same grocery list in A1:D11 with A2 selected. Scroll Lock is on, so pressing the down arrow slides the whole sheet up by a row while the Name Box still says A2.

You will also see the words Scroll Lock at the left of the status bar in Excel. Excel shows this by default, so if you can’t see it, someone has hidden it. Right-click the status bar and check Scroll Lock to bring it back.

Turn Off Scroll Lock with the Keyboard

If your keyboard has a Scroll Lock key (usually labeled ScrLk, near Print Screen), press it once. It’s a simple toggle, so one press turns it off.

Many keyboards also have a Scroll Lock light that goes off when it’s disabled.

Note: Laptops without a ScrLk key don’t have one universal shortcut for it. It varies by brand (Fn + S, Fn + C, and Fn + K are common). If nothing obvious works, use the on-screen keyboard below instead of guessing.

Turn Off Scroll Lock with the On-Screen Keyboard

With laptops getting smaller and sleeker, many keyboards don’t have a Scroll Lock key at all. If Scroll Lock got switched on somehow, you can still turn it off using the On-Screen Keyboard in Windows.

Here are the steps:

1. Press Windows + Ctrl + O to open the On-Screen Keyboard. You can also search for “On-Screen Keyboard” in the Windows search bar.

2. Click the ScrLk key. It’s highlighted while Scroll Lock is on, and the highlight clears when you click it.

Go back to Excel and press an arrow key. The Name Box should move now, and the Scroll Lock text disappears from the status bar.

Pro Tip: Scroll Lock is a Windows setting, not an Excel setting. Closing and reopening Excel won’t turn it off.

If you’re on a Mac, press Shift + F14 to toggle Scroll Lock. Depending on the keyboard, you may need Control, Option, or Command instead of Shift. A MacBook keyboard has no F14 key, so you would need an external keyboard for this.

For more ways to do this, here is a detailed guide on how to turn off Scroll Lock in Excel.

Press Esc to Exit Edit Mode

If Excel thinks you’re still typing inside a cell, the arrow keys move the text cursor within that cell instead of moving between cells.

Below I have the same grocery list. I double-clicked cell A2 to read the item name, and now the arrow keys just move through the letters of “Bananas”.

The status bar at the bottom left says Edit instead of Ready. You get here by double-clicking a cell, pressing F2 to edit the cell, or starting to type and then getting distracted.

Something similar happens while you’re writing a formula. If you type =SUM( and then press an arrow key, Excel adds a cell reference to the formula instead of moving. The status bar says Point while this is happening.

Both have the same fix. Press Esc. The status bar goes back to Ready and the arrow keys move between cells again.

Pro Tip: Esc throws away whatever you were typing in that cell. If you want to keep the edit, press Enter or Tab instead. Both commit the entry and take you back to Ready mode.

Turn Off Extend Selection Mode (F8)

Excel has a mode where the arrow keys stretch your selection instead of moving it. You turn it on with the F8 key (one of the lesser-known Excel keyboard shortcuts), and it’s easy to hit by accident.

Below I have the same grocery list with A2 selected. Every time I press the down arrow, the highlighted block grows by one more row instead of the cursor moving down.

The status bar says Extend Selection, which confirms F8 was pressed.

To turn it off, press F8 again (or press Esc). The status bar returns to Ready and the arrow keys go back to moving one cell at a time.

Note: If the selection keeps growing even after pressing F8 and Esc, a Shift key may be stuck down. Holding Shift while pressing an arrow does the same thing as Extend Selection. Tap both Shift keys once each and try again.

Click a Cell to Deselect the Object

If your sheet has pictures, charts, or shapes on it, this one is worth checking, because it doesn’t look like an arrow key problem at all.

When you click an object, Excel hands the arrow keys over to it. Instead of moving the cursor, they nudge the object a tiny bit at a time.

Below I have the same grocery list with a shape next to it. I clicked the shape, and now every arrow press moves the shape a fraction while the cell cursor stays on A2.

Two things give it away. The object has resize handles around its edge, and the Name Box shows the object’s name (something like Rectangle 1) instead of a cell address.

The status bar still says Ready, which is why this one is easy to misread. You’re not stuck in any mode. Excel is simply working on the object instead of the cells.

To fix it, press Esc or click any cell in the sheet. The object is deselected and the arrow keys go straight back to moving between cells.

Note: If you pressed the arrows a few times before you noticed, the object has moved. Press Ctrl + Z until it’s back in place, then click a cell.

Unprotect the Sheet

If the Name Box and status bar look normal, try the mouse. If you can’t select a cell with the mouse either, the sheet is protected and cell selection has been turned off.

This is a useful test, because Scroll Lock and the other modes never stop the mouse from selecting a cell.

Below I have the same grocery list. Nothing selects, by keyboard or by mouse, and the Review tab shows Unprotect Sheet where Protect Sheet normally sits.

Here are the steps to unprotect the sheet:

1. Click the Review tab, then click Unprotect Sheet.

2. If the sheet has a password, type it in the dialog box and click OK.

The arrow keys work again right away. If you don’t know the password, here is how to unprotect an Excel sheet without the password.

One thing worth knowing: protecting a sheet with the default settings does not break the arrow keys.

When you click Protect Sheet, Excel keeps “Select locked cells” and “Select unlocked cells” checked. With those checked, you can still move around everywhere. You just can’t change anything.

The arrow keys only stop when “Select locked cells” is unchecked. Since every cell is locked by default, there is nowhere left for the cursor to go.

If the sheet has some unlocked cells, the arrows jump between those and skip the rest. That is how data-entry forms are often set up.

Disable Add-ins and Check

If you’ve worked through everything above and the arrow keys are still dead, an add-in could be the cause. Some add-ins in Excel watch for keystrokes, and a badly behaved one can swallow the arrow keys before Excel sees them.

Below I have the same grocery list. The Name Box won’t move, the status bar says Ready, and the mouse selects cells without any problem.

The quickest test is to open Excel in Safe Mode, which loads with every add-in switched off.

Here are the steps to test for a misbehaving add-in and switch it off:

1. Close Excel. Press Windows + R, type excel /safe, and press Enter. Open your workbook and try the arrow keys. If they work here but not normally, an add-in is the cause. If they’re still dead in Safe Mode, go back through the earlier fixes.

2. Close Safe Mode and start Excel normally. Click the File tab, then click Options. This opens the Excel Options dialog box.

3. Click Add-ins in the left pane. At the bottom, set the Manage drop-down to COM Add-ins and click Go.

4. In the COM Add-ins dialog box, uncheck every add-in and click OK.

Close the workbook, open it again, and check the arrow keys. If they work now, turn the add-ins back on one at a time, testing after each. The one that breaks the arrows again is the one to leave off.

If unchecking the COM add-ins changed nothing, go back to the same screen, set Manage to Excel Add-ins, click Go, and uncheck those too.

Sometimes simply disabling and re-enabling an add-in clears the problem, and you can keep using it.

Things to Keep in Mind

• Test in a blank workbook first. Open a new workbook and press an arrow key. If it moves there, the cause lives inside your file (protection or a selected object). If it’s dead there too, the cause is Excel-wide or keyboard-wide (Scroll Lock, a stuck key, an add-in).
• If every key is dead, not just the arrows, this isn’t an arrow key problem. Check whether Ctrl + C or Ctrl + S work. If they don’t, the keyboard or the whole Excel window is the issue.
• Scroll Lock survives closing Excel. It’s a system toggle, so restarting Excel three times won’t clear it. Turn it off with the key or the On-Screen Keyboard.

So these are the reasons your arrow keys may not be moving cells in Excel, and how to fix each one. Check the Name Box and the status bar first, and in most cases you will know the reason before you change any setting.

I hope you found this tutorial useful.

Other Excel tutorials you may also like:

• Excel Formulas Not Working: Possible Reasons and How to FIX IT!
• Microsoft Excel Won’t Open – How to Fix it!
• How to Fix Slow Excel Spreadsheets (Speed-up Excel)
• How to Create a Scroll Bar in Excel
• How to Automatically Open Specific Excel File on Startup
• Excel Tabs/Sheets Not Showing – How to Fix?
• Conditional Formatting Not Working in Excel