Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Keyboard Shortcuts for Microsoft Excel



      General

      Ctrl + O Open existing file
      Ctrl + N Create new workbook
      Ctrl + S Save current workbook
      Ctrl + F4 Close current workbook
      Ctrl + Z Undo last action
      Ctrl + Y Redo last action
      Ctrl + C Copy selection
      Ctrl + X Cut selection
      Ctrl + V Paste selction
      Ctrl + P Print (displays print menu and options)
      Ctrl + S Save file
      F12 Save file as
      Entering Data

      Enter Complete cell data entry and move to cell below.
      Ctrl + Shift + Enter Enter/create array formula
      Alt + Enter Start new line in the same cell.
      Ctrl + Enter Fill selected cell range with current entry.
      Shift + Enter Complete cell data entry and move to cell directly above current cell.
      Tab Complete cell data entry and move to the cell to the right.
      Shift + Tab Complete cell data entry and move to the cell to the left.
      Esc Cancel a cell entry and go back to what was there before.
      Arrow Keys Move one cell left, right, up, or down.
      Home Move to the first column (A).
      F4 / Ctrl + Y Repeat last action.
      Ctrl + Shift + F3 Create names for row and column labels.
      Ctrl + D Fill down.
      Ctrl + R Fill to the right.
      Ctrl + F3 Define a name for a cell or range of cells.
      Ctrl + K Insert a hyperlink.
      Enter (after insertion of hyperlink) Activate a hyperlink.
      Ctrl + ; Enter the current date.
      Ctrl + Shift + : Enter the current time.
      Alt + Down Arrow Display a drop-down list of the values in the current column of a list.
      Ctrl + Z Undo the last action.
      Alt + F8 Displays macro dialog box.
      Alt + F11 Displays the visual basic editor.
      Ctrl + F11 Inserts an Excel 4.0 macro sheet.
      Edit Data

      F2 Edit highlighted cell - cursor is at the end of cell contents.
      Alt + Enter Start a new line in the same cell.
      Backspace When cell is highlighted, deletes cells contents.
      Delete Deletes cells contents if cell is highlighted.
      Ctrl + Delete Deletes text to the end of the line.
      F7 Runs spell-check.
      Shift + F2 Inserts and edits comments.
      Enter Completes cell entry and moves to cell below.
      Ctrl + Z Undo last action.
      Esc Cancel a cell entry, previous contents are restored.
      Ctrl + Shift + Z When the autocorrect smart tags is displayed, undo or redo the last automatic correction.
      Ctrl + C + Ctrl + C Displays the clipboard (where copied items are).
      Ctrl + - Removes/deletes selected cells from the sheet.
      Ctrl + Shift + "+" Inserts blank cells.
      Format Data

      Alt + ' Display style dialog box.
      Ctrl + 1 Display format cells dialog box.
      Shift + Spacebar Highlight row
      Ctrl + Spacebar Highlight column
      Ctrl + Shift + ~ Apply the 'general number' format to selected cells.
      Ctrl + Shift + $ Apply the 'currency number' format with two decimal places and negative numbers showing in parentheses to selected cells.
      Ctrl + Shift + % Apply the 'percentage' format with no decimal places to selected cells.
      Ctrl + Shift + ^ Apply the 'exponential number' format with two decimal places to selected cells.
      Ctrl + Shift + # Apply the 'date' format with the day, month, and year to selected cells.
      Ctrl + Shift + @ Apply the 'time' format with the hour, minute, and AM or PM to selected cells.
      Ctrl + Shift +! Apply the 'number' format with two decimal places, thousands seperator, and minus sign for negative numbers to selected cells.
      Ctrl + B Apply/remove bold format to selected cells.
      Ctrl + I Apply/remove italic format to selected cells.
      Ctrl + U Apply/remove underline to selected cells.
      Ctrl + 5 Apply or remove 'strikethrough' to selected cells.
      Ctrl + 8 Displays or hides the outline of symbols.
      Ctrl + 9 Hide row.
      Ctrl + Shift + 9 Unhide row.
      Ctrl + Shift + ( Unhide any hidden rows within the selection.
      Ctrl + 0 Hide the selected columns.
      Ctrl + Shift + ) Unhide any columns within the selection.
      Ctrl + Shift + & Apply the 'border outline' to selcted cells.
      Ctrl + Shift + _ Remove the 'border outline' from selected cells.
      Alt + Shift + Right Arrow Groups selected rows or columns.
      Alt + Shift + Left Arrow Ungroups selected rows or columns.
      Macros

      Alt + F8 Displays macro dialog box.
      Alt + F11 Displays the visual basic editor.
      Ctrl + F11 Inserts an Excel 4.0 macro sheet.
Click above to see Keyboard Shortcuts for Microsoft Excel