Summary: When entering huge groups of values in Excel 2007, make the cursor move where you want it.
For efficiency, huge numeric data-entry tasks in Microsoft Excel 2007 should require as little use of the mouse or extraneous keypresses. To aid in this regard, Excel 2007 automatically moves the cursor down when you press Enter. This speeds up entering a group of values that need to appear in a column.
(Pressing Enter is more convenient than using the cursor keys if your hands are on a numeric keypad).
If needed, Excel can instead move the cursor to the right, up, or even to the left after pressing Enter.
1. Access the Microsoft Excel 2007 Options menu.
2. When the “Excel Options” dialog box appears, select “Advanced” in the left pane.
3. In the right pane, underneath “Editing options”, make sure “After pressing Enter, move selection” is checked.
4. Underneath, next to “Direction”, click the pull-down and choose the desired direction.
5. Click “OK” to close the “Excel Options” dialog box.