Using Scroll Lock in Excel
The scroll lock key (ScrLk) is on most keyboards but its purpose isn't widely understood. These days, most programs make no use of it but Excel is an exception. This video shows how it can be useful in Excel and a work-round if your keyboard has no scroll lock key.
For more info, see https://isladogs.co.uk/scroll-lock-ex...
TIMES:
0;:00 What is the scroll lock key?
0:42 Excel is one of very few programs that use it
1:02 Not on all modern keyboards but available on the on-screen keyboard designed for accessibility
1:22 Excel DEMO with scroll lock :
a) OFF - arrow keys move from cell to cell
b) ON - arrow keys move entire Excel window but selected cell unchanged
1:58 Status bar indicator
2:35 Confusion for users if unsure what scroll lock does
3:02 Editing the status bar