2004-09-07

Excel Scroll Problem - Scroll Lock

Well, I had an odd situation this morning with Excel. Each time I used the arrow keys to move around cells [move the active cell] it didn't work. 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. It was driving me nuts, being a power-keyboard user. I tried quite a few combinations of keywords in Google. I tried looking at Excel's options. I tried Excel's help. I tried letting Excel's help look on the web. I went back to Google. I tried a few more combinations. I finally hit the right combination when I searched Google with: "excel arrow scroll problem". The first entry was at www.exceltip.com/ng-27.html, 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. But the cached summary information in Google was just what I needed.

You see, on my laptop [Toshiba Notebook], there is no Scroll Lock light as you would find on normal 104-style desktop keyboards. For a moment, I wasn't even sure my laptop even had a scroll lock function. I checked all the obcious special functions on the keyboard. I didn't find it. I finally saw the box with an arrow going up and another going down on the lower corner of the F12 key. I pressed Fn+F12. No change in lights on the unit. 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. Why couldn't they put one more light for Scroll-Lock?

Looking a little closer, Excel displays the characters "SCRL" in the lower right corner when the scroll lock is on. Typing "SCRL" into Excel help doesn't come up with anything.

Here is the list of keyword combinations I tried in Google:
excel - cursor scrolls sheet instead of jumping cells
excel - cursor scroll
excel - cursor scrolls page
excel - cursor no longer moves active cell
excel - arrow doesn't move active cell
excel - arrow moves sheet instead of active cell
excel arrow problem
excel arrow scroll problem

So as you can see, sometimes reprhasing your question a few different ways can get you the answer you need.

151 comments:

Anonymous said...

...thank you! I was having the exact same problem and it was very frustrating. I also noticed the SCRL and typed in SCRL under help and got nothing; looking under SCROLL also got me nothing. It wasn't until I yahoo'ed the "excel scroll" that I got your answer - I really appreciate your help!!

Anonymous said...

Thanks, I had the same problem on a regular keyboard, but I never use the lock, so I don't look at the light. Thanks for having this info.

I googled under "excel cursor" with some further description of the problem.

Anonymous said...

Thanks again! I searched for "excel arrow scroll" which led me to your post! Excellent!

Paul

Anonymous said...

great post...I know I have to turn off scroll but donno how.. I was having toshiba also...it worked...Thks

Anonymous said...

great post. Thanks. I was going nuts with this problem.

Anonymous said...

I just had the same problem.. but eventually saw the keyboard light. So frustrating! Unfortunately, I couldn't find the right word combo to find your page on google until after the fact.

Anonymous said...

THANK YOU!!!1

monko said...

i was also having this problem on my toshiba laptop.

thanks!

Anonymous said...

Thanks so much. When I read the words 'scroll lock', I immediately looked at my keyboard and what to my suprise ...

Scroll lock was on.

Thanks so very much !

Anonymous said...

Great this post. Solved my scroll-lock problem in a few seconds. I searched for "excel cursor keys scroll screen instead of cell" and got your post as second hit.

Anonymous said...

Thanks so much! It was driving me crazy! I saw the SCRL and tried pressing on it to no avail, I saw the ScrLk button and pressed SHIFT + ScrLk, ALT + ScrLk, and CTRL + ScrLk - no change. I didn't think that pressing the button by itself would fix it. Thanks!

Anonymous said...

After searching in Excel, I entered "scroll lock excel" in google and your web page came up first. Thanks for helping save a lot of wasted - frustrating time.

Cheers

obermurmler said...

Thaaaaaaaanks!!!!!

Anonymous said...

LIFE SAVER! Thats all i have to say.

Anonymous said...

Thanks! Had the same problem and this "missfunctionality" had driven me crazy...

Anonymous said...

Thank you. Boss was going crazy over this one!

Anonymous said...

Thanks!!!
I though the computer had a virus.

Thanks a lot.

