Keys for moving and scrolling in a worksheet or workbook:
- 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 window
- 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)
- TAB: Move between unlocked cells on a protected worksheet
0 Responses to “A list of Microsoft Excel shortcut keys”