Microsoft Excel Shortcuts

  1. Home
  2. Knowledge Base
  3. Computer Basics
  4. Microsoft Excel Shortcuts
  1. Home
  2. Knowledge Base
  3. Microsoft Excel
  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