Anonymous said...

I was losing my mind, thank you so much. !

Anonymous said...

Just wanted to say thanks. I had the same problem>. Looked throughout the menus, then decided to let Google answer my question, which led me to you.

Anonymous said...

LEGEND... have toshiba as well, just had same thing going on and no clue where the scroll lock was. Nice One!!

Dave Xie said...

HI Guy,

I had same issue, I tried press combination key: Fn + Scroll LK. See, the Scroll LK key is a functional key shared with Num LK on my laptop -- Dell Latitude D630. So problem gone.

Anonymous said...

My conclusion: Microsoft's help function proved to be as useless as ever ...

waleed said...

thanks i am in Egypt. I had this problem 1 min ago, i opened the browser searched . I finded the solution here !!. I will continue my work. It is a wonerfull world. thank god for web and google.

Anonymous said...

found via "excel cursor modes" google search

This has bothered me off and on for years, and until today I didn't know what it was...

Anonymous said...

I had MAJOR problems finding the solution to this problem using a Mac keyboard. Turn Scroll Lock on and off on a Mac Keyboard is ctrl + F14! Yay!

Anonymous said...

thank you so much. SCRLK button on the thinkpad

Anonymous said...

Try Windows -> Unfreeze Panes

Keith said...

Unfreeze panes is something different, but useful to know

Anonymous said...

THANK YOU!!!

Anonymous said...

Thanks!

Anonymous said...

Thanks, I had the same problem and had already tried to solve with Excel help - but in vain.

Anonymous said...

Saved my life. I too have a Tosh (R500) so this was a lifesaver.
I got here with "cursors scrolling in excel"

Thanks again.

Casper said...

Thank you ... thank you ... thank you! i knew it was the scroll lock, but was having no luck in excel getting it turned of ... it just said turn off scroll lock ... and there wasn't a key on my toshiba that said scroll lock .... now data analysis will go SO much better!! thanks again!!

Anonymous said...

thanks a million for this post!!! great help :)

Anonymous said...

thanks, good lookin out

Anonymous said...

Thank you!!!
I solve my scroll lock problem also;
But now i have another one: i can't use the CTRL+SHIFT+END/HOME to select the entire data :(((
Any one had this prob??
thanks in advance.

Anonymous said...

ok...i solved my CTRL+SHIFT+END problem.Trying to fix my previous problem i selcted the Transition navigation keys in Transition<--Options<--Tools and this cause the End/Home to stop working.
This are life saving tips.
Thanks guys.
Ciao

Anonymous said...

Thank you!

Anonymous said...

Another suggestion is to check for "frozen pane" [in Excel 2003, Window -> Freeze (or Unfreeze) Panes]. The problem was that, the way a spreadsheet was set up, half of its page was locked for fast reference, and, when scrolling, the scroll bar would move, but the data, apparently, wouldn't. Upon maximizing the window, I realized why - the top portion had been locked ("frozen"), and the scollable part was outside the viewing window. In general, I would suggest that it is not useful, if you find yourself having to freeze more than a few rows; instead, it might be easier to copy your worksheet to a new book and work in restored view to easily manipulate between the two windows.

Anonymous said...

WOW, thank you!! How come this solution was so hard to find!

Anonymous said...

the scroll lock function can be triggered in the On-Screen Keyboard. This
application is normally found in Start -> Programs -> Accessories ->
Accessibility
Clicking on the 'scroll lock' in the On-Screen Keyboard should have the same
function as pressing a physical scroll lock key.

This is much easier.

Anonymous said...

I had a user call with this issue on her desktop. I asked her to press the ScrLk key to no avail. Eventually we figured out she had an F-Lock key which prevented those keys at the top of the keyboard from being messed-with.

Just a heads up if you try to troubleshoot this remotely.

Anonymous said...

