How to toggle Scroll Lock in Excel 2010 without a Scroll Lock key in the keyboard

I have a notebook with no Scroll Lock key (or any shortcut using the 'Fn' key).

Somehow Excel 2010 got the Scroll Lock on. I see it left down in the status bar and now I can't navigate through cells using the arrow keys, which is pretty annoying. It wasn't turned on some hours ago, so I think I must have hit some Scroll Lock toggle shortcut in Excel 2010 by mistake.

Anyone knows what hot to turn off Scroll Lock in Excel (shortcut or menu option)?

Toto

Posted 2011-11-15T23:01:33.747

Reputation: 367

I also triggered a scroll look somehow. I was pressing the tab key a bunch or something, was hoping there was an actual shortcut. – Evan Siroky – 2014-12-05T20:32:03.533

Answers

From this link which refers to the Excel help file:

"If your keyboard does not have a Scroll Lock key, on your computer, got to Start, All Programs, Accessories, Ease of Access, and then click On-Screen Keyboard. When the on-screen keyboard appears on your screen, click the slk button."

There is a picture of this process at the link.

brettdj

Posted 2011-11-15T23:01:33.747

Reputation: 1 912

3Ugh. So nobody knows how this got toggled on? I get that it can be fixed with the OSK, but somehow it keeps turning on, I would imagine that repeating that action would disable it. – Dan Robson – 2015-02-23T15:48:41.387

2You can also invoke the On-Screen Keyboard by typing osk into the (Win)+(R) (i.e., "Run") dialog box, or a Command Prompt. – G-Man Says 'Reinstate Monica' – 2015-04-25T02:13:34.040

It's 'Fn' + 'S', accidentally pressed instead of 'Ctrl' + 'S', which is the toggle shortcut on my Dell - and most Dells, in general.

Also, 'Fn' + 'C' works for HP Elitebook laptops. Try if it works for you.

Saurabh

Posted 2011-11-15T23:01:33.747

Reputation: 111

2It doesn't work for the person who originally asked the question because they explicitly say that there's no shortcut using the FN key. But your answer will still be useful to other people so that's fine. – David Richerby – 2015-08-23T10:08:23.027

2Worked on my Dell too. Note: there's no indication at all on the key itself that this one is the scroll-lock key. – Pieter-Jan Busschaert – 2017-04-27T15:43:56.827

'Fn' + 's' on my Dell invokes my screenshot program! (I have Gadwin Pro installed, so it may not be a native thing) – Hansjp – 2018-08-22T10:06:46.323

'Shift' + 'Fn' + 's' on Dell Latitude – rkwadd – 2019-05-08T18:00:19.500

On an HP Probook 440, function + C locks and unlocks ScrLk.

Vinit Tanksale

Posted 2011-11-15T23:01:33.747

Reputation: 31

1Same for HP EliteBook 840 G3 – The Red Pea – 2019-08-06T05:29:27.790

Scroll Lock option for the Lenovo L 440 Thinkpad can be enabled by using Fn+K to toggle.

Virtual Keypad option as suggested above OSK also works.

Kiran

Posted 2011-11-15T23:01:33.747

Reputation: 29

It took a lot of time to find solution for this.

Press below combination to switch off/disable Scroll Lock:

Fn + F3

Press again to on/enable Scroll Lock.

Manohar Reddy Poreddy

Posted 2011-11-15T23:01:33.747

Reputation: 231

This works on my Dell Latitude! Thanks! I used the On-Screen Keyboard to disable it but knew for sure I enabled it by pressing some combined keys. – Emiel Koning – 2018-04-27T18:41:47.613

Happy, it worked for you too. – Manohar Reddy Poreddy – 2018-04-28T00:38:25.427

It is Fn+Pause/Break on Asus Zenbook (sort of undocumented feature: it is not written on the button).

Antony Hatchkins

Posted 2011-11-15T23:01:33.747

Reputation: 321

but not on linux – Berry Tsakala – 2020-01-04T18:01:53.163

@BerryTsakala I think it must be easier on linux. – Antony Hatchkins – 2020-01-05T06:29:43.930

it's voodoo either way. if you know the magical mystery spell book, LMK – Berry Tsakala – 2020-01-06T18:35:42.467

@BerryTsakala yes, voodoo in fact :) I don't have a linux laptop right now, but when I did remapping in general was pretty simple. I don't remember the details, unfortunately :/ – Antony Hatchkins – 2020-01-06T18:53:08.403

Go to Control Panel >> Mouse >> Wheel, and click option button: "Use Microsoft Office 97 Scrolling Emulation Only". This worked for me.

Ratna C

Posted 2011-11-15T23:01:33.747

Reputation: 11

Fn-F5 works on a variety of Dell Studios (including my XPS).

Found here

claytond

Posted 2011-11-15T23:01:33.747

Reputation: 121

If you are a Lenovo ThinkPad user, use Fn + C to toggle Scroll lock. Otherwise you can always use on screen keyboard ! I used to solve this by using On-Screen Keyboard !

Shraddha

Posted 2011-11-15T23:01:33.747

Reputation: 109

1This also works on HP EliteBooks (and apparently HP Probook 440 as mentioned in another answer). This comment is here to note this for future users. I am not sure who downvoted this as this had not been suggested prior to this answer. – OpiesDad – 2017-03-31T15:46:05.023

Logitech K360 wireless keyboard (and possibly others) use FN+PgDn for scroll lock.

glenviewjeff

Posted 2011-11-15T23:01:33.747

Reputation: 1 472

-2

Fn + K worked for me on my Lenovo L440. I assume this is the shortcut for the Scroll Lock option.

Mig14

Posted 2011-11-15T23:01:33.747

Reputation: 1

1This duplicates the earlier answer from Kiran. Please read the existing answers (particularly for older questions) before answering. – blm – 2016-01-15T17:21:16.023

-3

i got it corrected with OSK but yes it did happen again, that's when i realized HOW it got ON in first place.

Yes i saw qts was posted 3 years ago but a solution is never late right?

It gets ON by pressing FN, CTRL (RHS, besides arrow keys which also works as right click key) and 'S' together. In excel on trying to get 'paste special' i was pressing all these 3 together. What you really need to do is press FN and CTRL (rhs) and then S for 'paste special'.

To undo scroll lock just press FN, (RHS) CTRL and S all together. :) hope it helped.

jabeen

Posted 2011-11-15T23:01:33.747

Reputation: 1

3What is OSK and what is qts? – suspectus – 2015-07-21T09:24:46.663

2@suspectus OSK = On-Screen Keyboard. I think qts is a typo for qst=question. jabeen, please don't use textspeak and abbreviations: it really doesn't take long to type the word "question". – David Richerby – 2015-08-23T10:05:17.543

I don't see why this answer should be down voted. Despite the textspeak this indeed answers the question. Ctrl + Fn + S (not necessarily RHS) is actually the shortcut for Scroll lock toggle. – Ravi – 2016-01-08T20:32:30.563