List of Shortcut Keys in Excel

Frequently used:
  1. Ctrl + X          Cut
  2. Ctrl + C          Copy
  3. Ctrl + V          Paste
  4. Ctrl + A          Select all contents of a sheet
  5. Ctrl + S          Save workbook
  6. Ctrl + Z          Undo last action
  7. Ctrl + F          Find (Multiple)
  8. Ctrl + G          Goto (Multiple)
  9. Ctrl + H          Replace (Multiple)
  10. Ctrl + B          Bold
  11. Ctrl + N          New workbook
  12. Ctrl + O          Open workbook
  13. Ctrl + I           Italic
  14. Ctrl + U           Underline
  15. Ctrl + W          Close workbook
  16. Ctrl + Home     Go to cell A1(When no object is selected)
  17. Ctrl + End        Go to the last used cell (When no object is selected)
  18. Ctrl + Pg Dn     Next Sheet
  19. Ctrl + Pg Up     Previous Sheet
  20. Ctrl + ~ (Toggle) Show/Hide Formula
  21. Tab/Enter             Move to next cell right/down
  22. Ctrl + +               Add (Multiple)
  23. Ctrl + -                Delete (Multiple)
  24. Ctrl + Shift + *     Select an island of cells
  25. Shift + spacebar    Select row
  26. Ctrl + spacebar *  Select column (Caution: Language selector in windows)
  27. F7                         Spell check
  28. Ctrl + ;                  Display date

Rarely used:

  1. Ctrl + K           Hyperlink
  2. Ctrl + L            Create list
  3. Ctrl + P            Print sheet/workbook (Multiple)
  4. Ctrl + D           Copy cells down
  5. Ctrl + R            Copy cells up
  6. Ctrl + Insert       Copy
  7. Shift + Insert       Paste
  8. Shift + Del          Cut
  9. Shift + Tab         Move one cell left
  10. Shift + Enter       Move one cell up
  11. Shift + F2          Edit the comment of the selected cell
  12. Ctrl + Shift + 7   Border selected area
  13. Ctrl + 2              Bold
  14. Ctrl + 3              Italic
  15. Ctrl + 4               Underline
  16. F1                       Help
  17. F2                       Edit cell contents
  18. F4                       Repeat last action
  19. Ctrl + [                Mark all cells related to the formula in the selected cell
  20. Ctrl + ]                Mark all cells which uses the selected cell in the formula
  21. Alt, Ctrl + Tab (repeat)      Select the first icon in the visible toolbars
  22. Ctrl + Shift + F          Change font name
  23. Ctrl + Shift + P          Change font size
  24. Ctrl + F1 (Toggle)      Show/Hide Task Pane
  25. Alt + F8                     Macro window
  26. Alt + F11                   VBA Editor
  27. Ctrl + Shift + <           Fill Down
  28. Ctrl + Shift + >           Fill Right
  29. F5                              Goto (Multiple)
  30. F8                              Cell selection start
  31. F11                            Insert Chart sheet
  32. F12                            Save As

No comments:

Post a Comment