Keys For Navigating in a Worksheet : Keyboard « Editing « Microsoft Office Excel 2007 Tutorial






Press Left arrow to move One cell to the left

Press Right arrow to move One cell to the right

Press Up arrow to move One cell up

Press Down arrow to move One cell down

Press Enter to move One cell down

Press Tab to move One cell to the right

Press Shift+Tab to move One cell to the left

Press Page Up to move One screen up

Press Page Down to move One screen down

Press End+arrow key to move in the direction of the arrow key to the next cell containing data or to the last empty cell in current row or column

Press Home to move to column A in the current row

Press Ctrl+Home to move to cell A1

Press Ctrl+End to move to the last cell in the worksheet containing data

2.17.Keyboard
2.17.1.When you press Enter, the active cell moves down one cell. To change the directionWhen you press Enter, the active cell moves down one cell. To change the direction
2.17.2.Keys For Navigating in a Worksheet