THIS WAS BUGGING ME FOR WEEKS AND YOUR POST HELPED INSTANTLY. JUST SEARCHED FOR 'ARROW EXCEL MOVES PAGE'

THANKS!!

Anonymous said...

Thanks! This was driving me crazy. I searched for "excel not scrolling correctly" and found your post. Thanks again!

Anonymous said...

unbelievable post. thanks a million.

Anonymous said...

i seem to have a different problem and its eating me. everytime i open excel and click into one cell, it then keeps scrolling that the programme becomes unusable. it even refuses shuting down and i have to close the window through task manager. anyone with any idea what i can do? pliz help

Anonymous said...

Thanks, I just had the same problem since a few days.
Mystery solved!

Anonymous said...

Thank God!

Anonymous said...

Thank you so much. I could not find the scroll lock key on my lap top either. Ahhh, it is so nice to have the ability to move from cell to cell with the arrow keys again!

Anonymous said...

I had the same problem with IBM notebook.

There are indication lamps only for CAPS_LOCK and NUM_LOCK.[The NUM_LOCK is activated/deactivated with LEFT_SHIFT + NUM_LOCK button].

The NUM and the SCROLL share one button.

The SCROLL is activated/deactivated with LEFT_ALT+SCROLL button. Notice that there is no indication for this!

Iain said...

Good work just saved me throwing my laptop out the window

Anonymous said...

thank you so much for the help! it solved the problem and keeps my wife from nagging :D

Anonymous said...

Thank you! I finally solved my problem

Syd said...

Worked like a charm! THANKS!

Peter - Slovakia said...

Many thanks, buddy! A time ago I also had another problem of the same kind with my touch pad. F9+FN :D

Cristin said...

After dropping about 40 f'bombs and coming oh so close to taking a sledge hammer to my "stupid" computer... I found your post. Problem solved. Thanks!

Anonymous said...

Saved the day for me - thanks for this post.

Anonymous said...

LOL - this post keeps generating thank you notes!
Well, here's mine.
Took me almost 5 seconds to search and find your solution - great job!

pec3_nyc said...

I'm on an iMac...Man, how ridiculous is it that Excel's HELP function doesn't even recognize SCRL or any combination of "scroll" "arrow key scroll", etc., nothing helps. Thank god for Google and the Internet, 10+ years ago and I would have been screwed. CTRL-F14 did the trick, thanks Anonymous from 2/2/08!

Tox!c said...

THANK YOU!! it was driving me nuts. (same laptop - same problem. :)

Anonymous said...

Thank God. I have an Apple Macbook pro and this has made the last few days at work unbearable.

Anonymous said...

for the person that is having everything highlight when moving the mouse around after clicking on a single cell, if you have a scroll wheel on your mouse, press it like a button. That has fixed it for the people in my office.

Anonymous said...

Thanks to the person that posted the IBM solution.

Anonymous said...

THANK YOU! I looked forever for an answer and yours worked!!!

Anonymous said...

Thanks, U get me out of the situation....

Miguel, Arcangel. said...

Thank you!!!

U helped us it this uncomfotable situation!

Thank you very much!

Miguel.

Anonymous said...

Thank you for the help! It was driving me nuts for a while there!

Anonymous said...

THANK YOU!!!

Anonymous said...

Everyone lauched when I blamed my cat for causing my Excel scrolling problem... this post helped me prove that my cat DID cause the problem!

Renelo said...

Thanks to the person who recommended the On screen keayboard.
I did not found the scrl key anywhere.
It worked for my hp.

Anonymous said...

Thanks for the post.
Was very helpful.
Long live google and forums like these.

Anonymous said...

Must have hit the scroll lock by accident at some point, the excel help was useless. Thanks, this was driving me mad.

phaine said...

It's incredible that this issue survives after years.

Here is the solution for Mac Excel, where you won't easily find an F14 button to press.

