It seems a bug related somewhere to the workbook to me and is very annoying. To Do this Scroll up or down a few rows at a time Rotate the wheel forward or back. Shifting to another worksheet helps until editing or filling-in a cell. Turning off scroll lock with the keyboard key To toggle scroll lock on and off, press the. The Scroll Lock key may be located above the arrow keys, with the numerical keypad or associated with one of the function keys, e. Simply press the Scroll Lock key again and your arrow keys should start working the way they did before. When the arrow keys scroll through your entire spreadsheet rather than moving from cell to cell, the culprit of this behavior is the.
But I stumbled on a quick solution. In Excel, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and ScreenTips that let you know where you are in the worksheet. Click Start or tap the Windows key and type osk then click to open the On-Screen Keyboard. Usually, the arrow keys will move you one cell at a time in whatever direction you wish. Just click one of the handy social media sharing buttons below.
You'll know that Scroll Lock is disabled when the ScrLk key returns to dark-grey. The up and down arrow keys scroll one row up and down, and the right and left arrow keys scroll one column right and left. Scroll Lock can be disabled by clicking the Scroll Lock key on your keyboard. How to disable Scroll Lock on a Mac The official Microsoft shortcut for Scroll Lock is Shift + F14. Usually, when the Scroll Lock is disabled, arrow keys move you between individual cells in any direction: up, down, left or right. If so, there is a very easy fix. Anyone know what I can do to get it to work again? Addendum: Right-click Excel's bottom status bar and put a check beside Scroll Lock to get a scroll lock indicator on the left side of the status bar.
How to disable Scroll Lock on Windows If you're using a full keyboard in Windows — one that has a Scroll Lock key — simply press the key to disable. For some reason, Excel randomly freezes the panes on these worksheets from time to time. When the pointer becomes a double-headed arrow , drag the split bar onto the worksheet where you want to split the window. Scroll through a worksheet with increased scroll speed While scrolling, hold down the mouse at the farthest end of the screen for more than 10 seconds to increase the scrolling speed. If you have an extended keyboard with an F14 key, try that first. I hope someone knows a solution. Before you panic and call support to tell them Excel is broken, check to see if Scroll Lock has been accidentally enabled.
Randomly, I will not be able to move the cursor selected cell with the arrow keys. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. I have a very simple macro activated by a button on a form that simply switches to a new tab. However, I couldn't get the script work like I expected. The following sections give quick, simple instructions for turning off the scroll lock feature. Windows - Turn off the Scroll Lock feature by pressing the Shift- Scroll Lock ScrLk keys.
Scroll through a worksheet with increased scroll speed While scrolling, hold down the mouse at the farthest end of the screen for more than 10 seconds to increase the scrolling speed. You can always ask an expert in the , get support in the , or suggest a new feature or improvement on. If Scroll Lock status is not enabled in the status bar, it might be toggled on and you'll never see it. The On-Screen Keyboard in Windows, Scroll Lock key in white Once the keyboard is displayed, make sure Excel is the active application and click the ScrLk key. As it's not indicated by default, and newer keyboards don't include it, need to right click the status bar and customize.
Your report is due in an hour. To stop automatic scrolling, click any mouse button. To determine if it's the case, right click the status bar and see if there is a tick mark to the left of Scroll Lock. Most often I am modifying a value in a cell, sometimes editing a formula, but often just changing a data value and when I hit enter all of a sudden my cursor keys are disabled. Unfortunately, it's harder to disable Scroll Lock if your keyboard doesn't have a Scroll Lock key. Click Start or tap the Windows key and type osk then hit to open the On-Screen Keyboard.
For more information, see the instructions for your pointing device. About the Author Chris Daniels covers advances in nutrition and fitness online. I've had the issue since upgrading to office 2016 as well. One window up or down Click above or below the scroll box on the vertical scroll bar. Were you able to solve your problem? Or, you scroll one column to the left or one column to the right. Then, since I want the top row frozen, I scroll to the top, click on the top row, click Freeze Panes again, and select Freeze Top Row. If you are working on a smaller keyboard that does not have the F14 key, you can try to remove Scroll Lock by running that emulates the Shift + F14 keystroke.
You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars. The percentage of the zoomed worksheet is displayed on the status bar. I have a monster Excel spreadsheet with tens of thousands of rows, correlated. It has nothing to do with the Scroll Lock being on or off. Also, you may click the button on the on-screen keyboard, absent the choice on the physical keyboard.