Keyboard commands for moving and scrolling in an Excel worksheet

• Arrow keys - Move one cell up, down, left, or right
• Ctrl + arrow key - Move to the edge of the current data region
• Home - Move to the beginning of the row
• Ctrl + Home - Move to the beginning of the worksheet
• Ctrl + End - Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
• Page Down - Move down one screen
• Page Up - Move up one screen
• Alt + Page Down - Move one screen to the right
• Alt + Page Up - Move one screen to the left
• Ctrl + Page Down - Move to the next sheet in the workbook
• Ctrl + Page Up - Move to the previous sheet in the workbook
• Ctrl + F6 or Ctrl + Tab - Move to the next workbook or window
• Ctrl + Shift + F6 or Ctrl + Shift + Tab- Move to the previous workbook or wind
• F6 - Move to the next pane in a workbook that has been split
• Shift + F6 - Move to the previous pane in a workbook that has been split
• Ctrl + Backspace - Scroll to display the active cell
• F5 - Display the Go to dialog box
• Shift + F5 - Display the Find dialog box
• Shift + F4 - Repeat the last Find action (same as Find Next)

Note: To enlarge the Help window to fill the screen, press Alt + Spacebar and then press X. To restore the window to its previous size and location, press Alt + Spacebar and then press R. To print this topic, press ALT+O and then press P.

Key for moving in a worksheet with end mode on
End mode is an alternate method of moving within and between adjacent blocks of vales on a worksheet.

• End - Turn End mode on or off
• End, arrow key - Move by one block of data within a row or column
• End, Home - Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
• End, Enter - Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)

Keys for moving in a worksheet with scroll lock on
With scroll lock turned on, the arrow keys scroll the active sheet rather than make a different cell active.

• Scroll Lock - Turn Scroll Lock on or off
• Home- Move to the cell in the upper-left corner of the window
• End- Move to the cell in the lower-right corner of the window
• Up Arrow or Down Arrow- Scroll one row up or down
• Left Arrow or Right Arrow - Scroll one column left or right

Note: When you use scrolling keys (such as Page Up and Page Down) with Scroll Lock turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on Scroll Lock first