Excel Cell Movement Locked? Fix Arrow Keys and Selection

Errors & fixes · Updated November 18, 2026

If Excel’s arrow keys scroll the worksheet instead of moving the selected cell, turn off Scroll Lock; on Windows, press the Scroll Lock key or open the On-Screen Keyboard and click ScrLk. If the cell will not move for another reason, check whether you are editing a cell, working on a protected sheet, or trying to drag cells with drag-and-drop disabled.

What “cell movement locked” can mean

The phrase can describe several different Excel behaviors, and the right fix depends on what you see. The most common case is that pressing an arrow key moves the worksheet view while the active-cell outline stays in place. That is usually Scroll Lock. A second case is that the arrow keys move the text cursor inside a cell or formula bar rather than selecting a neighboring cell; Excel is then in edit mode. A third is that Excel refuses to select or change certain cells because the worksheet is protected.

There is also a separate issue with dragging: you may be able to navigate normally but unable to drag a cell or range to a new location. That is controlled by an Excel editing option and is not the same as locking keyboard navigation. Before changing settings, note what is actually stuck: the active-cell border, the worksheet’s visible area, text insertion point, or the cell contents themselves.

Turn off Scroll Lock in Windows

Scroll Lock changes the effect of the arrow keys in Excel. When it is on, an arrow key can scroll the worksheet without moving the active cell. This can make it seem as if cell selection has frozen, even though Excel is responding normally to the keyboard.

  1. Look for a Scroll Lock or ScrLk key on your keyboard and press it once. Some keyboards have an indicator light that turns off when the setting is disabled.
  2. If your keyboard has no Scroll Lock key, open Windows Search, type On-Screen Keyboard, and launch the app. You can also press Windows key + Ctrl + O to open it.
  3. On the On-Screen Keyboard, click ScrLk if the key is shown. Return to Excel and try an arrow key.
  4. Check Excel’s status bar at the bottom of the window. If Scroll Lock is displayed, you can right-click the status bar and, where offered in its list of indicators, enable Scroll Lock so its state is easier to see.

On some laptops, Scroll Lock is assigned to a secondary key function. The required Fn combination varies by manufacturer and model, so check the keyboard labels or the computer maker’s documentation rather than assuming one universal shortcut. If the key state is unclear, the On-Screen Keyboard is a useful way to test it.

Exit cell-editing mode before navigating

If an arrow key moves the insertion point through text in a cell or formula, Excel is editing that cell. This commonly happens after you double-click a cell, press F2, or start typing into a selected cell. In edit mode, the arrows move within the cell’s contents instead of moving the active selection to another cell.

Press Enter to accept the edit, or press Esc to discard the current edit, and then use the arrow keys to move between cells. If the formula bar is active, click back into the worksheet after finishing the edit. A useful clue is the status bar: Excel may show an editing state such as Edit or Enter while you are changing a cell, depending on how you entered the value.

These modes are easy to confuse because the selected cell remains visible in both. For example, when editing a formula such as =SUM(B2:B8), pressing the left arrow may reposition the cursor in the formula rather than select the cell immediately to the left. Finish or cancel the formula first; do not repeatedly press arrow keys expecting ordinary navigation.

Check worksheet protection and selection permissions

Worksheet protection can prevent editing and, depending on the protection settings, can restrict which cells you can select. A protected sheet does not necessarily lock all navigation: many protected sheets still allow users to select cells while preventing changes to locked cells. However, the person who protected the sheet can limit selection of locked cells, unlocked cells, or both.

On Excel for Microsoft 365 for Windows, open the Review tab and look for Unprotect Sheet. If that command is available, the sheet is protected. Select it to remove protection; Excel may ask for a password. If you do not know the password, ask the workbook owner or administrator. There is no legitimate setting in Excel that lets a user bypass a password they are not authorized to remove.

When setting up protection, the sheet owner can use Review > Protect Sheet and choose whether users may select locked and unlocked cells. For an input form, for example, a designer might unlock the cells intended for typing and allow selection of unlocked cells while restricting other actions. If only a few cells are inaccessible, protection or locked-cell permissions are more likely than Scroll Lock. Protection settings apply to the worksheet; workbook-structure protection is a different feature and generally controls actions such as adding, deleting, or rearranging sheets.

Restore dragging and dropping of cells

If arrow-key movement works but you cannot drag a selected cell or range, check the drag-and-drop setting. In Excel for Microsoft 365 on Windows, go to File > Options > Advanced. Under Editing options, select Enable fill handle and cell drag-and-drop, then select OK. This option enables both the fill handle and dragging cells, so changes can affect more than just moving a selection.

To move data without dragging, select the source cells and press Ctrl+X, select the destination, and use the paste option or the Insert Cut Cells command where appropriate. Cutting and pasting can alter formulas or references depending on what is moved and where it goes, so review the result. If the worksheet is protected, the allowed actions and destination cells may still be restricted even when drag-and-drop is enabled.

