Excel Guides

Odd Arrow Key Behavior in Excel

If you're experiencing odd arrow key behavior in Excel, there are a few possible explanations.

One possibility is that your worksheet is protected and the arrow keys are locked. To check if this is the case, go to the Review tab and click Unprotect Sheet. If you're able to move around freely after doing this, then protection was the issue.

Another possibility is that you inadvertently turned on Scroll Lock. This can happen if you accidentally press the Scroll Lock key on your keyboard (usually located near the Pause/Break key). To turn off Scroll Lock, simply press the Scroll Lock key again. You should see a message that says "Scrolling Lock (Off)" at the bottom of your screen.

If neither of these solutions solves your problem, there may be an issue with your Excel settings. To check this, go to File > Options > Advanced. Under the "Editing options" section, make sure that the "Enable fill handle and cell drag-and-drop" option is checked.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.