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