Use the arrow keys to move through a worksheet To move between cells on a worksheet, click any cell or use the arrow keys. Disable scroll lock in Excel using the keyboard If your keyboard has a key labeled as Scroll Lock or ScrLk key, just press it to turn Scroll Lock off. Cause: Scroll Lock is turned on and causing the arrow keys to scroll the workbook area. Pan through a worksheet automatically Click the wheel button, and then move the mouse in the direction that you want to scroll. I could enable Scroll Lock with the script.
Done : As soon as you do this, Scroll Lock will disappear from the status bar and your arrows keys will move from cell to cell normally. This thing is pretty fragile. The thread wasn't closed and others subsequently gave alternative answers, eg activate a different sheet. While researching this problem, I ran into a nice AppleScript by Damien Clark. How to disable Scroll Lock on a Mac The official Microsoft shortcut for Scroll Lock is Shift + F14. If you come back to find it doesn't work for you, please reply to us and unmark the answer.
Also, you may click the button on the on-screen keyboard, absent the choice on the physical keyboard. 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. First, make sure Scroll Lock is really enabled. Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 There are different ways to scroll through a worksheet. I also learned that saving the document will also fix the problem for a short while until it randomly comes back.
To close the on-screen keyboard, click the X button in the upper-right corner. Press any arrow key and watch the address in the name box. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars. I've had the issue since upgrading to office 2016 as well. On most keyboards, it is located in the section of the keyboard, above the arrow keys or the right of the. The following table describes different ways for using the scroll bars to move through a worksheet.
Point to the split box on either the vertical or the horizontal scroll bar. Please let me know if you found the cause and or the solution. If you see a small bar with a few keys, click General. To speed up scrolling, move the pointer away from the origin mark. My computer is running Windows 10.
In Microsoft Excel, turning Scroll Lock on allows you to use the arrow keys to navigate your business spreadsheet without moving the cell that you have selected. How can you press a key you don't have? Note: This article has done its job, and will be retiring soon. Any one else have any ideas what else we can try? Moving the mouse in the opposite direction slows down the scroll speed. Right click the status bar to make sure Scroll Lock status is enabled: The Scroll Lock setting here doesn't control Scroll Lock, it only displays Scroll Lock status. But, after an hour so of fiddling around, I couldn't get it to work, and I'm not sure it can be done. To Do this Scroll up or down a few rows at a time Rotate the wheel forward or back.
I'm on my personal laptop using the latest version of Windows 10 with all the patches but had the same issues on my work laptop. One of the things you can do with AppleScript is send keystrokes to an application. If you found this post useful, would you mind helping me out by sharing it? Anyone know what I can do to get it to work again? Scroll Lock can be disabled by clicking the Scroll Lock key on your keyboard. Scroll Lock is the feature that controls the behavior of the arrow keys in Excel. If I click on another tab and then return to the initial worksheet, all is well. Although helpful for a user viewing a large worksheet, it is also quite annoying for those who have mistakenly enabled this feature. AppleScript to the rescue On Macs, AppleScript is a built-in scripting language that can be used to automate applications and other general tasks.
Before you panic and call support to tell them Excel is broken, check to see if Scroll Lock has been accidentally enabled. Our courses are relevant for audit, assurance services, taxation, management consulting, advisory, actuarial, corporate finance and legal services. Click to participate the survey. When the arrow keys scroll through your entire spreadsheet rather than moving from cell to cell, the culprit of this behavior is the. The position of a scroll box indicates the relative location of the visible area within the worksheet.
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. You can always ask an expert in the , get support in the , or suggest a new feature or improvement on. 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. Among other things, the largest of the sheets will stop scrolling. Now Scroll Lock is disabled and the Arrow Keys allow us to navigate and select different cells within this worksheet. I used to be able to use the arrow keys on my keyboard to move from cell to cell, but all of a sudden that has stopped working.
It must be a bug. It seems a bug related somewhere to the workbook to me and is very annoying. But instead of moving to the next cell, the whole worksheet moved. Now the arrow keys cause the entire page to move either up and down or side to side. If you've created links to this page, please remove them, and together we'll keep the web connected. It has nothing to do with the Scroll Lock being on or off.