Complete List of MS Excel Shortcut Key

Complete List of MS Excel Shortcut Key
      • Ctrl+A – Select All
      • Ctrl+B – Bold
      • Ctrl+D – Fill Down
      • Ctrl+C – Copy
      • Ctrl+F – Find
      • Ctrl+G – Goto
      • Ctrl+H – Replace
      • Ctrl+I – Italic
      • Ctrl+K – Insert Hyperlink


    • Ctrl+N – New Workbook
    • Ctrl+O – Open
    • Ctrl+P – Print
    • Ctrl+R – Fill Right
    • Ctrl+S – Save
    • Ctrl+U – Underline
    • Ctrl+V – Paste
    • Ctrl W – Close
    • Ctrl+X – Cut
    • Ctrl+Y – Repeat
    • Ctrl+Z – Undo
    • F1 – Help
    • F2 – Edit
    • F3 – Paste Name
    • F4 – Repeat last action
    • F4 – While typing a formula, switch between absolute/relative refs
    • F5 – Goto
    • F6 – Next Pane
    • F7 – Spell check
    • F8 – Extend mode
    • F9 – Recalculate all workbooks
    • F10 – Activate Menubar
    • F11 – New Chart
    • F12 – Save As
    • Ctrl+: – Insert Current Time
    • Ctrl+; – Insert Current Date
    • Ctrl+” – Copy Value from Cell Above
    • Ctrl+’ – Copy Formula from Cell Above
    • Shift – Hold down shift for additional functions in Excel’s menu
    • Shift+F1 – What’s This?
    • Shift+F2 – Edit cell comment
    • Shift+F3 – Paste function into formula
    • Shift+F4 – Find Next
    • Shift+F5 – Find
    • Shift+F6 – Previous Pane
    • Shift+F8 – Add to selection
    • Shift+F9 – Calculate active worksheet
    • Shift+F10 – Display shortcut menu
    • Shift+F11 – New worksheet
    • Shift+F12 – Save
    • Ctrl+F3 – Define name
    • Ctrl+F4 – Close
    • Ctrl+F5 – XL, Restore window size
    • Ctrl+F6 – Next workbook window
    • Shift+Ctrl+F6 – Previous workbook window
    • Ctrl+F7 – Move window
    • Ctrl+F8 – Resize window
    • Ctrl+F9 – Minimize workbook
    • Ctrl+F10 – Maximize or restore window
    • Ctrl+F11 – Inset 4.0 Macro sheet
    • Ctrl+F1 – File Open
    • Alt+F1 – Insert Chart
    • Alt+F2 – Save As
    • Alt+F4 – Exit
    • Alt+F8 – Macro dialog box
    • Alt+F11 – Visual Basic Editor
    • Ctrl+Shift+F3 – Create name by using names of row and column labels
    • Ctrl+Shift+F6 – Previous Window
    • Ctrl+Shift+F12 – Print
    • Alt+Shift+F1 – New worksheet
    • Alt+Shift+F2 – Save
    • Alt+= – AutoSum
    • Ctrl+` – Toggle Value/Formula display
    • Ctrl+Shift+A – Insert argument names into formula
    • Alt+Down arrow – Displayy AutoComplete list
    • Alt+’ – Format Style dialog box
    • Ctrl+Shift+~ – General format
    • Ctrl+Shift+! – Comma format
    • [email protected] – Time format
    • Ctrl+Shift+# – Date format
    • Ctrl+Shift+$ – Currency format
    • Ctrl+Shift+% – Percent format
    • Ctrl+Shift+^ – Exponential format
    • Ctrl+Shift+& – Place outline border around selected cells
    • Ctrl+Shift+_ – Remove outline border
    • Ctrl+Shift+* – Select current region
    • Ctrl++ – Insert
    • Ctrl+- – Delete
    • Ctrl+1 – Format cells dialog box
    • Ctrl+2 – Bold
    • Ctrl+3 – Italic
    • Ctrl+4 – Underline
    • Ctrl+5 – Strikethrough
    • Ctrl+6 – Show/Hide objects
    • Ctrl+7 – Show/Hide Standard toolbar
    • Ctrl+8 – Toggle Outline symbols
    • Ctrl+9 – Hide rows
    • Ctrl+0 – Hide columns
    • Ctrl+Shift+( – Unhide rows
    • Ctrl+Shift+) – Unhide columns
    • Alt or F10 – Activate the menu
    • Ctrl+Tab – In toolbar: next toolbar
    • Shift+Ctrl+Tab – In toolbar: previous toolbar
    • Ctrl+Tab – In a workbook: activate next workbook
    • Shift+Ctrl+Tab – In a workbook: activate previous workbook
    • Tab – Next tool
    • Shift+Tab – Previous tool
    • Enter – Do the command
    • Shift+Ctrl+F – Font Drop Down List
    • Shift+Ctrl+F+F – Font tab of Format Cell Dialog box
    • Shift+Ctrl+P – Point size Drop Down List