- #Excel shortcut keys not working full#
- #Excel shortcut keys not working free#
- #Excel shortcut keys not working windows#
Unfreeze the panes by the Unfreeze Panes option in the View tab > Window group, Freeze Panes button. Another indicator would be the black lines representing the frozen panes.
If that happens, you can quickly deduce that the culprit is Freeze Panes. With frozen panes, the arrow keys will move on the sheet but will not navigate to cells that you can't already see in the current screen. The Freeze Panes feature in Excel freezes the first row or column or the current screen based on the selected cell: Fix: Exit Formula Edit ModeĮxit formula mode or edit cell mode by pressing the Esc key or clicking on another cell. If you directly start typing in a selected cell, the arrow keys will still work for navigating around the sheet. Note: This only occurs with cell edit mode using F2 or the Formula Bar. The arrow keys will not work for cell selection. Similarly, while in cell edit mode (by pressing the F2 key or editing a cell in the Formula Bar), the arrow keys only work left and right to edit the contents of the cell. At this point, you cannot select a cell for anything other than having it referred in the formula. Instead, they will reference the selected cell in the formula. When entering a formula in a cell, the arrow keys will move around but won't work as the cursor. The Scroll Lock notification will also disappear from the Status Bar: This will disable scroll lock and the arrow keys can be used again to navigate around the sheet. Select the Scroll Lock key to disable the scroll lock.The keyboard will display with the Scroll Lock on:.In the left panel, select Keyboard in the Interaction Then click on the Use the On-Screen Keyboard switch to turn the on-screen keyboard on.Go to Start menu > Settings > Ease of Access.
#Excel shortcut keys not working windows#
To display the on-screen keyboard, press the Windows + Ctrl + O keys.
#Excel shortcut keys not working free#
Windows users, you are free to use the on-screen keyboard to stroke the key. If your keyboard doesn't have the Scroll Lock key, you needn't despair. If the scroll lock is on, one keystroke of the Scroll Lock key can disable it. Pressing the key can enable and disable the scroll lock.
#Excel shortcut keys not working full#
The key can be in full form or short form as "Scroll Lock" or "Scr Lk". The Scroll Lock key comes most often on a keyboard with a numeric keypad. Very firstly, if your keyboard has the Scroll Lock key, that's the whole problem solved. To turn the scroll lock on and off, read ahead what you have to do. Bear in mind that it is a notification setting and not a toggle that turns scroll on and off.
With this setting unticked, the Status Bar will not notify of the scroll lock being on. With this setting enabled, when the scroll lock is on, it will show in the Status Bar and when the scroll lock is off, the Status Bar will be blank as usual. "On" and "Off" are the indicators of scroll lock.
If there is a tick mark with Scroll Lock, that means that the Status Bar will show "Scroll Lock" if it's on. You have to enable the scroll lock display simply by right-clicking on the Status Bar. What's the other way? Another giveaway would be "Scroll Lock" shown in the Status Bar.īut this is not always the case. That's one way to tell that the scroll lock is on. With the scroll lock on, the arrow keys will be locked from navigating from cell to cell and will scroll the screen of the worksheet instead. Most common reason for the arrow keys not working (or working differently) is scroll lock and we'd be lying if we said it hasn't happened to us.