Now, go to your Excel sheet and try using the arrow keys. Step 3: Now, you should notice that the ScrLk button ( Scroll Lock) is blue colored, which means, it’s enabled.Ĭlick on the on-screen keyboard to turn it off and the blue colour should be gone now. Step 2: In the search field, type OSK.EXE and hit Enter to open the on-screen keyboard. Step 1: Press the Win + R shortcut keys on your keyboard to open Run command.
#HOW TO USE UP AND DOWN ARROWS IN EXCEL HOW TO#
Let’s see how to use the on-screen keyboard to turn off the Scroll Lock key: The on-screen keyboard is also useful when any of the keys of the physical keyboard is damaged or when they just stop working. In such situations, you can use the on-screen keyboard that offers all the keys including the ones that are not present on the physical keyboard. That’s because the recent PC and the laptop models has removed this key, thinking that users rarely use it. Many modern PCs and laptops do not have the Scroll Lock ( ScrlLk) key on their keyboards. Method 2: Turn Off Scroll Lock Using On-Screen Keyboard Now, try using the up and down arrow keys on your spreadsheet and it should work normally. When you notice that the light of the button is switched off, it means that the Scroll Lock is also turned off. Now, press the button once to turn it off.
Most of the computer keyboards have a Scroll Lock ( ScrLk) key on them and if you see that the light for the key is on, it means that the Scroll Lock is turned on. So, till the time it’s turned on, the up and the down arrows will not function as usual.
One of the primary reasons for the arrows not working between cells in MS Excel is that the Scroll Lock is turned on. Method 1: Turn Off the Scroll Lock Using Keyboard Method 2: Turn Off Scroll Lock Using On-Screen Keyboard.Method 1: Turn Off the Scroll Lock Using Keyboard.
0 kommentar(er)
