Microsoft Excel Shortcuts

  1. Home
  2. Knowledge Base
  3. Computer Basics
  4. Microsoft Excel
  5. Microsoft Excel Shortcuts
  1. Home
  2. Knowledge Base
  3. Computer Basics
  4. Microsoft Excel Shortcuts

Note: These shortcuts below, are for PC but to use them on a Mac, replace ctrl with command and alt with option.

    1. Ctrl+A: Select All
    2. Ctrl+D: Fill Down
    3. Ctrl+F: Find
    4. Ctrl+G: Go to
    5. Ctrl+H: Replace
    6. Ctrl W: Close
    7. F1: Help
    8. F4: Repeat last action
    9. F9: Recalculate all workbooks
    10. Ctrl+”: Copy Value from Cell Above
    11. Ctrl+’: Copy Formula from Cell Above
    12. Shift+F9: Calculate active worksheet
    13. Ctrl+Alt+F9: Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation
    14. Ctrl+Alt+Shift+F9: Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated
    15. Shift+F10: Display shortcut menu
    16. Ctrl+Shift+F3: Create name by using names of row and column labels
    17. Ctrl++: Insert
    18. Ctrl+-: Delete
    19. Ctrl+1: Format cells dialog box
    20. Ctrl+5: Strikethrough
    21. Ctrl+6: Show/Hide objects
    22. Ctrl+7: Show/Hide Standard toolbar
    23. Ctrl+Shift+(: Unhide rows
    24. Ctrl+Shift+): Unhide columns

Related Articles