Typically, when a cell is selected in a spreadsheet and you press the arrow keys, the selection moves between individual cells, either up or down, or left or right, depending on the arrow key you press. However, if you press the arrow keys when Scroll Lock is on, you scroll one row up or one row down. Or, you scroll one column to the left or one column to the right.
Scroll Lock is a toggling lock key on the keyboard, just like the CAPS LOCK key. Once pressed, Scroll Lock is enabled. To use the arrow keys to move between cells, you must turn Scroll Lock off.
What do you want to do?
Turn off Scroll Lock
Do one of the following:
- Press the Scroll Lock (sometimes appears as ScrLk) key on your keyboard
- If your keyboard does not have a Scroll Lock key, on your computer, got to Start, All Programs, Accessories, Ease of Access, and then click On-Screen Keyboard. When the on-screen keyboard appears on your screen, click the slk button.
Note To close the on-screen keyboard, click the X in the top right corner of the on-screen keyboard.
Top of Page
Troubleshooting Scroll Lock
You can tell if Scroll Lock is on, because Scroll Lock appears in the Excel status bar.
If you suspect that Scroll Lock is turned on, but Scroll Lock does not appear in the Excel status bar, it may be because the status bar has been customized to hide the Scroll Lock status. To determine if this is the case, right-click the Excel status bar. The check box to the left of the Scroll Lock option determines whether the Scroll Lock status will appear in the Excel status bar. If a check box is visible, Scroll Lock will appear in the Excel status bar if Scroll Lock has been turned on.
The check box indicates that the Scroll Lock status will appear in the status bar.
If the Scroll Lock check box has not been selected, the Excel status bar will not display Scroll Lock when Scroll Lock has been turned on. The status of Scroll Lock appears to the right of the Scroll Lock option.
The arrow indicates that Scroll Lock is currently turned on.
If the status is set to On, Scroll Lock is turned on. If the status is set to Off, Scroll Lock is not turned on.
Top of Page