MS Excel Hot Keys

Expert users have discovered keyboard shortcuts. You will get more efficient than using mouse. This lists the important shortcut keys available in Excel. The shortcuts are arranged by context.

  27 Hot Keys                       

1. Arrow keys: Moves left, right, up, or down one cell
2. Home: Moves to the beginning of the row
3. Home*: Moves to the upper-left cell displayed in the window
4. End*: Moves to the lower-left cell displayed in the window
5. Arrow keys*: Scrolls left, right, up, or down one cell
6. PgUp: Moves up one screen
7. PgDn: Moves down one screen
8. Ctrl+PgUp: Moves to the previous sheet
9. Ctrl+PgDn: Moves to the next sheet
10. Alt+PgUp: Moves one screen to the left
11. Alt+PgDn: Moves one screen to the right
12. Ctrl+Home: Moves to the first cell in the worksheet (A1)
13. Ctrl+End: Moves to the last nonempty cell of the worksheet
14. Ctrl+arrow: key Moves to the edge of a data block; if the cell is blank, moves to the first nonblank cell
15. Ctrl+Backspace: Scrolls to display the active cell
16. End, followed by Home: Moves to the last nonempty cell on the worksheet
17. F5: Prompts for a cell address to go to
18. F6: Moves to the next pane of a window that has been split
19. Shift+F6: Moves to the previous pane of a window that has been split
20. Ctrl+Tab: Moves to the next window
21. Ctrl+Shift+Tab: Moves to the previous window
22. Ctrl+F6: Moves to the next window
23. Ctrl+Shift+F6: Moves to the previous window
24. Shift+arrow key: Expands the selection in the direction indicated
25. Shift+spacebar: Selects the entire row(s) in the selected range
26. Ctrl+spacebar :Selects the entire column(s) in the selected range
27. Ctrl+Shift+ spacebar: Selects the entire worksheet.
Continue..................