- bring up the key viewer
(See: http://www.macupdate.com/info.php/id/24957)

- hold down the Shift key and press F14 on the onscreen keyboard

Anonymous said...

Glad you posted this, thanks.

Anonymous said...

Good job! I use a laptop and it doesn't have a light. Glad I found your post.

Anonymous said...

Thanks a bunch !! I was getting frustrated and didn't know what to do. Your blog came up first on a google search. Even I don't have a scroll light on my laptop. But I did notice the SCRL on the excel though. Thanks again.

Anonymous said...

THANK YOU!!! that was so annoying!

Anonymous said...

My Word....thankyou very much for this excellent share of info!!

Cannot thankyou enough for this...was going bananas!!!!! ;)

Anonymous said...

THANK YOU! THANK YOU! THANK YOU! I could find nothing useful in Excel help either, but one google seazrch came up with this page. Problem solved!

Anonymous said...

Although for me, Excel had the SCRL on the bottom right corner, hitting the Scroll Lock key didn't work for me - I asked for a kindly co-worker's help and clicking on the rolling scroll button on my mouse did my trick! Thanks for this post, however, as I hope anyone who didn't have luck with the scroll key can perhaps try clicking the scroll button on their mouse and have their problem solved!

Anonymous said...

On Mac 10.5.x running Windows 7 in VMware Fusion 2.0.5, I've run into problems with caps lock and scroll lock. I found some executables that worked (at least used to).

For me, in the Win 7 VM, fn+F14 did the trick. And fn+F13 is Prt Scrn and fn+F15 is Pause.

Anonymous said...

YOU HAVE SAVE MY LIFE - greetings from Mexico :)

Anonymous said...

Thanks! I was past nuts!

Anonymous said...

Thanks so much! Same problem, different laptop, but with your explanation I was finally able to find a scroll lock button in the northeast corner of the keyboard :-)

Anonymous said...

thank you very much, i'm going to break my keyboard. Fortunately I've seen this. My key board says "thank you" I know English well.

Kerrigan said...

Thank you.
I had this problem a few months ago, searched for the solution, then forgot about it.
And now it happened again today :) As I didn't remember what had caused it the previous time, I googled "excel scroll move" and found your post again :)

Anonymous said...

I found your page googleing on
"excel cursor arrow".
And of course, the scroll lock was activated.
Now I can use mu cursor arrows the usual way...

Thanks again !

Chris said...

Thank you very much! It was so annoying. I use a PC. I push 'scroll lock' and everything is back to normal on my excel sheet. Thanks!

Anonymous said...

Thank you! Typed in ms excel arrow keys scroll and got your post right away. Just a hint for any other people with an hp laptop: you have to hit fn+plus the "1' with the lock on it to disengage the scroll lock on our keyboards! the "1" with the lock next to it was in the "f" key line. Thanks again!

Brad said...

THANK YOU SO MUCH!!!!!!

I spent last Friday just living with this and today, it was still there...

Quick search and you provided the SCROLL LOCK explanation!!!

Thanks VERY VERY MUCH!

Anonymous said...

Unfreeze panes worked for me! Thanks for the tip...

bbpitufo said...

In a DELL LATITUDE E5500 the correct key combination for the "SCROLL LOCK" is Fn + F5 (it has a lock and a down arrow image)

Thanks for all

Anonymous said...

You all are lifesavers... I almost throw my Mac out the window.

On my Mac to turn the scoll lock off I hit Function F14

Anonymous said...

Many Thanks - I've got a HP laptop and the top right hand button is the scroll lock. This post has solved my problem.

Cheers

T

Chris said...

Thanks for this post! Turns out I had a malfunctioning mouse in a Lenovo docking station causing cursor scrolling when the mouse hovers over the cell field. Simply pulling the USB mouse out, and plugging it back in solved my problem! Neat!

Ken said...

Phew ...Ctrl F14 on mac keyboard.....it was killing me....how crazy over such a little thing...! Many thanks

Anonymous said...

