Just imagine this. You are working in Excel when all of a sudden you notice that you cannot move from cell to cell normally - instead of getting to the next cell, your arrow keys scroll the whole worksheet. Don't panic - simply turn the Scroll Lock off. Continue reading
Comments page 6. Total comments: 160
Yes, It works. Thanks a lot!
Thank you
Thank you very much. It works!
Thanks, it works
Seems different laptops have different hotkey shortcuts to handle scroll lock.
I am a dell user and fn+s worked for me.
Thanks Dude,
This was just so muchhh helpful .. Thank you
thaaank you sooo much
it was so helpful
Thanks a ton
Thank you! Very helpful!
Saved me a headache.
Thanks na ton!!
Hello Svetlana
The detailed description mentioned here was really very helpful.Thank you
Thanks a lotttt
help so much.
love,
THANK YOU
None of the options here worked for me. Tried the keyboard, didn't work, tried the different key combinations and none worked. Using an HP...help~!
Hi, my on screen keyboard returns an error, which I cannot resolve. I tried all the shortcuts mentioned above and none worked for me. I am using an Asus zenbook UX430U.
thank you.
Hello
I created a Pivot Chart on Excel together with a Slicer. I want the slicer to be functional after I protect the sheet. Problem is, when I untick the Lock option from within the slicer properties and then protect the sheet. The user can still move the Slicer around which I don't want. I would like the chart and the slicer to retain a fixed location on the grid and only for the slicer options to work.
It appears from these comments that many different laptops have many different hotkey shortcuts to toogle scroll lock, and that's why so many of us are accidentally turning it on and can't figure out how to turn it off again.
On some Dell laptops, it is —
Fn + s
Thank you!!
Thank you yes it is Fn+s for Dell lappy with Excel 2016. Was driving me crazy trying to figure our how it was getting turned on
Thanks so much - you not only saved me much frustration but it is great to know how what caused the problem in the first place
Thanks a lot.
Thank you so much. There're a 1,000 sites telling me to use the virtual keyboard but not one single one answering how it got turned on by my cat in the first place (she certainly didn't do that).
You have saved my sanity!
Thanks for you help!
thanks for your help
Super ..thanks.
thanks a lot
Yes the last comment worked for me - fn + C
Thanks sir, now working
No need to waste that much effort as given in this article. Just use shortcut key Fn+C from windows keyboard.
thaaats what I needed. Great man!
THANKS!!! This is a lifesaver!
Thank you.
I tried pretty much avery complicated combo on my keyboard, but the obvious ones :)
You helped a lot.
This was really helpful. It works like nothing else :).
You are the man.
Wonderful to see help available. Thank you
To turn off scroll lock on iMac short keyboard only goes to f12. Press all at same time, fn+command+ the down arrow, on the bottom of the right hand side, under the up arrow.
Thank you so much, it was really helpful
Just want to know, there is no Scroll Lock key on my keyboard and I don't use on-screen keyboard. How did the scroll lock status get changed? Are there any short cut key?
fn + capslock is the hotkey that worked for me to toggle scroll lock
You saved me, thank you!
Thank you! This worked. :)
Hey there.
Scroll lock is what actually keeps the backlight on my keyboard on, so if I turn it off, it'll go dark. Is there a way to disable the Scroll lock feature entirely on Excel?
Hi team,
i found that by pressing window symbol+ shift and K it gets released. maybe it will help someone
Thanks for exact solution...
Went in and clicked the check mark off scroll lock and thought that would do it but it was still locked to my surprise. No scroll lock button on laptop or even on the electronic keyboard. Unreal! Not sure what to do now.
NICE
Thank you very much! Your explanations are easy to understand and follow. All articles are well explained..They are very helpful
thank you for this. I read a few posts/articles on the subject, and this was the most helpful.
Thank you for this answer. My scroll lock was selected when I right click on the task bar, so I unchecked it and rechecked it again with no success. Using the scroll lock button on the keyboard solved my problem.
Thanks for the solution, and most of know how to scroll off with on screen key board but the question is how and why it is getting on during working in excel.
I work on excel every day for a long time and all of sudden it gets on, WTF?
It is irritating and Microsoft should answer of fix this bug, it can't happen that it will on automatically without doing anything from user side.
For security reasons my access to on-screen keyboard is disabled, then how do I turn off scroll lock
Svetlana Cheusheva, thanks a lot for the article post.Much thanks again. Fantastic.