The solution? Turn it off with the Windows on-screen keyboard. But your Scroll Lock might still be enabled. If you have a relatively modern keyboard, or a keyboard with fewer than about 104 keys, you might not have a Scroll Lock key. Right-click anywhere in the bottom menu bar, and then select Scroll Lock from the context menu. Look in the bottom left corner of the Excel window and confirm that Scroll Lock is either turned on or turned off. You may also create a new workbook for the purposes of enabling or disabling Scroll Lock.
Disable Scroll Lock with the On-Screen Windows keyboard Open Microsoft Excel and load any workbook. If it has an illuminated status light, press the key to turn off the light. The fix? Look at your keyboard and see if you can find a Scroll Lock key (which might be abbreviated, such as SCRLK). 1) Press the Scroll Lock key on your keyboard. Resolution: Scroll lock functions the same as number lock or CAPS lock. > everything except the use of that scroll bar (let the possibility to scroll). > I have a control Scroll Bar in my worksheet (Excel 2003). either unlock it or assign a linked cell on a different worksheet. Reason: When scroll lock is engaged in Excel, the arrow keys will function in this manner. If you do then that cell cant be locked on a protected worksheet. This key - an artifact of an earlier time in personal computing - is rarely, if ever, used anymore, and it's little more than an attractive nuisance that gets enabled by accident and makes your computer behave in unexpected ways. Pressing the arrow keys in Excel scrolls one column up/down or left/right.
When Scroll Lock is turned on, you can use the arrow keys to scroll through the worksheet without changing the active cell. Make sure you have pressed the Fn key before pressing the F14 key. The F14 key is the shortcut for scroll lock feature. If you have the F14 key along with Fn key on your keyboard, it should be a more comfortable option to use. You press the arrow keys, but instead of the cursor moving to another. In that case, it should be easy for you to work with it to disable scroll lock. First, when Scroll Lock is turned off, you can use the arrow keys to change the active cell. You're working along in Excel, and suddenly you notice you can no longer move around properly. The most common solution is to turn off Scroll Lock. Excel displays Scroll Lock in the status bar. Most of the time, if your arrow keys aren't moving the cursor from cell to cell, the fix is as simple as disabling the Scroll Lock key on your keyboard. If your arrow keys are not working in Excel, there are a few simple ways to troubleshoot and solve this problem. If your keyboard has a Scroll Lock key, make sure it's not enabled.
0 kommentar(er)
