Excel 2007 Using Tips: Move cells quickly

When you use Excel 2007 to edit a worksheet, you typically use the mouse to click a cell to enter data, but in fact we can use keyboard shortcuts to quickly move cell entry data. Let's take a look at what shortcuts on the keyboard can move cells.

Click Microsoft Office buttons, and then click Excel Options. Click Advanced, under Edit, select the move selection after the Enter key check box, and then in the direction box, select the direction you want to be the active cell, such as right, and OK.

Excel 2007

Now that you have finished editing a cell in the Excel 2007 worksheet, press ENTER, and the insertion point moves to the right cell. Perhaps you don't want to make changes to the default settings for Excel 2007, just temporarily change the moving direction of the active cell, then try the following keys:

Shift+enter key--upward;

TAB key--right;

Shift+tab Key--left.

Excel 2007 when editing a worksheet, there is usually a lot of data to enter, so side by side with the mouse to enter data with the keyboard, it will inevitably error. This tells you about the Excel 2007 advanced editing options, and you can use some keys on your keyboard as keys for moving cells.