Microsoft Excel Basic Shortcut Keys

The number and variety of keyboard shortcuts you can use to speed up your work and generally make things more convenient.


General Program Shortcuts 

  • 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
  • Alt + Q ----------------------------> Go to the “Tell me what you want to do” box
  • F7 -----------------------------------> Check spelling
  • F9 -----------------------------------> Calculate all worksheets in all open workbooks
  • Shift + F9 -------------------------> Calculate active worksheets
  • Alt or F10 -------------------------> Turn key tips on or off
  • 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 bar chart based on selected data (on a separate sheet)
  • Alt + F1 ----------------------------> Create an embedded bar 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


Moving & Selecting Cells in a Worksheet or Cell

  • Left/Right Arrow --------------> Move one cell to the left or right
  • Ctrl + Left/Right Arrow -----> Move to the farthest cell left or right in the row
  • Up/Down Arrow ---------------> Move one cell up or down
  • Ctrl + Up/Down Arrow ----- > Move to the top or bottom cell in the column
  • Tab----------------------------------> Go to the next cell
  • Shift + Tab -----------------------> Go to the previous cell
  • Ctrl + End ------------------------> Go to the most bottom right used cell
  • F5 -----------------------------------> Go to any cell by pressing F5 and typing cell name.
  • Home ------------------------------> Go to the leftmost cell in the current row (or go to the beginning of      the cell if editing a cell)
  • Ctrl + Home ---------------------> Move to the beginning of a worksheet
  • Page Up/Down ------------------> Move one screen up or down in a worksheet
  • Alt + Page Up/Down ----------> Move one screen to the right or left in a worksheet
  • Ctrl + Page Up/Down ---------> Move to the previous or next worksheet
  • Shift + Left/Right Arrow-----> Extend the cell selection to the left or right
  • Shift + Space --------------------> Select the entire row
  • Ctrl + Space ---------------------> Select the entire column
  • Ctrl + Shift + Space ----------->Select the entire worksheet

Editing & Formatting Cells

  • F2 ------------------------------------> Edit a cell
  • Shift+F2 ---------------------------> Add or edit a cell comment
  • Ctrl + X ----------------------------> Cut contents of a cell, selected data, or selected cell range
  • Ctrl + C or Ctrl + Insert ------> Copy contents of a cell, selected data, or selected cell range
  • Ctrl + V or Shift + Insert------> Paste contents of a cell, selected data, or selected cell range
  • Ctrl + Alt + V---------------------> Open the Paste Special dialog box
  • Delete--------------------------------> Remove the contents of a cell, selected data, or selected cell range
  • Alt + Enter-------------------------> Insert a hard return within a cell (while editing a cell)
  • F3-------------------------------------> Paste a cell name (if cells are named in the worksheet)
  • Alt + H + D + C-------------------> Delete column
  • Esc -----------------------------------> Cancel an entry in a cell or the formula bar
  • Enter --------------------------------> Complete an entry in a cell or the formula bar
  • Ctrl + B -----------------------------> Add or remove bold to the contents of a cell, selected data, or selected cell range
  • Ctrl + I -----------------------------> Add or remove italics to the contents of a cell, selected data, or selected cell range
  • Ctrl + U ---------------------------> Add or remove underline to the contents of a cell, selected data, or selected cell range
  • Alt + H + H ----------------------> Select a fill color
  • Alt + H + B ----------------------> Add a border
  • Ctrl + Shift + & ----------------> Apply outline border
  • Ctrl + Shift+_ (Underline) --> Remove outline border
  • Ctrl + 9 ---------------------------> Hide the selected rows
  • Ctrl + 0 ---------------------------> Hide the selected columns
  • Ctrl + 1----------------------------> Open the Format Cells dialog box
  • Ctrl + 5 ---------------------------> Apply or remove strikethrough
  • Ctrl + Shift+$ ------------------> Apply currency format
  • Ctrl + Shift+% ----------------> Apply percent format


The more and more you use keyboard shortcuts, the easier they are to remember. I Hope, you’ve found a few new ones that can make your life a little bit easier in Excel life. Have fun! 

Feel free to download PDF for a better view!




Post a comment

0 Comments