BUY EXCEL BOOKS ONLINE: 1. VBA & Macros      2. VBA for Modelers      3. Excel 2013 VBA and Macros     
4. Excel VBA for Dummies      5. Excel with VBA & .NET      6. Mastering VBA      7. Excel 2013 Programming

10 ways to Move in a worksheet in Excel 2007


To move around in a worksheet, you can use the arrow, Tab, Page Up, Page Down and Enter Keys. Look down, to see how these keys can be used to move around in a worksheet.

1. The Right Arrow Key
Press the right arrow key several times and notice that right adjacent cell to current active cell will get active.

2. The Down Arrow Key
Press the down arrow key several times and notice that bottom adjacent cell to current active cell will get active.

3. The Left Arrow Key
Press the left arrow key several times and notice that left adjacent cell to current active cell will get active.

4. The Up Arrow Key
Press the up arrow key several times and notice that top adjacent cell to current active cell will get active.

5. The Tab Key
Press the Tab key several times and notice that right adjacent cell to current active cell will get active. The difference between tab and right arrow key is that when you are modifying a cell content, tab will still function in the same way as mentioned but Right arrow key will traverse through character by character in the cell.
Example: 1. Change the value of cell A1 to "Hello Excel".
2. Select cell A1 and press F2. Now try left and right arrow keys.
3. Now Press Tab.

I hope the difference must be cleared now.

6. The Shift-Tab Key Combination
Press the Shift-Tab key several times and notice that left adjacent cell to current active cell will get active.

7. The Page Down Key
Press the Page Down key several times and notice that cursor or selected cell moves down by one page.

8. The Page Up Key
Press the Page Up key several times and notice that cursor or selected cell moves up by one page.

9. The Ctrl+Home Key Combination
Press the Ctrl+Home key from any selected cell and cursor will move to cell A1 always.

10. The Ctrl+End Key Combination
Press the Ctrl+End Key Combination and notice that cursor or selected cell moves to the last cell (last column and last row of used range).