It happens to me often when I try to navigate with the arrow key from the Keyboard, but instead of navigating to the next cell, it moves Excel’s Window. It happens in Excel Windows, but not that much in Mac.
What’s the Reason? Scroll Lock
Fix the Arrow keys in Excel (Scroll Lock)
If you use a PC keyboard, you might have the Scroll Lock key, so press it. It will disable the scroll lock, and your arrow keys will work again.
But if you are using Excel from a laptop where you don’t have the Scroll Button, you can use:
Fn + K
To turn off the scroll lock. And if you want to turn it on back:
Fn + C
You can also use the On-Screen Keyboard with the below steps:
- Use the keyboard shortcut Window + S to open the Windows Search.
- Type “On-Screen Keyboard” and open it.
- You have the “On Screen Keyboard” open on the screen.
- Click on the “Scroll Lock” button from there.
- In the end, return to the worksheet and use the navigation keys from the Keyboard.
Scroll Setting you must use in Excel
The best way to activate and deactivate the scroll lock is from the Keyboard or On-Screen Keyboard. But there’s a setting in Excel’s status bar that you can activate.
- Right-click on the status bar.
- Click on the Scroll Bar.
And when even you have a scroll lock activated, it will show a small message on the status bar “Scroll Lock”.
It helps you to identify the problem when you don’t have the navigation keys working in Excel.
Scroll Lock is an option to activate on the operating system’s level, not inside Excel only. But sometimes when you are working in Excel it’s gets on.
- Fill Justify in Excel
- Formula Bar in Excel (Hide, Unhide, and Expand)
- Add a Header and Footer in Excel
- Show Ruler in Excel
- Fill Handle in Excel
- Format Painter in Excel
- Quick Access Toolbar in Excel
- Status Bar in Excel
- Insert Text Box in Excel
- Change Tab Color in Excel (Worksheet Tab Background Color)