Thursday 23 August 2012

Keys For Navigating in a Worksheet

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

No comments:

Post a Comment