Hello everyone and welcome to our channel, The Teacher
My name is Rajiv and today we are going to learn about the Scroll Lock Key
If you are not already familiar that what the Scroll Key does, then here are some explanation
about this toggling lock key. Just like Caps and Num Lock Key on your keyboard
Scroll Lock is typically used in Excel or other spreadsheet programs and honestly I
have never seen or used it in any other application. Before we go and start tapping Scroll Lock Key, let me explain you something
Have you ever compared the difference between scrolling your worksheet from the arrow keys
of your keyboard and scrolling through vertical or horizontal scroll bars or from the mouse
wheel and if you have not, then let me clear you the difference first before we start talking
about the Scroll Key. Notice, when I move or change my active cell position by using the Up, Down or Left, Right
arrow keys from the keyboard, even though I am scrolling through the worksheet horizontally
and vertically, but the active cell is also getting changed. So when you scroll through arrow keys, your active cell or you can say that the cursor
position changes accordingly. But when you scroll through scroll bars or through the mouse wheel, your cursor position
or active cell remain the same, doesn't matter how far you scroll through your worksheet
You might be thinking that how this is related to Scroll Lock
I will explain you this in a minute. First, you can find the Scroll Lock Key at the top right corner of your keyboard, usually
between the Print Screen and Pause Break keys. And if you are using a Notebook or Tablet, then they might don't have a Scroll Lock Key
Then you can open the On-Screen Keyboard from Ease of Access Enter of Control Panel
Or you can directly type and search it right from your Start Menu
From the On-Screen Keyboard, you can find Scroll Lock at the lower right corner with
a short name SCRLK. Click it once, will turn on the Scroll Lock and then you can minimize the On-Screen Keyboard
if you don't want to use it further. You might not get confused that either the Scroll Lock is on or off
So you can right click on the Status Bar of your Excel and then make a checkmark on Scroll Lock
You will see an indication about the Scroll Lock Key status in your Status Bar
So finally when the Scroll Lock is on and you move through your worksheet using the
arrow keys from your keyboard, the arrow keys start behaving like Scroll Bars or Mouse Wheel
and the current active cell remain the same as you scroll through your worksheet
When you need to go back to the active cell or the same position where you were before
in your worksheet, then you don't need to scroll back again. Just hold down the Ctrl key and then press Backspace and in an instant, you will be right
back at the active cell. This shortcut really saves a lot of time when you scroll through larger worksheet and this
shortcut will also work if you are even scrolling through Scroll Bars or Mouse Wheel
When you need to go back, just press Ctrl Backspace and that's it
You will be right back at the active cell. When you no longer require to use the Scroll Lock, turn it off by pressing it once again
and you can immediately see the notification from the Status Bar has been removed and now
your cursor or active cell will changes as you will scroll through your worksheet using
the arrow keys. So this was all about using Scroll Lock Key and if you found this video useful, then don't
forget to hit the Like button and share this video with your friends
You can subscribe to our channel to stay in touch. Thanks for watching and we will meet in our next video
Bye and take care