Weird Actions for Arrow Keys and Enter
※ Download: Arrow keys are not working in excel
Thank you in advance. The last column is for hyperlinking photographs of individuals. Thanks for your understanding. Commenting privileges may be curtailed if inappropriate images are posted.
I guess I thought someone would knock on my door and tell me my question had been answered. I will only ever filter the data with the left-hand most column. When it gets locked up like this, I can still do anything in the VBE edits cells, run macros, etc. Please let us know if you would like further assistance.
My arrow keys don't move from cell to cell - Please let us know if you would like further assistance. I can't think of anything in my macro that would have these kinds of effects.
Note: This article has done its job, and will be retiring soon. If you've created links to this page, please remove them, and together we'll keep the web connected. Cause: Scroll Lock is turned on and causing the arrow keys to scroll the workbook area. Solution: Turn off Scroll Lock. Typically, when a cell is selected in a sheet and you press the arrow keys, the selection moves between individual cells, either up or down, or left or right, depending on the arrow key you press. However, if you press the arrow keys when Scroll Lock is on, you scroll one row up or one row down. Or, you scroll one column to the left or one column to the right. Scroll Lock is a toggling lock key on the keyboard, just like the CAPS LOCK key. Once pressed, Scroll Lock is enabled. To use the arrow keys to move between cells, you must turn Scroll Lock off.
Among other useful things such as page numbers; average, sum and count of selected cellsthe status bar shows if Scroll Lock is on: If your arrow keys scroll the whole sheet instead of moving to the next cell but the Excel status bar has no indication of Scroll Lock, most likely your status bar was customized not to display the Scroll Lock status. BUT, if I use the keyboard arrow keys, I can see that the active cell selection moves accordingly. Locate the search bar in the window that appears. Thanks for your understanding. I did try the switch to a new sheet and back in the tabs do get around this at least the 1 time I saw this issue and trying it. Thinking all was for naught, I plugged in my PC keyboard and fixed the problem and then unplugged it. When I return to excel thousands and thousands of cells are blue. You are the King. Instead it moves the whole worksheet which is not what I wanted. Sometimes they move the cursor off the page, arrow keys are not working in excel the cursor is non-responsive. 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. Please delete the drivers when prompted during uninstall.
