Home>Article>Topics> Why can't I move the excel table left or right?

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

卡哇伊
卡哇伊 Original
2020-07-16 13:49:22 61868browse

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.

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

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.

Why cant I move the excel table left or right?

Why cant I move the excel table left or right?

Why cant I move the excel table left or right?

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

Why cant I move the excel table left or right?

2.Why cant I move the excel table left or right?

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.

Why cant I move the excel table left or right?

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.

Why cant I move the excel table left or right?

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.

Why cant I move the excel table left or right?

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.

Why cant I move the excel table left or right?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn