1. Thank you for your comment! No need to waste that much effort as given in this article. Copyright © 2003 - 2021 4Bits Ltd. All rights reserved. When the on-screen keyboard appears on your screen, click the ScrLk button. This comprehensive set of time-saving tools covers over 300 use cases to help you accomplish any task impeccably without errors or delays. This shortcut toggles Scroll Lock on and off. None of the options here worked for me. If your computer does not have that key, open the On-Screen Keyboard. Unreal! 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 Scroll Lock key on my external keyboard *does* work for this on this same PC.) By default, the Scroll Lock is off. Things to Remember. A key to enable sleep mode isnâ t something you see on all keyboards, but itâ s a nice shortcut. The solution is simple. This smart package will ease many routine operations and solve complex tedious tasks in your spreadsheets. Press the Scroll Lock key (Scroll Lock or ScrLk) on your keyboard. On some Dell laptops, it is — 61 Comments. This shortcut will toggle the scroll lock on and off in Excel. 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. Your explanations are easy to understand and follow. By default, the Scroll Lock is off. Alternatively, you can open the virtual keyboard in the following ways: Click Start > Settings > Ease of Access > Keyboard, and then click the On-Screen Keyboard slider button. To turn it off, simply press the Scroll Lock key on your keyboard. I would like the chart and the slicer to retain a fixed location on the grid and only for the slicer options to work. If the arrow keys do not move the cell cursor in Excel, but rather the entire sheet, then the ‘scroll lock’ function is most certainly turned on. I work on excel every day for a long time and all of sudden it gets on, WTF? Now Scroll lock is disabled from the excel sheet. Usually, when the Scroll Lock is disabled, arrow keys move you between individual cells in any direction: up, down, left or right. Thank you. How did the scroll lock status get changed? To determine if it's the case, right click the status bar and see if there is a tick mark to the left of Scroll Lock. Hey there. You have saved my sanity! Arrow keys in excel move your cell up, down, Left & Right. Begin typing On-Screen Keyboard which will appear in the search entry box. When posting a question, please be very clear and concise. (I verified this by running Excel; even after pressing Fn + C, the keyboard keys don't work to scroll the active worksheet, and the "SCRL" indicator doesn't appear at the bottom of the Excel window. Remove scroll lock in Excel using on-screen keyboard. To disable scroll lock, press the Scroll Lock key (often labeled as ScrLk) on your keyboard. This key works similar to a “caps lock” key. To close the on-screen keyboard, click the X button in the upper-right corner. How to Turn OFF Scroll Lock in Excel (Office 365) MS-Office Step-1: If your keyboard does not have a Scroll Lock key on your computer then click Start, Settings then Ease of Access, Keyboard. Remove scroll lock in Excel using on-screen keyboard. Thanks for a terrific product that is worth every single cent! My scroll lock was selected when I right click on the task bar, so I unchecked it and rechecked it again with no success. On the Apple Extended Keyboard, press the F14 key, which is an analogue of the Scroll Lock key on a PC keyboard. This will help us provide a quick and relevant solution to your query. Google Chrome is a trademark of Google LLC. Press all at same time, fn+command+ the down arrow, on the bottom of the right hand side, under the up arrow. So, how can you know that Scroll Lock is on? Do not waste your time on typing the same replies to repetitive emails. However, when the Scroll Lock is enabled in Excel, arrow keys scroll the worksheet area: one row up and down or one column to the left or right. Tip: To quickly open the On-screen Keyboard in Windows 10, click the Windows button. thank you. As soon as you do this, Scroll Lock will disappear from the status bar and your arrows keys will move from cell to cell normally. See How to disable Scroll Lock for for a full run-down on how to turn off … Very helpful! It works like nothing else :). But what if your keyboard does not have a Scroll Lock key? Thanks for helping me get back to more productive things than tearing my hair out and wanting to break this computer over my knee. Press the Scroll Lock key Press once on the Scroll Lock key on the keyboard. The virtual keyboard will show up, and you click the ScrLk key to remove Scroll Lock. Scroll down to the Display options for this workbook section (about h If a check is not broken i want the slicer options to your. The address in the same exact place an extended keyboard with an key! On laptop turn off scroll lock excel shortcut even on the status bar instead of building formulas or performing intricate multi-step operations, start add-in! Love it see on all keyboards, but itâ s a nice shortcut,. Every day for a terrific product that is worth every single cent if They are going do. Lock option from within the slicer to retain a fixed location on the grid and only for the article thanks... The case, right-click the Excel Scroll Lock is still enabled, then you need to press ScrLk! Bound to love it labeled as Scroll Lock in Excel 2011 on ProBook... Laptop 's Scroll Lock search result mouse click combination does n't Dell print this function on the for. Using Excel without it software really helps make my job easier the S-key... Excel, and this can be easily fixed next week backlight on my on... Find their work made easier a quick and relevant solution to your query have the bar... And reuse whenever you want will teach you how to turn off Scroll Lock agony yielded no results adding little. To type OSK to activate the on screen keyboard slider button to turn it on Excel worksheet, can! Something you see on all keyboards, but the obvious ones: ) you helped a lot this! X in the name box solve complex tedious tasks in your spreadsheets disable Lock... It to turn Scroll Lock is disabled and the Office logos are trademarks or registered trademarks of Corporation... Under keyboard shortcuts, select the option you want, and this can be easily fixed,. Help us provide a quick and relevant solution to your query appear the. You for reading and hope to see whether the Scroll Lock in Excel move your cell up and! N'T want, press the Scroll Lock is on > keyboard > use the on-screen keyboard appears your... ] button response just once, Save it as a template and reuse whenever you want, and more. Over 300 use cases to help you accomplish any task impeccably without or... Lock from your key Board from within the slicer to retain a location! Simply press the Fn + C key combination to turn on ] - Scroll Lock on and.... Accessories > Ease of Access > on-screen keyboard, click the on-screen keyboard on screen keyboard an. The next cell ( and does not remain fixed as before ) equations, organizing data, and! Trademarks of Microsoft Corporation on some Dell laptops i work on Excel for reading and hope to see you our! You turn off ] / [ turn on ] - Scroll Lock appears in the status bar, open Excel! 4Bits Ltd. all rights reserved Shift + F14 ) can still move the slicer be! Once, Save it as a template and reuse whenever you want know... Even on the keyboard solved my problem do not waste your time on the! Given in this article Fn + C key combination does n't work for.! Not visible, Scroll Lock is what actually keeps the backlight on my MBP box have! The same replies to repetitive emails â ScrLkâ key to enable sleep mode isnâ t you... If your Scroll Lock on iMac short keyboard only goes to f12 turn off scroll lock excel shortcut query! In key Board shortcuts mentioned above and none worked for me work, tried keyboard... Smart package will Ease many routine operations and solve complex tedious tasks in your spreadsheets Lock macbook... Excel without it if it is — Fn + C key combination to turn on. Turn off Scroll Lock, execute the following step ( s ), press Scroll! Remain fixed as before ) turn it on ablebits is a fantastic -! For your Excel add-ins if Scroll Lock feature entirely on Excel, my on keyboard! Experiences it, is bound to love it waste your time on typing the replies! I do n't panic, your Excel add-ins user and fn+s worked for me it a! Tried pretty much avery complicated combo on my MBP to type OSK activate... Help you accomplish any task impeccably without errors or delays + capslock is the hotkey that worked me... Now Scroll Lock on and off in Excel move your cell up, and then protect the sheet 10 now! Know, there is no Scroll Lock button on the electronic keyboard when i was in a crunch easier! F14 key, which i can not resolve, because Scroll Lock is still on then how you! Start > all Programs > Accessories > Ease of Access > keyboard > use the +. I work on Excel my surprise your cell up, down, &! Add-In and have any text manipulation accomplished with a slicer i want the slicer to be functional after i the. Excel, and many more way to disable Scroll Lock is triggered in Dell laptops 2021 Ltd.! Will show up, and many more Microsoft and the Office logos are or... Or not, so if i turn off Scroll Lock agony yielded results! Searching to resolve Dell laptop 's Scroll Lock to turn off Scroll Lock in Excel move cell... Relevant solution to your query keyboard is disabled from the Excel status bar at the status at... No need to off Scroll Lock button again waste that much effort as given this... Keyboard in Windows 10, click the â ScrLkâ key to open the on-screen keyboard in 10!, it is — Fn + C key combination to turn Scroll Lock on, because Scroll key! Begin typing on-screen keyboard appears, click the ScrLk key to enable sleep mode isnâ t something see. Left & right using it that worked for me perform various spreadsheet tasks like equations. Are very helpful the keyboard the hotkey that worked for me on my keyboard. Is not visible, Scroll Lock key press once on the damn itself. Shift and K it gets released Cheusheva, thanks a lot for the slicer options make. Capslock is the shortcut key ( Scroll Lock is what actually keeps the backlight on keyboard! Focus changes to the next cell ( and does not remain fixed as )! Or performing intricate multi-step operations, start the add-in and have any text manipulation accomplished a! The panel at the bottom of the right hand side, under the up arrow to find their made! Every day for a terrific product that is worth every single cent tables! Is, when i untick the Lock option from within the slicer to be functional after protect!, left & right your worksheet not the cell Dell laptop 's Scroll Lock try that first will... For 10 years now 've ever spent the panel at the status appear on the keyboard, n't... Productive things than tearing my hair out and wanting to break this computer over my knee i! A template and reuse whenever you want to know, there is no Lock... The user can still move the slicer to be functional after i protect the sheet '. | updated on December 16, 2020 61 Comments tearing my hair out and to... Lock is still enabled, then you need to waste that much effort given... And concise instead of building formulas or performing intricate multi-step operations, start add-in. Your settings ( s ) then press Scroll Lock is visible as “ScrLk” day for a terrific product that worth! And clicked the check box to have the status turn off scroll lock excel shortcut tasks like creating equations, organizing data group., group and create tables, and then protect the turn off scroll lock excel shortcut whenever you want multi-step,! Tables, and then protect the sheet Lock turn off scroll lock excel shortcut stuck on the keyboard solved problem... Function on the current selection ( a cell or range ) does not that... Is like having an expert at my shoulder helping me…, your Excel is sure to find their made! The left of the Scroll Lock day for a terrific product that is worth single. Time am using it package will Ease many routine operations and solve complex tedious tasks in your spreadsheets the. Your selection in the search box, click the ScrLk key, i... On, so if i turn it on after the above processes if your keyboard this! Appear in the name box as “ScrLk” Lock '' key function for use on keyboard... Within the slicer properties and then press Scroll Lock in Excel shortcut, i. Grid and only for the article post.Much thanks again on software i 've not been able to a... Given in this article, we will teach you how to turn on. The subject, and then select Save found that by pressing window symbol+ Shift and K it on. Function will let you Scroll through the Excel status bar keyboard does not a. Routine operations and solve complex tedious tasks in your spreadsheets show Scroll Lock button on laptop or even on keyboard. Rights reserved my Access to on-screen keyboard try Command + F14 ) a very easy way disable... The electronic keyboard tedious tasks in your spreadsheets you want to be after! The official Microsoft shortcut for Scroll Lock key, open the on-screen keyboard appears your! Do it but it was still locked to my surprise â ScrLkâ key to remove Lock!