Excel Shortcuts

Regardless of if you are in still in school, starting out in the workplace, or working for yourself, everyone should know basic Excel shortcuts to make life easier!

  1. Next Worksheet
    • PC: Control + PgDn
    • MAC: Fn + Control+ Down Arrow
  2. Previous Worksheet
    • PC: Control + PgUp
    • MAC: Fn + Control + Up Arrow
  3. New Workbook
    • Control or Command-N
  4. Select All
    • Control or Command- A
  5. Bold
    • Control or Command- B
  6. Copy
    • Control or Command-C
  7. Italic
    • Control of Command-I
  8. Underline
    • Control or Command-U
  9. Paste
    • Control or Command-V
  10. Go-To
    • F5
  11. Next Pane
    • F6
  12. Spellcheck
    • F7
  13. New Chart
    • F11
  14. Insert Current Time
    • Control+:
  15. Insert Current Date
    • Control+;
  16. Calculate Active Worksheet
    • Shift + F9
  17. Calculate All Open Worksheets
    • Control + Alt + F9
  18. Display Shortcut Menu
    • Shift + F10
  19. AutoSum
    • Alt +=
  20. Insert Rows/Columns
    • Control++
  21. Delete Rows/Columns
    • Control+-
  22. Enter The Same Value Multiple Times
    • Control + Enter
  23. Copy/Fill Cell Up
    • Control +D
  24. Copy/Fill Cell Down
    • Control + R
  25. Paste Name Into Formula
    • F3
  26. Insert Function Argument
    • Control + Shift + A
  27. Hide and Unhide Rows
    • Control + 9
  28. Create Chart
    • PC: F11
    • Mac: Fn + F11
  29. Resize Window
    • Control + F8
  30. Exit
    • Alt + F4

1 Comments

  1. Great info for everyone. Thank you

Leave Your Reply