Microsoft Excel Shortcut Keys

ShortcutAction
Ctrl+Shift+F6Ctrl Shift F6Previous Window
Ctrl+Shift+F12Ctrl Shift F12Print
Alt+Shift+F1Alt Shift F1New worksheet
Alt+Shift+F2Alt Shift F2Save

What are the BEST EXCEL shortcuts?

Cut: Ctrl+X

  • Copy: Ctrl+C
  • Paste: Ctrl+V
  • Open a Workbook: Ctrl+O
  • Close a Workbook: Ctrl+W
  • Save a Workbook: Ctrl+S
  • Undo: Ctrl+Z
  • Navigate between cells and menu options: Arrow Keys
  • Expand/Collapse Ribbon: Ctrl+F1
  • Move to the beginning of the worksheet: Ctrl+Home

    • How do you make keyboard shortcuts in Excel?

    Create a keyboard shortcut in Excel or Word for Mac On the Tools menu, click Customize Keyboard. In the Categories list, click a tab name. In the Commands list, click the command that you want to assign a keyboard shortcut to. Any keyboard shortcuts that are currently assigned to the selected command will appear in the Current keys box.

    Where is the keyboard shortcut in Excel?

    If you press “Alt” followed by “=” (at the same time) on your keyboard, you will find you have a shortcut which inserts Excel’s sum function. If you press “Shift” and “F3” you have a keyboard shortcut which brings up Excel’s insert function wizard (it’s the same as clicking on “fx” on your formula bar).

    What is the keyboard shortcut for Excel?

    Under Shortcut key, enter a keyboard shortcut. For example, type Shift + H (this would assign Control + Shift + H as the shortcut). By adding Shift, you are less likely to create the same shortcut as a built-in Excel shortcut. Under Store macro in, choose This Workbook, New Workbook or Personal Macro Workbook.