#Excel scroll lock stuck how to

If you see the words, Scroll Lock, you can be assured that the scroll lock has been activated. Once that done, the status bar will display if the scroll lock has been enabled or disabled.

If the Scroll Lock status is not shown on the status bar, it means Scroll Lock is off. Right click on the status bar and check the option for Scroll lock. If the Scroll Lock status is shown on the status bar, Scroll Lock is on. Method 3: Use the Status Bar If your computer has a status bar at the bottom of the Excel window, you can quickly tell if Scroll Lock is on or off. In the Advanced section, scroll down to the Display options for this workbook section, and then check the Show horizontal scroll bar and Show vertical scroll bar options. When you find that you try to move your cell selected in Excel with your arrow keys and the spreadsheet scrolls instead of moving position this means you Scroll Lock key is on. If your keyboard does not have a Scroll Lock key, on your computer, click Start and then press CTRL+C to display the Charms bar. Method 2: Change the Settings in Excel If you don't have a Scroll Lock key on your keyboard (or if you're using a laptop that doesn't have one), you can turn off Scroll Lock in Excel by going to the File tab, and then clicking Options. However, when the scroll lock is disabled in Excel, pressing the arrow keys shifts the selection from one cell to the other. If your keyboard doesn't have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard, and then turn off the Use the On-Screen Keyboard slider button. Step to Turn Off Scroll Lock in Excel If your keyboard doesnt have Scroll Lock Key, then Click Start > Settings > Ease of Access > Keyboard. Method 1: Use the Keyboard Shortcut To turn off Scroll Lock, press the Scroll Lock key (often labeled as ScrLk) on your keyboard.Look in the bottom left corner of the Excel window and confirm that.

#Excel scroll lock stuck how to

Here are three ways to turn off Scroll Lock. How to enable and disable Scroll Lock in Excel Open Microsoft Excel and load any workbook. This can be handy at times, but other times, it's just a pain.

If Scroll Lock is on, pressing the arrow keys will scroll the worksheet without moving the cell pointer. That's because the Scroll Lock key on your keyboard is turned on. If you've ever tried to scroll through a worksheet with a lot of data, you know it can be frustrating when you scroll one column over and the whole page moves.