that is enabled by pressing the Scroll Lock key. scroll the worksheet, but not shift the selected cell.
From time to time you may find that using the cursor keys in MS Excel for Mac will
Applescript to fix scroll-lock problem with Microsoft Excel on Mac OS The script is also available on github – contributions welcome. You can alternatively download a disk image version of the application, and run without installing into your Applications folder.įor those interested in the applescript, it is shown below, and also included in the downloaded application bundle under the Contents/Resources/Scripts folder. To use, simply download the application, unzip, and drag the application into your Applications folder. What it does is “send” a Shift-F14 key press to Microsoft Excel as if you pressed the Scroll lock key, thus toggling on or off this function within Excel. However for those of you who do not have ready access to such legacy keyboards, you can use a simple applescript application that I have written called Excel Scroll Lock.
In the past I have attached an older Mac keyboard to my 2010 Macbook Pro and pressed the F14 key. This makes disabling this feature tricky to say the least. However newer Macintoshes no longer have a F14 key. Older Macintosh computers had the F14 key mapped to the Scroll lock key of PC keyboard, so it was quite easy to enable or disable. Thanks for reading our blog.This is actually a feature of Microsoft Excel carried over from the Windows version on which you press the Scroll lock key to enable or disable. Do you know any other methods? Or did you find any type of errors with the article? Let us know in the comment box. Hope you find one or two convenient ways to use the methods mentioned above. These are overall ways you can Turn Off the Scroll Lock Option in Excel. You see that the Scroll Lock option is on but it is not checked, this is why Scroll Lock status is not showing in the status bar.Ĭheck (select) the Scroll Lock option => Now, you can see the Scroll Lock status is showing on the Status Bar area. Place the cursor on the Excel Status Bar and Right-Click => Customize Status Bar menu will appear.
How to show the Scroll Lock in the Status Bar? In this case, it happens because the Scroll Lock option is not selected to show in the Excel Status Bar. In the below image, I’m pressing the Down Arrow key but neither Active Cell changes nor Status Bar shows Scroll Lock. Sometimes it happens that you have Scroll Lock ON but in Excel Status Bar it does not show. Read More: How to Lock Rows in Excel When Scrolling (4 Easy Methods) What if you feel the Scroll Lock in On but Excel Status Bar is not Showing It? 5) Turn off Scroll Lock on HP laptopsįor some HP laptops, pressing Fn + C keys altogether switches between turning Scroll Lock On and Off.
In case F14 is present on the keyboard, but there is no Function (fn) key, You can use the SHIFT/CONTROL/OPTION/COMMAND + F14 shortcut to switch between the Scroll Lock on or off depending on the Mac setting.įor some Dell Laptops, pressing Fn + S shortcut keys altogether switches between turning Scroll Lock On and Off. On the Mac Keyboard for Scroll Lock Press F14. Read More: How to Turn On/Off Scroll Lock in Excel (2 Ways) 3) Turning Off Scroll Lock in Mac
Iii) Opening On-Screen Keyboard on Windows 8.1 Click on the ScrLK button once to Turn it Off & twice to Turn it On. If you find that the ScrLK key is in Blue Color, then it is already Turned On. Go to Menu Search Bar then type “ On-Screen Keyboard” ( just type “on scr”, you will see the match ), On-Screen Keyboard App will come up.Ĭlick on the Open command, On-Screen Keyboard will appear in a moment. Ii) Using Menu Search Bar (If your keyboard does not have a Scroll Lock key) A pop-up window will show the On-Screen Keyboard, similar to the picture below. Use this keyboard shortcut to open the On-Screen Keyboard.
I) Opening On-Screen Keyboard in Windows 10 Read More: How to Remove Scroll Lock in Excel (With Easy Steps) 2) Using On-Screen Keyboard (If your keyboard does not have a Scroll Lock key)