Why can't I move the excel table left or right?

Solution to the problem that the excel table cannot be moved left or right: First create a new excel table and make a cell selected; then observe the buttons on the keyboard. You can see "Scroll Lock" or "Scroll Lock" or "Scroll Lock" in the upper right corner. SCR LK", "scroll lock"; finally press the button to unlock the data cell.

When using excel to edit a document, you may encounter such a situation. After editing the content of a cell, you want to move the key on the keyboard. When I used the arrow keys to edit the cells next to me, I found that no matter which direction key I pressed, the cursor stayed on the original cell, and I had to use the mouse to move the cursor. This greatly affects the efficiency of work.

The following will teach you through examples how to solve the problem of being unable to move Excel cells when using the arrow keys.

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 use the arrow keys to move the cell down or to the right, you will find that it has been edited. The cells are always selected.

At this time, in addition to using the mouse to move cells, we actually have another Easier way to move cells using arrow keys.

Look at the buttons on the keyboard. You can see a "scroll lock" or "SCR LK" or "scroll" in the upper right corner. lock" key, 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.

More tutorials: 《php tutorial》

The above is the detailed content of Why can't I move the excel table left or right?. For more information, please follow other related articles on the PHP Chinese website!