What should I do if the keyboard arrow keys cannot move cells?

Solution to the problem that the keyboard arrow keys cannot move cells: 1. Open a spreadsheet and check whether the cell is selected; 2. Find and press the "Scroll Lock" key on the keyboard or It is the key that displays "SCR LK" and "scroll lock"; 3. Re-enter excel to make the cells move with the keyboard direction keys.

#The operating environment of this tutorial: Windows 10 system, Microsoft Office Excel 2010, Dell G3 computer.

What should I do if the keyboard arrow keys cannot move cells?

First let’s take a look at the specific situation. As shown in the figure, a cell in the spreadsheet is currently selected. If you want to move the cell down or to the right through the arrow keys, It is found that the edited cells are always selected.

At this time, in addition to using the mouse to move cells, there is actually a simpler way to use the arrow keys to move. Cell.

Look at the buttons on the keyboard. You can see a "scroll lock" or "SCR LK" or "scroll lock" key in the upper right corner, as shown in the figure. .

PS: Different keyboards may be marked differently, but it is nothing more than the above situations.

At this time, press the "SCR LK" button and you will find that an indicator light on the keyboard will go out, which means that the scroll lock has been cancelled.

At this time, return to excel and continue to use the arrow keys to move the cells. You will find that the cells can move with the arrow keys.

Sometimes when using a spreadsheet to check data, we can also lock the scroll, so that a certain cell can be locked when checking data, making the checking work more convenient and efficient.

Related learning recommendations: excel tutorial

The above is the detailed content of What should I do if the keyboard arrow keys cannot move cells?. For more information, please follow other related articles on the PHP Chinese website!