Pressing Ctrl + Scroll Lock performs the same function as pressing Ctrl + Break (Pause) . This behavior is a remnant of the original IBM PC keyboards, which did not have a dedicated Break (Pause) key. Instead, they assigned the Pause function to Ctrl + Num Lock and the Break function to Ctrl + Scroll Lock .
Shift + F14
1. Select the Unfreeze Panes options
On my new company HP Elitebook, I found you have to press 'FN Lock' & 'FN' & 'C' together to turn the scroll lock on and off.
One of the common reasons why the arrow keys don't work in Excel is because you've enabled the scroll lock feature on your computer. ... Simply press the scroll lock button on your keyboard and the lock will be disabled.
On most keyboards, it's located in the control keys section of the keyboard, above the arrow keys or right of the function keys. On a Mac computer, to toggle scroll lock on and off, press the F14 or the Shift + F14 key combination. If that does not turn off scroll lock, try pressing Command + F14 .
Yes, you can scroll smoothly in Excel if you drag with the middle mouse button.
For Windows 10:
What you can try to do is :
Disabling scroll lock on a Mac is just as easy—but only if you have a full-size keyboard. On an extended keyboard, hit the F14 button to turn scroll lock on and off. You may have to hit Shift + F14, depending on your settings. (If that doesn't work, try Command + F14).
Turn off Scroll Lock
MacBook keyboards do not have a dedicated Scroll Lock key, which is typically found at the top of a PC's keyboard. However, MacBooks do have "Fn" and "F12" keys, which you can use to activate the Scroll Lock shortcut.
Modern Microsoft Windows keyboards typically have only 12 function keys; Shift+F1 must be used to type F13, Shift+F2 for F14, etc. It can modify various control and alt keys. For example, if Alt-Tab is used to cycle through open windows, Shift-Alt-Tab cycles in the reverse order.
To access the F13 through F24 keys in a Command Prompt Telnet (VT100) session, you should press and release the ESC key and hold down the shift key, plus the number key you want. For F14, press and release the ESC key, then SHIFT+2 key.
The F12 key is a function key found at the top of almost all computer keyboards. The key is most often used to open Firebug, Chrome Developer Tools, or other browsers debug tool.
space key
The 'shift' keys are on the left and right of the keyboard, with the arrow pointing upwards. For capital letters, hold down the 'shift' key and hold and type the letter.
Keyboard shortcuts using the Shift key
QWERTY row
Any properly trained touch typist will use the both Shift keys appropriately. For left finger keys, one uses Right Shift, and vice versa. Non-touch typists tend not to use the Right Shift key as much.
To make it easier to type uppercase characters that appear on the left side of the keyboard. It's easier to type shift-T using the right pinkie and left index finger than with the left pinkie and left index finger. Similarly for shift Y with the hands reversed.
The shift key is pressed by the pinky finger on the hand opposite to the one hitting the key. So, if you are typing a capital A, S, D, F or G use the shift key on the right side of the keyboard, with the right pinky finger.
Your pinky fingers are responsible for pressing the SHIFT keys. You will press the SHIFT key with the pinky finger that is opposite to the one pressing the other key. For example, if your left index finger is going to press the F key for the uppercase version then your right pinky will press the SHIFT key.
The left hand pinky finger starts things off on the “A” key, the ring finger sits on the “S” key, the middle finger takes the “D” and the index the “F”.
There are two shift keys; each is pressed by the right or left fourth finger (your pinkie finger). Use the right shift key when typing letters or symbols with the left hand. Use the left shift key when typing letters or symbols with the right hand.