Data entry is a usual job when we work with Excel spreadsheet. If we can control Excel cursor movement during data entry, this job can be a thankless job, or else it can be a hateful job. In this post you will be introduced some quick tips for controlling cursor’s movement.
First tip, change cursor movement setup
You can easily press key “Enter” to move the cursor down to the next cell. Or if you are entering data from column to column you can press “Right Arrow Key”. Perhaps press key “Tab” is easier. However, the easiest solution is to change the cursor movement setup as the following steps.
First tip, change cursor movement setup
You can easily press key “Enter” to move the cursor down to the next cell. Or if you are entering data from column to column you can press “Right Arrow Key”. Perhaps press key “Tab” is easier. However, the easiest solution is to change the cursor movement setup as the following steps.
- Click “File” tab to “Options (under Help)”. In Excel 2007, click the “Office” button, and then click “Excel Options”. In Excel 2003, choose “Options” from the “Tools” menu.
- In the left pane, select “Advanced”. In Excel 2003, click the “Edit” tab.
- In the “Editing Options” section, select “Right” from the Direction dropdown under the After Pressing Enter, Move Selection option, as shown. You can choose Right, Left, Up, and Down. In Excel 2003, the option is Move Selection After Enter.
- Click OK.
This can make your data entry job at your will from the beginning. If you don’t like the style, it’s easy to reset.
Second, select data input range
This trick is a temporary solution. Before enter data, we can select the data input range. Excel will move the cursor from column to column until you reach the right-most column in the selection. When we press key “Enter”, the cursor will be moved to the left-most column in the next row. For example, if we want to enter data inA29:B33 as the image shows below, we can first select the area. When we input data, Excel will automatically select A29. After that will be B29. And then, it’s A30 not C29.
Second, select data input range
This trick is a temporary solution. Before enter data, we can select the data input range. Excel will move the cursor from column to column until you reach the right-most column in the selection. When we press key “Enter”, the cursor will be moved to the left-most column in the next row. For example, if we want to enter data inA29:B33 as the image shows below, we can first select the area. When we input data, Excel will automatically select A29. After that will be B29. And then, it’s A30 not C29.
单击此处进行编辑.