Excel Keyboard Shortcuts

  1. Strikethrough
    Ctrl + 5
  2. Close a Workbook
    Ctrl + w
  3. Bold Formatting
    • Ctrl + 2
    • Ctrl + B
  4. Help
    F1
  5. Display or Hide Ribbon
    Ctrl + F1
  6. Embed chart of Data in Current Range
    Alt + F1
  7. Insert new Worksheet
    Alt + Shift + F1
  8. Open Save As Box
    F12
  9. Hide Row
    Ctrl + 9
  10. Hide Column
    Ctrl + 0
  11. Open Dialog Box
    Ctrl + O
  12. Selects all cells with Comments
    Ctrl + Shift + O
  13. Select entire worksheet or Data if exists.
    Select current Region and its summary rows.
    Selects entire worksheet.
    • Ctrl + A
    • Ctrl + A 2nd time
    • Ctrl + A 3rd time
  14. In a function Displays arguments.
                       Inserts arguments
    • Ctrl + A
    • Ctrl + Shift + A
  15. Group Cells
    Shift + Alt + Right Arrow
  16. UnGroup Cells
    Shite + Alt + Left Arrow
  17. Copy
    2nd time Copy to Clipboard
    Ctrl + C
  18. Display Find with Find Tab Selected
    • Ctrl + F
    • Shift F5
  19. Repeats Last Find
    Shift + F4
  20. Open Format Cells with Font Tab Selected
    Ctrl + Shift + F
  21. Insert Row or Column
    Ctrl + Shift + =
  22. Uses Fill Down (top cell's content and format into rest of range below selected)
    Ctrl + D
  23. Uses Fill Right (left cell's content and format into rest of range to the right selected)
    Ctrl + R
Author
pfarnswo
ID
336804
Card Set
Excel Keyboard Shortcuts
Description
Keyboard shortcuts for MS Excel Menu items
Updated