Example 6 –Move Cells Using Arrow Sign In addition to moving around a workbook using the arrow keys, we can also move a single column or row of cells to another location using the arrow sign that appears when you select a cell, row, or column. Steps: Select the cells you want to mo...
Fix 1 – Turning Off the Scroll Lock Key to Fix Excel Arrow Keys Not Moving Between Cells As shown in the image below, theScroll Lockis active. When we press the right arrow (→) the page is moved instead of the cell. You remain in theB5cell as before, but in a different sheet i...
If you find difficulty moving between cells on the worksheet and your cells are not working properly, leading to a condition of excel arrow keys not moving cells, it mostly happens when: View Mode of Protected Worksheet While Processing Complex Data Working in Entry Mode Enabled Scroll Lock opti...
When everything is working as expected, when you hit the up arrow key or the down arrow key in Excel, you would expect the cursor to go to the cell above or below. And since you’re reading this article, I can assume that it’s not happening with your Excel. One common issue with...
One of the primary reasons for the arrows not working between cells inMS Excelis that theScroll Lockis turned on. So, till the time it’s turned on, the up and the down arrows will not function as usual. Most of the computer keyboards have aScroll Lock(ScrLk) key on them and if yo...
While working on MS Excel, we usually tend to move between cells using the arrow keys on your keyboard. That comes naturally to us and that’s the easiest way instead of moving between cells using the mouse. However, sometimes the arrow keys may stop working. This can be frustrating becaus...
Actually if we are working on a worksheet in MS Excel, we can move from one cell to another cell using arrow keys on our keyboard but when this problem occurs, wecan’t switch between cells using arrow keys. The whole worksheet i.e. page or screen moves up and down instead of moving...
When you’re working on an Excel spreadsheet, the best way to move between cells is to use the arrow keys on your keyboard. With these keys available for each direction, you can easily go from one cell to another with a single key-press. Sometimes, it ha
I have 2 client pc's running office 365 and randomly during extensive Excel usage their pages will almost freeze/lock up and their arrow keys no longer move between cells. Please note this is not he scroll lock issue where it changes the arrows from moving between cells to ...
(selected cell) with the arrow keys. In addition, i can't click in the formula bar to edit it. flipping back and forth between worksheets stops the problem for a short while. I also learned that saving the document will also fix the problem for a short while until it randomly comes ...