Selection in Excel is the most basic action we will make. And in this article, we will talk about the selected cell will change on different shortcut keys.
There are many different methods to select certain cells. One of the methods is using the buttons on the keyboard. For instance, you will use the arrow keys to change the position. And in this article, we will discuss about the “Enter” and “Tab” buttons in detail.
Tip 1: Change the Direction of Enter button
You will find that if you use the “Enter” button, the cursor will move to the next cell in the same column. This is because the default setting of the direction of “Enter” is downwards. However, you can also change the direction according to your operation preference.
- Click “File” in the ribbon.
- And then click “Options”.
- In the “Excel options” window, choose the tab “Advanced”.
- In the “Editing options” part, choose the direction of the button.
- And then click “OK” to save the setting. Now come back to the worksheet and you can have a try. The direction will change according to your setting.
Tips 2: Shortcut Key Combo for Reverse Direction
The direction of “Enter” button can be changed manually. And another button “Tab” in the key board can also change the cell. If you press it, the cursor will move to the right.
On the other hand, you may use another key “Shift” to move to the reverse direction. For example, the direction of “Enter” is down. And now you press the shortcut key combo “Shift + Enter”, the cursor will move upwards. Besides, it will move to the left if you press the button “Shift +Tab”. So you can also apply this in your operation.
Tips 3: The Combination of Tab and Enter
The “Tab” and “Enter” buttons can also work together in your worksheet. Here the direction of “Enter” is downwards. In the image below, you can see the values in the cell.
Suppose now the cursor is in the cell A1. Now you press “Tab” and see that the cursor move to the right. When it reached the end of the row, such as C1 in this image, press “Enter”. Then you can see that the cursor will move to the cell B1 instead of C2.
The other condition is a little different. Here you need to select the area “A1: C10” at first. Now you press the “Tab”, the cursor will move within this area. When it reaches to the end cell C3 of the row, it will then move to the first cell of next row rather than C4. Besides, here if you press “Enter”, the cursor will move directly downwards. Even if the cursor is in the last cell of a row, it will not move to the first cell of next row.
Some Operations maybe Invalid in a Damaged Excel
If your Excel is damaged, you will not able to do certain works. This may cause great inconvenience to you. But now, you can use our wonderful tool to repair Excel. This software can fix almost all the errors that happen in Excel.
Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com