Thank you for leaving this post. I have a Gateway. I tried CTRL SCROLL button or ALT SCROLL button or Fn Scroll button. Try to navigate within an Excel sheet after each attempt.

I agree, there should be a scroll lock light. I was having such a difficult time moving about Excel. How do you accidentally turn on scroll lock anyway? I have no idea, but thanks.

kerinbot said...

THIS IS AN AWESOME TOPIC! I agree - would it have KILLED anyone to put a "scroll lock" light on my laptop? I just spent 20 min running malwarebytes and all my other virus checkers (still clean) and couldn't find the "virus" that was forcing all my documents to scroll to the right!

Thanks SO MUCH! You saved a few crumbs of what is left of my sanity with this one!

Anonymous said...

thanks a lot man.

pearl of price unknown said...

Thank you for saving my day! I was going nuts about not being able to move around the cells, but your post was totally helpful.

ccostas said...

Bless you, my child. I'm using Excel on a Mac (under protest), and was about to pitch my Mini into the lake.

By the way, I have a Logitech keyboard with no F14 key, so I had to enable the Keyboard Viewer. In Snow Leopard (10.6.4), the sequence is:

- open System Preferences
- open Language and Text
- click Input Sources
- at the top of the input method list, you'll see "Keyboard & Character Viewer". Click the checkbox to turn it on.
- Close the window. The Viewer icon will show up in the menu bar.

Thanks again!
Catherine

Anonymous said...

Thank you. Came in to the same issue and Fn-F5 did the trick for me. Thanks again. (Gotta love Google search)

Anonymous said...

Thanks a lot ...
I got here by googling "arrows in excel scroll sheet".
You were a great help.
Thanks again.

Anonymous said...

Thanks

Anonymous said...

Big thanks for helping me out with this problem

Anonymous said...

Thanks for your help

Chris said...

Thank you very much. So weird!

Anonymous said...

I tried this (great idea!) but then it turned out my issue was that I had frozen the whole page instead of just the rows and columns I meant to freeze.

Vyoma said...

thank you!!! seriously god bless u!!! been struggling with this since a day now...

Anonymous said...

Thanks a ton for posting this. I was going crazy because of scroll freeze. My work requires lot of excel work and somehow the scroll by arrow keys got frozen. Thanks a lot. :) I don't have words to thank you.

Anonymous said...

This ended up being a freeze pane glitch for me. I could use my scroll, but visible portion of the page would not change. So frustrating. I unfroze my top row and now I can scroll without problems...although my spreadsheet is not as functional without using the freeze pane feature.

Anonymous said...

Add me to the list! You helped me too!

Anonymous said...

Happened to me today. Thanks for keeping it posted :)

Anonymous said...

Thanks to the MAC-specific tip provided in 2008: Pressing CTRL-F14 solves the problem.

Anonymous said...

Thank you - I was going insane !!

Anonymous said...

Thank the lord, you are amazing, this problem was driving me nuts!!! :)

esabil said...

!!!!!!!!!!!!!!!!!!!!!!!!!!!
Use FN + Shift + F12. Work on macbook pro
!!!!!!!!!!!!!!!!!!!!!!!!!!!

Anonymous said...

many thanks, the no light is frustrating

Martha Joy said...

I just searched for 'excel scrolling', and this was the second thing to show up. And of course, I had turned my scroll lock on.

Thanks!

Anonymous said...

Thank you so much! This was very helpful and saved me from banging my head against the wall.

Anonymous said...

I also was searching for help. The problem is that my Lenovo ThinkPad Edge has NO scroll locks nor a Num lock key. The only way I got it to unlock was to hook up an external keyboard to it and turn off the scroll lock key.
Silly, huh?

Sakthi said...

Thanks a lot for helping me locate the scroll lock key in my TOSHIBA PORTEGE M500, Model No PPM51L Laptop.

Anonymous said...

Thank you. Very helpful.

