Disable scroll lock in Excel using the keyboard Much like Num Lock and Caps Lock, the Scroll Lock feature is a toggle, meaning it can be turned on and off by pressing the Scroll Lock key.
How to turn off Scroll Lock in Excel for Windows The Excel status bar only displays the Scroll Lock status, but does not control it. If a tick mark is not there, simply click the Scroll Lock to have its status appear on the status bar: To determine if it's the case, right click the status bar and see if there is a tick mark to the left of Scroll Lock. If your arrow keys scroll the whole sheet instead of moving to the next cell but the Excel status bar has no indication of Scroll Lock, most likely your status bar was customized not to display the Scroll Lock status.
Among other useful things (such as page numbers average, sum and count of selected cells), the status bar shows if Scroll Lock is on: To see whether the Scroll Lock is turned on, just look at the status bar at the bottom of the Excel window. How to determine that Scroll Lock is enabled When the worksheet is scrolled, the current selection (a cell or range) does not change. However, when the Scroll Lock is enabled in Excel, arrow keys scroll the worksheet area: one row up and down or one column to the left or right. Usually, when the Scroll Lock is disabled, arrow keys move you between individual cells in any direction: up, down, left or right. Scroll Lock is the feature that controls the behavior of the arrow keys in Excel.
How to disable Scroll Lock in Excel for Mac.How to turn off Scroll Lock in Excel for Windows.How to determine that Scroll Lock is on.You have just accidentally turned Scroll Lock on, and this can be easily fixed. You are working on a spreadsheet normally when all of a sudden you notice that you cannot move from cell to cell - instead of getting to the next cell, the arrow keys scroll the whole worksheet. So as you can see, sometimes reprhasing your question a few different ways can get you the answer you need.Just imagine this. Here is the list of keyword combinations I tried in Google:Įxcel - cursor scrolls sheet instead of jumping cellsĮxcel - cursor no longer moves active cellĮxcel - arrow moves sheet instead of active cell Typing "SCRL" into Excel help doesn't come up with anything. Looking a little closer, Excel displays the characters "SCRL" in the lower right corner when the scroll lock is on. Why couldn't they put one more light for Scroll-Lock? But now my active cell scrolled instead of the spreadsheet! Yay! There is a status light under each of F10 and F11 for 10-keypad arrow mode and Num-Lock mode respectively.
I finally saw the box with an arrow going up and another going down on the lower corner of the F12 key. I checked all the obcious special functions on the keyboard. For a moment, I wasn't even sure my laptop even had a scroll lock function. You see, on my laptop, there is no Scroll Lock light as you would find on normal 104-style desktop keyboards. But the cached summary information in Google was just what I needed. The first entry was at and the key text shown by Google from the site was "Try turning scroll lock off." Following the link did NOT take me to the entry, as it must have scrolled off their page. I finally hit the right combination when I searched Google with: "excel arrow scroll problem". I tried letting Excel's help look on the web. I tried quite a few combinations of keywords in Google.
It was driving me nuts, being a power-keyboard user. If I was trying to cursor in a direction that wasn't against the edge, it would scroll the spreadsheet page as if I had used the scroll bars. Each time I used the arrow keys to move around cells it didn't work. Well, I had an odd situation this morning with Excel.