docs / articles / Disable Arrow Lock in Excel: A Quick Guide

Disable Arrow Lock in Excel: A Quick Guide

Sara Jul 09, 2026 2026-07-09 04:40:45

Ever found yourself accidentally moving your cell cursor across Excel sheets with every click? This is due to Excel's arrow key lock feature, which can be quite frustrating. But don't worry, turning it off is a breeze. Let's dive into how you can do this.

How to Fix Arrow Keys Scrolling in Excel
How to Fix Arrow Keys Scrolling in Excel

Before we start, it's important to understand what the arrow key lock feature is. In Excel, when this feature is on, moving your cursor using the arrow keys will not only move it one cell at a time but will also select the cell. This can lead to unwanted cell selections and edits. Now, let's learn how to turn it off.

Arrow Keys Not Working in Excel? Here's How to Fix It Quickly
Arrow Keys Not Working in Excel? Here's How to Fix It Quickly

Turning Off Arrow Key Lock in Excel

Excel provides a simple way to turn off the arrow key lock feature. Here's how you can do it:

the instructions for how to use excel arrow keys
the instructions for how to use excel arrow keys

1. Click on the 'File' tab in the top-left corner of your Excel window.

2. From the menu that appears, select 'Options'.

How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?

Using the Ribbon

If you prefer using the Ribbon, here's how you can do it:

1. Click on the 'Home' tab in the Ribbon.

How To Lock Screen To Prevent Scrolling In Excel Worksheet
How To Lock Screen To Prevent Scrolling In Excel Worksheet

2. In the 'Editing' group, click on the small arrow next to 'Find & Select'.

3. From the menu that appears, select 'Replace'.

4. In the 'Replace' dialog box, click on the 'Options...' button.

Microsoft Excel 2010: Mouse Pointers & Cursor Movements
Microsoft Excel 2010: Mouse Pointers & Cursor Movements

Using the Quick Access Toolbar

For those who prefer a quicker way, you can add this option to your Quick Access Toolbar:

Insert Rows Fast in Excel with Ctrl + Shift + Plus
Insert Rows Fast in Excel with Ctrl + Shift + Plus
How to Insert row in Excel Shortcut
How to Insert row in Excel Shortcut
Excel Keyboard Shortcuts: Ctrl + Arrow Key
Excel Keyboard Shortcuts: Ctrl + Arrow Key
How to lock, hide cells and protect worksheet in Excel
How to lock, hide cells and protect worksheet in Excel
a green poster with the words highlight every other row in excel and an image of a
a green poster with the words highlight every other row in excel and an image of a
How to unlock Excel spreadsheets without a Password
How to unlock Excel spreadsheets without a Password
Excel Trick: Custom Sort How To do it!
Excel Trick: Custom Sort How To do it!
a computer screen with the words don't remove blank rows manual
a computer screen with the words don't remove blank rows manual
the excel tip shows how to remove borders in microsoft's office window, and then select
the excel tip shows how to remove borders in microsoft's office window, and then select
Lock Cells that have Formulas in Excel (Easy Steps)
Lock Cells that have Formulas in Excel (Easy Steps)
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
How to VLOOKUP to the Left in Excel
How to VLOOKUP to the Left in Excel
How to highlight your rows in excel
How to highlight your rows in excel
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
How to Freeze rows in Excel - Excel for beginners
How to Freeze rows in Excel - Excel for beginners
40+ Excel navigational shortcuts to make accounting job super efficient - PakAccountants.com
40+ Excel navigational shortcuts to make accounting job super efficient - PakAccountants.com
How to lock and protect formulas in Excel?
How to lock and protect formulas in Excel?
How to vlookup excel (Step by step) - How To Do Topics
How to vlookup excel (Step by step) - How To Do Topics
Understanding, Detecting and Correcting Excel errors - #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE! - PakAccountants.com
Understanding, Detecting and Correcting Excel errors - #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE! - PakAccountants.com
a green sign that says 50 things you can do with excel power query get better at microsoft excel
a green sign that says 50 things you can do with excel power query get better at microsoft excel

1. Right-click on the 'Replace' button in the 'Home' tab.

2. From the menu that appears, select 'Add to Quick Access Toolbar'.

3. Now, you can simply click on the 'Replace' button in the Quick Access Toolbar to turn off the arrow key lock.

Understanding the 'Replace' Dialog Box

The 'Replace' dialog box might seem out of place here, but it's actually the key to turning off the arrow key lock feature. Here's why:

The 'Replace' dialog box contains an option called 'Use 1048576 as the loop current count'. When you check this box, Excel uses a large number as the loop current count, which effectively turns off the arrow key lock feature.

Remember, turning off the arrow key lock feature means your cursor will no longer select cells as you move it. This can be helpful when you're simply navigating through your spreadsheet without intending to select or edit cells.

Now that you know how to turn off the arrow key lock in Excel, you can breeze through your spreadsheets with ease. Happy navigating!