how to turn off scroll lock in excel 2007

#How to turn off scroll lock in excel 2007 windows

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. Excel 2007 (Ctrl+A gets worse) If the worksheet contains data, CTRL+A selects the current region (Ctrl+). If you want to keep the same selection as you scroll, turn on SCROLL LOCK first. I checked all the obcious special functions on the keyboard. Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. 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. Right click the status bar to display or to hide the Scroll Lock status.Well, I had an odd situation this morning with Excel. When Scroll Lock is turned on, Excel displays Scroll Lock in the status bar (only if the status bar is customized to display the Scroll Lock status).Ĥ. Note: to turn on scroll lock, simply repeat step 1 or step 2 and 3.

#How to turn off scroll lock in excel 2007 windows

Click Start > Settings > Ease of Access > Keyboard > Use the On-Screen Keyboard (or press the Windows logo key + CTRL + O). If your keyboard does not have a Scroll Lock key, launch the on-screen keyboard.Ģ. Press the Scroll Lock key (Scroll Lock or ScrLk) on your keyboard. To turn off scroll lock, execute the following step(s).ġ. Note: press CTRL + Backspace to scroll back to the active cell. When Scroll Lock is turned on, you can use the arrow keys to scroll through the worksheet without changing the active cell. What is Scroll Lock?įirst, when Scroll Lock is turned off, you can use the arrow keys to change the active cell. Excel displays Scroll Lock in the status bar.

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.ĭon’t panic, your Excel is not broken.