Comments on: How to turn off Scroll Lock in Excel

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 5. Total comments: 160

  1. Although i disabled "scrnlock" from excel but it didn't work. It worked via "On-Screen Keyboard". Thank you for your tutorial.

  2. Thanks much. You are a saviour.

  3. None of these options worked for me. On a Dell keyboard without a Scroll Lock or online Keyboard. Fn+S and Fn +C does absolutely nothing. This is a major pet peeve of mine... how do I fix it?

  4. Thanks for the learnings..

  5. Thank you so much for the help....

  6. Thank you!

  7. This is amazing. The internet is virtually flooooooded (!!) with this massively pointless advise on how to unlock scroll lock using on-screen keyboard. I am truly amazed at this. How can sooooo many people deliberately choose to answer this wrong??

    The problem is that everyone(!) ever googling this problem, has somehow accidentally clicked a keyboard combo that results in Scroll lock. But then why,....oh why...(!?), don't people talk about what the keyboard shortcut IS to toggle scroll lock? I don't want to NOT know how scroll lock is suddenly and accidentally enabled, but know how to go to OSK every time(!) to disable it... :))))))))))

    Please just say:

    You accidentally clicked this XYZ keyboard combo which is set as shortcut for enabling scroll lock. Please try to avoid the combo in the future, unless deliberate, and whenever it happens by accidnet, use keyboard shortvcut combo ABC to disable it.

    Also, if you want to disable the keyboard shortcut combo for scroll lock entirely, then do this....!

    1. On ThinkPads it's function key + K.

  8. In DELL laptop use "Shift+F6"

  9. It worked and thanks a lot

  10. Dear Author,

    Thanks a lot for this informative Page. This is very helpful for me to unlock the Scroll on my Excel File.

    Have a great day.

  11. Thank you so much! Knowing how to turn off the scroll lock (on my tablet) in Excel saved me so much aggravation!

  12. Thank You ...

  13. THANK YOU!!

  14. So I had to look this up to see if anyone knew why the stupid scroll lock keeps 'magically' turning on in Excel when my HP laptop has no key for it. Found the post above about using "Fn + C" to turn it off, (and technically 'on') and realized that the damn Fn key is next to my ctrl key. I use the keyboard shortcut commands 'ctrl C' and 'ctrl V' all the time to copy/paste in Excel so DUH, it looks like I probably fat fingered the Fn key instead of the ctrl when I went to do a copy and voila, you just magically scroll locked your keyboard.

    The damn C key should have a little 'Scroll lock' printed on it if they are going to do that to people.

  15. Thank you so much for this! Especially adding the little trick on how scroll lock is triggered in Dell Laptops. :D You've been a wonderful guide :)

  16. Super..! This article helped me

  17. thank you.. omg.. lifesaver

  18. What a LIFE SAVER!

    Seemingly endless (10-minute) searching to resolve Dell laptop's scroll lock agony yielded no results. Then I found your solutions!

    Fn + S-key

    WhyTF doesn't Dell print this function on the damn S-key itself!?

    Anyway...

    Thanks for helping me get back to more productive things than tearing my hair out and wanting to break this computer over my knee.

  19. thnk you so much.

  20. thank you... no other help site worked. this is great

  21. Yes, It works. Thanks a lot!

  22. Thank you

  23. Thank you very much. It works!

  24. Thanks, it works

  25. Seems different laptops have different hotkey shortcuts to handle scroll lock.
    I am a dell user and fn+s worked for me.

    1. Thanks Dude,

  26. This was just so muchhh helpful .. Thank you

  27. thaaank you sooo much
    it was so helpful

  28. Thanks a ton

  29. Thank you! Very helpful!
    Saved me a headache.

  30. Thanks na ton!!

  31. Hello Svetlana
    The detailed description mentioned here was really very helpful.Thank you

  32. Thanks a lotttt
    help so much.
    love,

  33. THANK YOU

  34. 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~!

  35. 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.

  36. 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.

  37. 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

    1. Thank you!!

    2. 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

    3. 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

    4. Thanks a lot.

    5. 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!

  38. Thanks for you help!

  39. thanks for your help

  40. Super ..thanks.

  41. thanks a lot

  42. Yes the last comment worked for me - fn + C

    1. Thanks sir, now working

  43. No need to waste that much effort as given in this article. Just use shortcut key Fn+C from windows keyboard.

    1. thaaats what I needed. Great man!

    2. THANKS!!! This is a lifesaver!

    3. Thank you.
      I tried pretty much avery complicated combo on my keyboard, but the obvious ones :)
      You helped a lot.

    4. This was really helpful. It works like nothing else :).

    5. You are the man.

  44. Wonderful to see help available. Thank you

  45. 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.

  46. Thank you so much, it was really helpful

  47. 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?

  48. fn + capslock is the hotkey that worked for me to toggle scroll lock

    1. You saved me, thank you!

    2. Thank you! This worked. :)

  49. 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?

  50. Hi team,
    i found that by pressing window symbol+ shift and K it gets released. maybe it will help someone

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)