How to use scroll lock in excel11.07.2020
Scroll Lock in Excel
Step 1: Press Window + R key together. Step 2: You will see this below dialogue box. You need to type OSK here. Step 3: Now press the OK button. You will see ON SCREEN KEYBOARD. Step 4: You can notice the ScrLk key is turned on with a blue-colored key indication. You need to press this button. When Scroll Lock is turned on, you can use the arrow keys to scroll through the worksheet without changing the active cell. Excel displays Scroll Lock in the status bar. What is Scroll Lock? First, when Scroll Lock is turned off, you can use the arrow keys to change the active cell.
Just imagine this. You are working on a spreadsheet normally when all of a sudden you lcok that you cannot move from cell to cell - instead scrll getting to the next cell, the arrow keys scroll the whole eexcel.
Don't panic, your Excel is not broken. You have just accidentally turned Scroll Lock on, and this can be easily fixed. Usually, when sxroll Scroll Lock is disabledarrow keys move you between individual cells in any direction: up, down, left or right. However, when the Scroll Lock is enabled in Hoow, arrow keys scroll the worksheet area: one row up and down or one column to the scro,l or right. When the worksheet is scrolled, the current selection a cell or range does not change.
To see whether the Scroll Lock is turned on, just look at the status bar at the bottom of the Excel window. Among other useful fxcel such as page numbers; average, sum and count of selected cellsthe status bar shows if Scroll Lock is on:. If your arrow keys scroll the whole sheet instead of moving to the next cell but the Excel status bar has no indication of Scroll Lock, most likely your status bar was customized not to display the Scroll Lock status.
To determine if it's the case, right click the status bar ue see if there is a tick mark to the left of Scroll Scrlll.
If a tick mark is not there, simply click the Scroll Lock to have its status appear on the status bar:. Done :. 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. If you don't have the Scroll Lock key or it does not work for some reason, you can "unlock" Scroll Lock in Excel by using the on-screen keyboard. You'll know that Scroll Lock is disabled when the ScrLk key returns to dark-grey.
If it is blue, Scroll Lock is still on. So, how can you know that Scroll Lock is on? Press any arrow key and watch the address in the name box.
If the address does not change and the arrow key scrolls the whole worksheet, it's safe to assume that Scroll Lock is enabled. That's how you turn off Scroll Lock escel Excel. I thank you for reading and hope to see you on our blog next week! For security excep my access to on-screen keyboard is disabled, then how do I turn off scroll lock. 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 hoow happen that it will on automatically without doing anything from user side. 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. Thank you very much! Your explanations are easy to understand and follow. All articles are well explained. They are very helpful. Went in and clicked the check mark off scroll lock and thought that how to install wireless driver in kali linux do it but it was still locked to my surprise.
No scroll lock button on laptop or even on the electronic keyboard. Not sure what to do now. 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? Just want to know, there is hlw Scroll Lock key on my keyboard and Scrool don't use on-screen keyboard. Scrol did the scroll lock status get changed? Are there any short cut key? To turn off scroll lock on iMac short sscroll only goes to f No need scrll waste that much effort as given in this article. Thank you. I tried pretty much avery complicated combo on my keyboard, but the obvious ones : You helped a lot.
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. Thank you so much. There're a 1, 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 so much - you not only saved me much frustration but it is great to know how what caused the problem hlw the first place. Was driving me crazy trying to figure our how it was getting turned on.
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 scrokl to retain a fixed location on the grid and only for the slicer options to work.
Hi, my on screen keyboard returns an error, which I cannot resolve. I ues all the shortcuts mentioned above and none worked for me. I am using an Asus zenbook UXU. None of the options here worked for me. Tried the keyboard, didn't work, tried the different how to lower nitrate levels in pond combinations and none worked. Using an HP Seems different laptops have different hotkey shortcuts to handle scroll lock. Seemingly endless minute searching to resolve Dell laptop's scroll lock agony yielded no results.
Then I found your solutions! Thanks for helping me get back to more productive things than tearing my hair out and wanting to how to draw pokemon umbreon step by step this computer over my knee.
Thank you so much for this! Especially adding the little trick on how scroll lock is triggered in Dell Laptops. So I had to look this up to see if anyone knew why the stupid scroll how to make puffed pork rinds keeps 'magically' turning on in Excel when my HP laptop has no key for it.
The damn C key should have a little 'Scroll lock' printed on it if they are going to do that to people. Thank you so much! Knowing how to turn off the scroll lock on my tablet in Excel saved me so much aggravation! Thanks a lot for this informative Page. This is very helpful for me to unlock the Scroll on my Excel File. This is amazing. The internet is virtually flooooooded!! I am truly amazed at this.
How can sooooo many people deliberately choose to answer this wrong?? The problem is that everyone! But then why, You accidentally clicked this XYZ keyboard combo which is set as shortcut for enabling scroll lock. Please try to avoid the scrolo 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! What is Scroll Lock in Scrkll Scroll Lock is the feature that controls the behavior of the arrow keys in Excel. How to determine that Scroll Lock is hhow To see whether the Scroll Lock is turned on, just look at the status bar at the bottom of the Excel window. Among other useful things such as page numbers; average, sum and count of selected cellsthe lcok bar shows if Scroll Lock excfl on: If your arrow keys scroll the whole sheet instead us moving to the next cell but the Excel status bar has no indication of Scroll Lock, most likely your status bar was customized not to display the Scroll Lock status.
If a tick mark is not there, simply click the Scroll Lock to have its status appear on the status bar: Note. The Excel status bar only displays the Scroll Lock status, but does not control it. Escel Excel Tips and How-to. May 26, at am. Svetlana Cheusheva, thanks a lot for the article post. Much thanks again. Leo fxcel. August 2, at pm. Vivek says:. November 16, at pm.
TTG says:. January 16, at pm.
May 23, · The fastest way to turn off Screen Lock in Excel is this: Click the Windows button and start typing " on-screen keyboard " in the search box. Usually, it is sufficient to type the first two characters for the Click the On-Screen Keyboard app to run it. Author: Svetlana Cheusheva. A very easy way to turn on or turn off scroll lock is to press the Scroll Lock button on the keyboard. Open the Excel, and then press Scroll Lock button on the keyboard to turn on it. By default, the Scroll Lock is off. If you want to turn scroll lock off, just need to press the Scroll Lock button again.
In Excel, when you press Up and Down arrows or Left and Right arrows incautiously, the active cell moves at the same time. Sometimes, this is quite annoying, and you want to turn it on. Here, I talk about how to turn this scroll lock on or off in Excel. A very easy way to turn on or turn off scroll lock is to press the Scroll Lock button on the keyboard. Open the Excel, and then press Scroll Lock button on the keyboard to turn on it.
By default, the Scroll Lock is off. If you want to turn scroll lock off, just need to press the Scroll Lock button again. If there is no Scroll Lock key in your keyboard, you can use this this method. See screenshot:. Right click any blank place on the screen in the Windows 8, and click the Personalize from the context menu. In the opening folder, click the Control Pane Home in the left.
See screen shots below. If you just want to display a working area in a sheet i Excel, you can apply the Set Scroll Area utility of Kutools for Excel to set a scrolling area of data you need to read. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you.
Once you have received the verification code, you will be able to choose a new password for your account. About Us Our team. See screenshot: 2. See screenshot: 3. Set scroll area in Excel If you just want to display a working area in a sheet i Excel, you can apply the Set Scroll Area utility of Kutools for Excel to set a scrolling area of data you need to read.
Kutools for Excel , with more than handy functions, makes your jobs more easier. Free Download Full future 30 days free trial.
Read More Free Download You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished. Thanks a lot!! This article helped me save a lot of time today : :.