Dragging can also fail when you start from the wrong part of the selection. In the standard worksheet grid, point at the border of a selected range until the pointer indicates a move operation, then drag. The small square at the lower-right corner is the fill handle, which copies or extends data rather than simply moving the range. If Excel displays a warning or refuses the destination, check protection and merged cells before changing global options.

Other selection settings that can look like a lock

Excel has keyboard modes that change selection behavior. Pressing F8 turns on Extend Selection, allowing a series of keystrokes to extend a highlighted range instead of moving only the active cell. The status bar may show Extend Selection. Press F8 again to turn that mode off. Shift+F8 activates Add to Selection, which lets you add another range; press Shift+F8 again to leave that mode. On keyboards that use function keys for hardware controls, you may need to hold Fn as well.

Ctrl+Arrow is also different from a plain arrow key: it jumps to the edge of a contiguous block of data or to the edge of the worksheet region. That jump can seem unexpected in a large table, but it is normal navigation, not a lock. Likewise, Enter may move the selection in a direction set in Excel’s options. On Windows, that behavior is controlled under File > Options > Advanced, in the Editing options section, by the setting for moving the selection after pressing Enter. It does not change what the arrow keys do.

Finally, merged cells and frozen panes can make movement look irregular. A merged range is selected as a single larger area, so its outline does not behave like a series of ordinary single cells. Freeze Panes keeps chosen rows or columns visible while the rest of the worksheet scrolls; it does not lock the active cell. If the active-cell outline is moving but the view changes around a frozen area, that is expected. Review View > Freeze Panes if you want to change the frozen layout.

Differences on Mac and Excel for the web

In Excel for Mac, Scroll Lock is less straightforward because many Mac keyboards do not have a dedicated Scroll Lock key. Microsoft documents Shift+F14 as the Scroll Lock toggle for Excel for Mac; depending on the keyboard, you may need to press Fn+Shift+F14. Key availability and function-key behavior differ by Mac model and keyboard, so consult the keyboard’s documentation if that combination is unavailable. The Windows On-Screen Keyboard instructions do not apply to macOS.

Excel for the web runs in a browser, so keyboard shortcuts and focus can be affected by the browser and the computer’s keyboard. First click a worksheet cell, then test the arrow keys, and make sure you are not editing a cell or typing into a formula bar. If the behavior differs from the desktop app, open the workbook in the Excel desktop application, if available, to check the Scroll Lock state and desktop editing options. The Windows File > Options paths described above are for the desktop version and are not web settings.

A quick diagnosis before changing settings

Use the visible behavior to narrow down the cause rather than toggling several settings at once:

  • If the sheet scrolls but the active-cell border stays still, check Scroll Lock.
  • If the cursor moves through characters in a cell or formula, finish or cancel cell editing.
  • If only some cells cannot be selected or edited, check worksheet protection and allowed selections.
  • If keyboard navigation works but dragging does not, check Enable fill handle and cell drag-and-drop.
  • If a highlighted range expands, look for Extend Selection or Add to Selection in the status bar.
  • If the view stays partly fixed as you move, check whether Freeze Panes is enabled.

After each change, test one simple action: select a cell and press an arrow key once. This makes it easier to tell whether the adjustment solved the problem and avoids changing unrelated workbook settings. If a workbook is shared or used as a form, check with its owner before unprotecting sheets or changing the layout.

Frequently Asked Questions

Why do my arrow keys scroll instead of moving cells in Excel?
Scroll Lock is the most common cause. Turn it off with the Scroll Lock key, or use the Windows On-Screen Keyboard and click ScrLk. If that does not help, check that you are not editing a cell or using a selection mode such as Extend Selection.

How do I know if Scroll Lock is on in Excel?
Look for Scroll Lock on Excel’s status bar. If it is not displayed, right-click the status bar and check whether Scroll Lock is available in the indicator list. You can also press an arrow key: if the worksheet scrolls while the active-cell outline stays put, Scroll Lock is a strong possibility.

Why can I move around but not edit a cell?
The worksheet may be protected, or that particular cell may be locked under the sheet’s protection settings. Check Review > Unprotect Sheet. If protection requires a password you do not have, contact the workbook owner rather than trying to bypass it.

Why can’t I drag a cell to another location?
In Windows desktop Excel, open File > Options > Advanced and check Enable fill handle and cell drag-and-drop under Editing options. Protection, merged cells, or starting the drag from the fill handle can also affect what happens.

Do frozen panes lock cell movement?
No. Freeze Panes keeps selected rows or columns visible while you navigate elsewhere in the worksheet. The active cell can still move; the fixed portion of the screen is a display aid, not a navigation lock.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.