| Shortcut
  key | Action | 
Menu equivalent
  comments | 
  | Ctrl+A | Select
  All | None | 
  | Ctrl+B | Bold | Format,
  Cells, Font, Font Style, Bold | 
  | Ctrl+C | Copy | Edit,
  Copy | 
  | Ctrl+D | Fill
  Down | Edit,
  Fill, Down | 
  | Ctrl+F | Find | Edit,
  Find | 
  | Ctrl+G | Goto | Edit,
  Goto | 
  | Ctrl+H | Replace | Edit,
  Replace | 
  | Ctrl+I | Italic | Format,
  Cells, Font, Font Style, Italic | 
  | Ctrl+K | Insert
  Hyperlink | Insert,
  Hyperlink | 
  | Ctrl+N | New
  Workbook | File,
  New | 
  | Ctrl+O | Open | File,
  Open | 
  | Ctrl+P | Print | File,
  Print | 
  | Ctrl+R | Fill
  Right | Edit,
  Fill Right | 
  | Ctrl+S | Save | File,
  Save | 
  | Ctrl+U | Underline | Format,
  Cells, Font, Underline, Single | 
  | Ctrl+V | Paste | Edit,
  Paste | 
  | Ctrl W | Close | File,
  Close | 
  | Ctrl+X | Cut | Edit,
  Cut | 
  | Ctrl+Y | Repeat | Edit,
  Repeat | 
  | Ctrl+Z | Undo | Edit,
  Undo | 
  | F1 | Help | Help,
  Contents and Index | 
  | F2 | Edit | None | 
  | F3 | Paste
  Name | Insert,
  Name, Paste | 
  | F4 | Repeat
  last action | Edit,
  Repeat. Works while not in Edit mode. | 
  | F4 | While
  typing a formula, switch between absolute/relative refs | None | 
  | F5 | Goto | Edit,
  Goto | 
  | F6 | Next
  Pane | None | 
  | F7 | Spell
  check | Tools,
  Spelling | 
  | F8 | Extend
  mode | None | 
  | F9 | Recalculate
  all workbooks | Tools,
  Options, Calculation, Calc Now | 
  | F10 | Activate
  Menubar | N/A | 
  | F11 | New
  Chart | Insert,
  Chart | 
  | F12 | Save
  As | File,
  Save As | 
  | Shift + Ctrl+: | Insert
  Current Time | None | 
  | Ctrl+; | Insert
  Current Date | None | 
  | Ctrl+" | Copy
  Value from Cell Above | Edit,
  Paste Special, Value | 
  | Ctrl+’ | Copy
  Formula from Cell Above | Edit,
  Copy | 
  | Shift | Hold
  down shift for additional functions in Excel’s menu | none | 
  | Shift+F1 | What’s
  This? | Help,
  What’s This? | 
  | Shift+F2 | Edit
  cell comment | Insert,
  Edit Comments | 
  | Shift+F3 | Paste
  function into formula | Insert,
  Function | 
  | Shift+F4 | Find
  Next | Edit,
  Find, Find Next | 
  | Shift+F5 | Find | Edit,
  Find, Find Next | 
  | Shift+F6 | Previous
  Pane | None | 
  | Shift+F8 | Add
  to selection | None | 
  | Shift+F9 | Calculate
  active worksheet | Tools,
  Options, Calculation, Calc Sheet | 
  | Ctrl+Alt+F9 | Calculate
  all worksheets in all open workbooks, regardless of whether they have changed
  since the last calculation. | None | 
  | Ctrl+Alt+Shift+F9 | Rechecks
  dependent formulas and then calculates all cells in all open workbooks,
  including cells not marked as needing to be calculated. | None | 
  | Shift+F10 | Display
  shortcut menu | None | 
  | Shift+F11 | New
  worksheet | Insert,
  Worksheet | 
  | Shift+F12 | Save | File,
  Save | 
  | Ctrl+F3 | Define
  name | Insert,
  Names, Define | 
  | Ctrl+F4 | Close | File,
  Close | 
  | Ctrl+F5 | XL,
  Restore window size | Restore | 
  | Ctrl+F6 | Next
  workbook window | Window,
  ... | 
  | Shift+Ctrl+F6 | Previous
  workbook window | Window,
  ... | 
  | Ctrl+F7 | Move
  window | XL,
  Move | 
  | Ctrl+F8 | Resize
  window | XL,
  Size | 
  | Ctrl+F9 | Minimize
  workbook | XL,
  Minimize | 
  | Ctrl+F10 | Maximize
  or restore window | XL,
  Maximize | 
  | Ctrl+F11 | Inset
  4.0 Macro sheet | None
  in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro | 
  | Ctrl+F12 | File
  Open | File,
  Open | 
  | Alt+F1 | Insert
  Chart | Insert,
  Chart... | 
  | Alt+F2 | Save
  As | File,
  Save As | 
  | Alt+F4 | Exit | File,
  Exit | 
  | Alt+F8 | Macro
  dialog box | Tools,
  Macro, Macros in Excel 97 Tools,Macros - in earlier versions | 
  | Alt+F11 | Visual
  Basic Editor | Tools,
  Macro, Visual Basic Editor | 
  | Ctrl+Shift+F3 | Create
  name by using names of row and column labels | Insert,
  Name, Create | 
  | Ctrl+Shift+F6 | Previous
  Window | Window,
  ... | 
  | Ctrl+Shift+F12 | Print | File,
  Print | 
  | Alt+Shift+F1 | New
  worksheet | Insert,
  Worksheet | 
  | Alt+Shift+F2 | Save | File,
  Save | 
  | Alt+= | AutoSum | No
  direct equivalent | 
  | Ctrl+` | Toggle
  Value/Formula display | Tools,
  Options, View, Formulas | 
  | Ctrl+Shift+A | Insert
  argument names into formula | No
  direct equivalent | 
  | Alt+Down arrow | Display
  AutoComplete list | None | 
  | Alt+’ | Format
  Style dialog box | Format,
  Style | 
  | Ctrl+Shift+~ | General
  format | Format,
  Cells, Number, Category, General | 
  | Ctrl+Shift+! | Comma
  format | Format,
  Cells, Number, Category, Number | 
  | Ctrl+Shift+@ | Time
  format | Format,
  Cells, Number, Category, Time | 
  | Ctrl+Shift+# | Date
  format | Format,
  Cells, Number, Category, Date | 
  | Ctrl+Shift+$ | Currency
  format | Format,
  Cells, Number, Category, Currency | 
  | Ctrl+Shift+% | Percent
  format | Format,
  Cells, Number, Category, Percentage | 
  | Ctrl+Shift+^ | Exponential
  format | Format,
  Cells, Number, Category, | 
  | Ctrl+Shift+& | Place
  outline border around selected cells | Format,
  Cells, Border | 
  | Ctrl+Shift+_ | Remove
  outline border | Format,
  Cells, Border | 
  | Ctrl+Shift+* | Select
  current region | Edit,
  Goto, Special, Current Region | 
  | Ctrl++ | Insert | Insert,
  (Rows, Columns, or Cells) Depends on selection | 
  | Ctrl+- | Delete | Delete,
  (Rows, Columns, or Cells) Depends on selection | 
  | Ctrl+1 | Format
  cells dialog box | Format,
  Cells | 
  | Ctrl+2 | Bold | Format,
  Cells, Font, Font Style, Bold | 
  | Ctrl+3 | Italic | Format,
  Cells, Font, Font Style, Italic | 
  | Ctrl+4 | Underline | Format,
  Cells, Font, Font Style, Underline | 
  | Ctrl+5 | Strikethrough | Format,
  Cells, Font, Effects, Strikethrough | 
  | Ctrl+6 | Show/Hide
  objects | Tools,
  Options, View, Objects, Show All/Hide | 
  | Ctrl+7 | Show/Hide
  Standard toolbar | View,
  Toolbars, Stardard | 
  | Ctrl+8 | Toggle
  Outline symbols | None | 
  | Ctrl+9 | Hide
  rows | Format,
  Row, Hide | 
  | Ctrl+0 | Hide
  columns | Format,
  Column, Hide | 
  | Ctrl+Shift+( | Unhide
  rows | Format,
  Row, Unhide | 
  | Ctrl+Shift+) | Unhide
  columns | Format,
  Column, Unhide | 
  | Alt or F10 | Activate
  the menu | None | 
  | Ctrl+Tab | In
  toolbar: next toolbar | None | 
  | Shift+Ctrl+Tab | In
  toolbar: previous toolbar | None | 
  | Ctrl+Tab | In
  a workbook: activate next workbook | None | 
  | Shift+Ctrl+Tab | In
  a workbook: activate previous workbook | None | 
  | Tab | Next
  tool | None | 
  | Shift+Tab | Previous
  tool | None | 
  | Enter | Do
  the command | None | 
  | Alt+Enter | Start
  a new line in the same cell. | None | 
  | Ctrl+Enter | Fill
  the selected cell range with the current entry. | None | 
  | Shift+Ctrl+F | Font
  Drop Down List | Format,
  Cells, Font | 
  | Shift+Ctrl+F+F | Font
  tab of Format Cell Dialog box | Format,
  Cells, Font | 
  | Shift+Ctrl+P | Point
  size Drop Down List | Format,
  Cells, Font | 
  |  |  |  | 
  |  |  |  | 
  | Shorcuts
  for the Visual Basic Editor |  |  | 
  |  |  |  | 
  | Shortcut
  key | Action | Menu equivalent
  comments | 
  | F1 | Help | Help | 
  | F2 | View
  Object Browser | View,
  Object Browser | 
  | F3 | Find
  Next |  | 
  | F4 | Properies
  Window | View,
  Properties Window | 
  | F5 | Run
  Sub/Form or Run Macro | Run,
  Run Macro | 
  | F6 | Switch
  Split Windows |  | 
  | F7 | View
  Code Window | View,
  Code | 
  | F8 | Step
  Into | Debug,
  Step Into | 
  | F9 | Toggle
  Breakpoint | Debug,
  Toggle Breakpoint | 
  | F10 | Activate
  Menu Bar |  | 
  | Shift+F2 | View
  definition | View,
  Definition | 
  | Shift+F3 | Find
  Previous |  | 
  | Shift+F7 | View
  Object | View,
  Object | 
  | Shift+F8 | Step
  Over | Debug,
  Step Over | 
  | Shift+F9 | Quick
  Watch | Debug,
  Quick Watch | 
  | Shift+F10 | Show
  Right Click Menu |  | 
  | Ctrl+F2 | Focus
  To Object Box |  | 
  | Ctrl+F4 | Close
  Window |  | 
  | Ctrl+F8 | Run
  To Cursor | Debug,
  Run To Cursor | 
  | Ctrl+F10 | Activate
  Menu Bar |  | 
  | Alt+F4 | Close
  VBE | File,
  Close and Return to Microsoft Excel | 
  | Alt+F6 | Switch
  Between Last 2 Windows |  | 
  | Alt+F11 | Return
  To Application |  | 
  | Ctrl+Shift+F2 | Go
  to last position | View,
  Last Position | 
  | Ctrl+Shift+F8 | Step
  Out | Debug,
  Step Out | 
  | Ctrl+Shift+F9 | Clear
  All Breakpoints | Debug,
  Clear All Breakpoints | 
  | Insert | Toggle
  Insert Mode |  | 
  | Delete | Delete | Edit,
  Clear | 
  | Home | Move
  to beginning of line |  | 
  | End | Move
  to end of line |  | 
  | Page Up | Page
  Up |  | 
  | Page Down | Page
  Down |  | 
  | Left Arrow | Left |  | 
  | Right Arrow | Right |  | 
  | Up Arrow | Up |  | 
  | Down Arrow | Down |  | 
  | Tab | Indent | Edit,
  Indent | 
  | Enter | New
  Line |  | 
  | BackSpace | Delete
  Prev Char |  | 
  | Shift+Insert | Paste | Edit,
  Paste | 
  | Shift+Home | Select
  To Start Of Line |  | 
  | Shift+End | Select
  To End Of Line |  | 
  | Shift+Page Up | Select
  To Top Of Module |  | 
  | Shift+Page Down | Select
  To End Of Module |  | 
  | Shift+Left Arrow | Extend
  Selection Left 1 Char |  | 
  | Shift+Right Arrow | Extend
  Selection Right 1 Char |  | 
  | Shift+Up Arrow | Extend
  Selection Up |  | 
  | Shift+Down Arrow | Extend
  Selection Down |  | 
  | Shift+Tab | Outdent | Edit,
  Outdent | 
  | Alt+Spacebar | System
  Menu |  | 
  | Alt+Tab | Cycle
  Applications |  | 
  | Alt+BackSpace | Undo |  | 
  | Ctrl+A | Select
  All | Edit,
  Select All | 
  | Ctrl+C | Copy | Edit,
  Copy | 
  | Ctrl+E | Export
  Module | File,
  Export File | 
  | Ctrl+F | Find | Edit,
  Find… | 
  | Ctrl+G | Immediate
  Window | View,
  Immediate Window | 
  | Ctrl+H | Replace | Edit,
  Replace… | 
  | Ctrl+I | Turn
  On Quick Info | Edit,
  Quikc Info | 
  | Ctrl+J | List
  Properties/Methods | Edit,
  List Properties/Methods | 
  | Ctrl+L | Show
  Call Stack |  | 
  | Ctrl+M | Import
  File | File,
  Import File | 
  | Ctrl+N | New
  Line |  | 
  | Ctrl+P | Print | File,
  Print | 
  | Ctrl+R | Project
  Explorer | View,
  Project Explorer | 
  | Ctrl+S | Save | File,
  Save | 
  | Ctrl+T | Show
  Available Components | 
Insert,
  Components… | 
  | Ctrl+V | Paste | Edit,
  Paste | 
  | Ctrl+X | Cut | Edit,
  Cut | 
  | Ctrl+Y | Cut
  Entire Line |  | 
  | Ctrl+Z | Undo | Edit,
  Undo | 
  | Ctrl+Insert | Copy | Edit,
  Copy | 
  | Ctrl+Delete | Delete
  To End Of Word |  | 
  | Ctrl+Home | Top
  Of Module |  | 
  | Ctrl+End | End
  Of Module |  | 
  | Ctrl+Page Up | Top
  Of Current Procedure |  | 
  | Ctrl+Page Down | End
  Of Current Procedure |  | 
  | Ctrl+Left Arrow | Move
  one word to left |  | 
  | Ctrl+Right Arrow | Move
  one word to right |  | 
  | Ctrl+Up Arrow | Previous
  Procedure |  | 
  | Ctrl+Down Arrow | Next
  Procedure |  | 
  | Ctrl+Spacebar | Complete
  Word | Edit,
  Complete Word | 
  | Ctrl+Tab | Cycle
  Windows |  | 
  | Ctrl+BackSpace | Delete
  To Start Of Word |  | 
  | Ctrl+Shift+I | Parameter
  Info | Edit,
  Parameter Info | 
  | Ctrl+Shift+J | List
  Constants | Edit,
  List Constants |