If Excel’s arrow keys are not moving the active cell, first turn off Scroll Lock: press the Scroll Lock (ScrLk) key, or open Windows On-Screen Keyboard and click ScrLk. With Scroll Lock on, the arrows scroll the worksheet instead of changing the selected cell. If the arrows do nothing at all, check whether Excel is editing a cell or a dialog box has focus, then work through the other checks below.
What Scroll Lock changes in Excel
Normally, pressing an arrow key moves the active-cell outline one cell in that direction. For example, if B4 is selected, the Right Arrow selects C4. Scroll Lock changes that behavior: the active cell stays selected while the visible worksheet moves. This can make it seem as if the keys have stopped working, even though Excel is responding to them.
Look at the bottom status bar while pressing an arrow. If the worksheet shifts but the selected cell does not, Scroll Lock is the likeliest cause. This is different from Freeze Panes. Freeze Panes keeps chosen rows or columns visible as you scroll; it does not make the arrow keys move the sheet while leaving the active cell in place.
Scroll Lock is a keyboard mode, not a setting in the worksheet itself. It can be switched on accidentally, and its status can carry over between tasks. A workbook shared with someone else is not necessarily responsible just because the problem appears after opening it.
Check whether Scroll Lock is on
Some full-size keyboards have a key labeled ScrLk or Scroll Lock, often near Pause or Print Screen. Press it once, return to the worksheet, and try an arrow key. If the selection now moves, the problem is resolved. Some keyboards use a function-layer combination instead, so check the keyboard maker’s instructions if there is no dedicated key.
Excel may also show Scroll Lock in its status bar. If you do not see the indicator, right-click the status bar and look for Scroll Lock in the list of available indicators. The list and visible indicators can vary by Excel build, and the indicator may be unchecked, so its absence is not proof that Scroll Lock is off. The movement test is more useful: cell stays selected while the sheet scrolls means Scroll Lock is likely active.
If the bottom of the Excel window is hidden or you are using a compact layout, use the Windows keyboard method below rather than relying on the status bar. The status-bar indicator reports the mode; it does not itself turn the mode off.
Turn off Scroll Lock in Windows
- Click the worksheet area so Excel is the active app.
- Press ScrLk or Scroll Lock on the physical keyboard, if available.
- Try an arrow key and confirm that the selected cell changes.
On a laptop, ScrLk may be printed in a smaller color on another key. A combination such as Fn plus that key may toggle it, but the exact combination depends on the laptop model. If you cannot identify it, Windows has an alternative: open Start, search for On-Screen Keyboard, and launch the app. Click the ScrLk key on the on-screen keyboard, then return to Excel and test an arrow.
If the On-Screen Keyboard does not display ScrLk, open its Options and enable the numeric keypad if that makes the key available in your Windows version. The layout can differ. You can also check Windows’ keyboard accessibility settings, but do not change unrelated settings such as Sticky Keys unless they are actually causing a separate problem. Once Scroll Lock is off, you can close the on-screen keyboard.
If the arrows do nothing, check Excel’s focus
Scroll Lock usually makes the worksheet scroll. If neither the selection nor the visible sheet responds, Excel may not be receiving the keys as worksheet navigation. A cell can be in edit mode: this happens after you press F2, double-click a cell, or start typing into it. In edit mode, arrow keys move the insertion point within the cell’s text or formula rather than selecting a neighboring cell.
Press Esc to cancel the current edit, or Enter to commit it, then try the arrow keys again. If you are entering a formula, the arrows may insert a cell reference into that formula, which is also normal. Finish or cancel the formula before expecting the keys to move the selection. A visible text cursor inside the cell or formula bar is a useful clue that Excel is editing content.
Focus can also be in the formula bar, a search box, a menu, or a dialog. Click a worksheet cell once and test again. If a dialog is open, close it with its Cancel or OK button as appropriate. When a chart, shape, or other object is selected, arrows may move the object instead of changing the active cell; click an ordinary cell to return focus to the grid.
Rule out selection and worksheet behavior
Check whether the active cell actually changes. A large selection, a merged cell, or hidden rows and columns can make navigation look unusual. For example, arrowing through a merged range may move the active selection in a way that does not match a simple one-cell step. Hidden rows are skipped when you move through visible cells, so the row numbers may appear to jump.
Try a simple test in an ordinary, unmerged cell on a blank part of the worksheet. If the arrows work there, the keyboard is probably fine and the difference comes from the selected range or sheet layout. Freeze Panes and split windows can also make it less obvious which area is moving, but they do not disable arrow navigation. Use View > Freeze Panes to inspect or change frozen areas only if the issue is that you cannot see the part of the sheet you expect.
Sheet protection can restrict editing, but it does not ordinarily switch off the arrow keys. Depending on protection settings, you may still be able to select unlocked cells or move among permitted cells. If Excel displays a protection message, ask the workbook owner for the appropriate access rather than trying to bypass protection.
Check the keyboard and Excel itself
Test the arrow keys in another application, such as a text editor or a web page. In a text editor, the arrows should move the text cursor; on a web page, they may scroll the page. If the keys fail in several apps, investigate the keyboard, its connection, or its Fn-lock setting before changing Excel options. For a wireless keyboard, reconnect it or replace its batteries if needed; for a laptop, try the built-in keyboard if you were using an external one.
If the keys work elsewhere, close any open Excel menus or dialogs and try a new blank workbook. If navigation works in the blank workbook but not the original, compare the sheets and workbook state: look for editing mode, selected objects, unusual merged ranges, or protection. Save a copy before troubleshooting a workbook that contains important work. You can also save, close Excel, and reopen the file to clear a temporary application-state problem.
When the issue affects every workbook and persists after restarting Excel, check whether an add-in or customization is interfering. Start Excel in Safe Mode on Windows by holding Ctrl while launching Excel and confirming the prompt, then test a blank workbook. If arrows work there, an add-in or startup customization may be involved; disable add-ins one at a time through File > Options > Add-ins and retest. Do not remove add-ins that your organization requires without checking with its IT team.
Excel for Mac and Excel for the web
On a Mac, the main diagnosis is the same: determine whether the sheet scrolls while the active cell remains selected, or whether Excel is in edit mode or has focus elsewhere. Many Mac keyboards do not include a dedicated Scroll Lock key. Microsoft documents Shift+F14 as a Scroll Lock toggle for Excel for Mac on keyboards that provide F14; some keyboards may require an Fn key, and the available keys depend on the hardware. If the shortcut is unavailable, try a keyboard with Scroll Lock support or consult the keyboard manufacturer’s guidance.
In Excel for the web, first click a cell in the grid so the browser or another page control is not receiving the arrows. Browser focus can make arrow keys scroll the page rather than navigate the workbook. The browser version may not expose every desktop status-bar indicator, so use the movement test and the keyboard options available on your device. On Windows, the On-Screen Keyboard can help toggle Scroll Lock for a connected keyboard. If possible, open the workbook in desktop Excel to compare behavior and isolate a browser-focus issue from a workbook or keyboard issue.
Useful workarounds while troubleshooting
If you need to reach a particular cell before diagnosing the keyboard, use the Name Box to the left of the formula bar. Click it, type a cell address such as D25, and press Enter. You can also use Ctrl+G on Windows to open Go To and enter a reference; on Mac, use Control+G or F5 where supported by the keyboard. These methods select a destination without relying on repeated arrow presses.
For moving among cells while entering data, Tab moves to the next cell in a row and Enter usually moves down after an entry. Those keys are useful alternatives, but their direction can be affected by selection and data-entry settings, so they are not a substitute for correcting Scroll Lock. If you are navigating a long sheet, the Name Box or Go To is often faster and more predictable than holding an arrow key.
Frequently Asked Questions
Why do my arrow keys scroll the sheet instead of moving cells?
Scroll Lock is probably on. Turn it off with the ScrLk key or Windows On-Screen Keyboard, then verify that the active-cell outline moves when you press an arrow.
Why do arrow keys move inside a cell or formula?
The cell is likely in edit mode, or the formula bar has focus. Press Esc or Enter to leave editing, then click a worksheet cell and try again.
Does Freeze Panes stop arrow keys from selecting cells?
No. Freeze Panes keeps selected rows or columns visible while you navigate. Scroll Lock is the setting that makes arrow keys scroll the worksheet without changing the active cell.
How do I turn off Scroll Lock without a ScrLk key?
On Windows, search Start for On-Screen Keyboard and click ScrLk if it appears. On a Mac, Shift+F14 works only on keyboards that support that key; a keyboard-specific Fn combination may be needed.
Why do the arrows work in a new workbook but not this one?
The original sheet may be in edit mode, have an object selected, use merged cells, or have protection or layout features that change what you see. Test an ordinary cell and inspect the workbook state before changing global keyboard settings.
Prevent the problem from returning
After restoring normal navigation, note whether your keyboard has a dedicated or Fn-layer Scroll Lock key. If the problem returns, check the status indicator or repeat the movement test before changing workbook settings. Keep in mind that Scroll Lock is a keyboard mode, while edit mode, browser focus, object selection, and workbook layout are separate causes with different fixes. Identifying whether the active cell moves is the quickest way to choose the right one.
Related
- How to Add Slide Transitions in PowerPoint: A Quick Guide
- Clothing Inventory Spreadsheet Template: Setup & Tips
- How to Add Slide Numbers in Your PowerPoint Footer
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel #DIV/0! Error: Causes and FixesExcel’s #DIV/0! error means a formula is trying to divide by zero or by a blank cell. If…
- Excel Web Formula Not Working? Causes and Fixes That WorkIn Excel for the web, a formula usually fails because it is stored as text, has a syntax…
- Excel IRR #NUM! Error: Causes and FixesIn Excel, IRR returns #NUM! when it cannot find a rate that makes a set of periodic cash…
- Excel Filter Not Working for All Rows? Find the CauseIf Excel’s filter is not working for all rows, its filter range may stop before the missing records,…
- Microsoft Excel Formula Not Calculating? Fix ItIf a Microsoft Excel formula is not calculating, first check Formulas > Calculation Options and select Automatic. If…
- Excel Error 0xc0000142: Causes, Fixes, and Next StepsExcel error 0xc0000142 means Windows could not initialize a component Excel needs while starting the program. Close and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.