Mohit Anand said...

Bugger...never thought it was the scroll lock, I was going crazy fortunately your result came top on Google results.

Anonymous said...

Thanks mate! Saved my computer from a flight out the door!

Anonymous said...

Thanks buddy! It's amazing how a 2004 trick still proves to be so useful 7 years later!

Anonymous said...

Mine issue isnt just with Excel, but it so happens that I am using Excel when it starts....then it is in ALL programs, including websites.

My SCR LK is above the F11 key and I never use that area of keyboard so I'm not sure how the KEY could be the issue. Rebooting computer usually resolves but thats annoying.

I tested the key and No light comes on when key is being used and no words appear on screen/toolbar.

Dan said...

Thanks - amazing, I had the same problem (Excel scroll) and 7 years later I googled around and found your blog. Thank you!! :-)

Gement said...

Still going! In Internet years your legacy is epic. You saved me a lot of frustration today.

Tori said...

Amazing! Thank you for this top tip- brill.

Anonymous said...

THANK YOU THANK YOU THANK YOU! It's Monday morning at 7:45 a.m. and it was way to early for my brain to be functioning! I tried everything and anything I could think of and finally just wrote my question into ask.com and found this page. Thank you again!! It would have been a very frustrating day without you!
-Andie-

Anonymous said...

Many thanks to the person who said "on-screen keyboard"! My lenovo ThinkPad Edge E520 does not have any of the other solution routes mentioned above (no little arrows at the bottom right edge of a key, no shared scroll-lock key, no standalone scroll-lock key, etc. But indeed the scroll lock _was_ on on the on-screen keyboard. How much stupider can Windows get?

JerberSoft said...

for lenovo thinkpad edge users. the scroll lock is "Fn + C". cheers!

vncb said...

Thank you so much!!! :D XOXO I love you!!! hahaha Era tan fácil!!!

vncb said...

Thank you so much!!! :D XOXO I love you!!! hehehe Ay Dios, era tan fácil!

Anonymous said...

Same issue. I don't like Excel 2010. Older versions were easier and more intuitive. Since upgrading, my productivity is down 40%.

Anonymous said...

Thank you - was driving me mad too!

Anonymous said...

Fn F3 on Dell Latitude E5420. Looks like a Lock symbol with a Down arrow in the middle.

Anonymous said...

Thanks also - luckily my PC has Scroll Lock button and, yes, I'd evidently accidentally pressed it!

OBR said...

scoll lock off! WOWWWW .... GOD Bless you.. The whole day i was so pissed off with the entire issue that why on earth i cant jump from one cell to another... i had to use SHIFT+TAB to move right and left... Computing is funny! isnt it?

Anonymous said...

When I first had this problem in '05, I'm pretty sure this was the article I found that helped me. I was an overweight, young, reckless, steak-eating suv driving redneck without a care in the world. Today I'm a father with a good job, I workout, eat mainly vegis, and drive a hybrid. You've saved me again Keith, 7 years later. Thanks for still being here, you are an integral part of my life.

Anonymous said...

I never leave comments. Ever. But this was so well written, and helpful, that I had to make an exception. Thanks.

Anonymous said...

Thanks a very very lot. It's really a stupid feeling of not noticing a small key stroke, your post - saved my day...!!!
Thanks.

Anonymous said...

Thank you. This was driving me crazy!

Anonymous said...

Thank you, this solved my problem very quickly and saved me lots of times :)!!!

Anonymous said...

Wow first in list and corrected in secound bothered me for days!!!!

Thank you so much for your post.

Mark M.

Anonymous said...

Still useful years later. Thank you.

Anonymous said...

thanks. same problem, driving me nuts.

Deepak said...

Thanks A lot Keith Horowitz :)

Anonymous said...

This answer was just what I needed, and so many years after your original post. Thank you!

Anonymous said...

Thanks, it was a different key on my laptop but at least came to know how it need to be done.