December 4, 2020

Keyboard Shortcut Keys in Excel

General keyboard Shortcuts to manipulate workbooks and other interface-related operations

  • Ctrl+F1 : Show or hide the ribbon
  • Ctrl+Shift+U : Expand or collapse the formula bar
  • Ctrl+F9 : Minimize the workbook window
  • F11 : Create a column chart based on selected data (on a separate sheet)
  • Alt+F1 : Create an embedded column chart based on select data (same sheet)
  • Ctrl+F : Search in a spreadsheet, or use Find and Replace
  • Alt+F : Open the File tab menu
  • Alt+H : Go to the Home tab
  • Alt+N : Open the Insert tab
  • Alt+P : Go to the Page Layout tab
  • Alt+M : Go to the Formulas tab
  • Alt+A : Go to the Data tab
  • Alt+R : Go to the Review tab
  • Alt+W : Go to the View tab
  • Alt+X : Go to the Add-ins tab
  • Alt+Y : Go to the Help tab
  • Ctrl+Tab : Switch between open workbooks
  • Shift+F3 : Insert a function
  • Alt+F8 : Create, run, edit, or delete a macro
  • Alt+F11 : Open the Microsoft Visual Basic For Applications Editor
  • Ctrl+N : Create a new workbook
  • Ctrl+O : Open an existing workbook
  • Ctrl+S : Save a workbook
  • F12 : Open the Save As dialog box
  • Ctrl+W : Close a workbook
  • Ctrl+F4 : Close Excel
  • Shift+F11 : Insert a new worksheet
  • Ctrl+Z : Undo an action
  • Ctrl+Y : Redo an action
  • Ctrl+F2 : Switch to Print Preview
  • F1 : Open the Help pane
  • F7 : Check spelling
  • Alt+Q : Go to the “Tell me what you want to do” box

Keyboard shortcuts to navigate around in a Worksheet or Cell

Keyboard shortcuts for cell selection

  • Ctrl+Space : Select the entire column
  • Ctrl+Shift+Space : Select the entire worksheet
  • Shift+Left/Right Arrow : Extend the cell selection to the left or right
  • Shift+Space : Select the entire row

Keyboard shortcuts to edit cell

Keyboard Shortcuts to Format Cell

Leave a Reply

Your email address will not be published. Required fields are marked *