Microsoft Excel Shortcut Keys List
On this page, we will provide you the list of Microsoft Excel shortcut key which helps you to improve the productivity and save time. These shortcut keys work perfectly for Microsoft Excel 2007 to upper version.
These keys are tested on MS Excel 2013 and work perfectly.
Keys | Discriptions |
---|---|
F1 | Help |
F2 | Edit |
F3 | Paste Name |
F4 | Repeat Last Action |
F5 | Go To |
F6 | Next Pane |
F7 | Spell Check |
F8 | Extend Mode |
F9 | Recalculate All Workbooks |
F10 | Activate Menu Bar |
F11 | New Chart |
F12 | Save As |
Ctrl + F12 | File Open |
Alt + F1 | Insert Chart |
Alt + F2 | Save As |
Alt + F4 | Exit |
Alt + F11 | Visula Basic Editor |
Shift + Ctrl + F6 | Previous Workbook Window |
Ctrl + F7 | Move Window |
Ctrl + F8 | Resize Window |
Ctrl + F9 | Minimize Workbook |
Ctrl + F10 | Maximize Workbook or Restore Window |
Ctrl + F11 | Inset 4.0 Macro Sheet |
Ctrl + Shift + ~ | General Format |
Ctrl + Shift + ! | Comma Format |
Ctrl + Shift + @ | Time Format |
Ctrl + Shift + # | Date Format |
Ctrl + Shift + $ | Currency Format |
Ctrl + Shift + % | Persent Format |
Ctrl + : | Insert Current Time |
Ctrl + ; | Insert Current Date |
Ctrl + " | Copy Value From Cell Above |
Ctrl + ' | Copy Formula From Cell Above |
Ctrl + A | Select All |
Ctrl + B | Bold |
Ctrl + C | Copy |
Ctrl + D | Fill Down |
Ctrl + F | Find |
Ctrl + G | Goto |
Ctrl + H | Replace |
Ctrl + I | Italic |
Ctrl + K | Insert Hyperlink |
Shift + F1 | What is 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 + O | Open |
Ctrl + P | |
Ctrl + R | Full Right |
Ctrl + S | Save |
Ctrl + U | Underline |
Ctrl + V | Paste |
Ctrl + W | Close |
Ctrl + X | Cut |
Ctrl + Y | Repeat |
Ctrl + Z | Undo |
Ctrl + N | New Worksheet |
Ctrl + Shift + ^ | Exponential Format |
Ctrl + Shift + & | Place Outline Border Around Selected Cells |
Ctrl + Shift + _ | Remove Outline Border |
Ctrl + + | Insert |
Ctrl + - | Delete |
Ctrl + F3 | Define Name |
Ctrl + F4 | Close |
Ctrl + F5 | XL, Restore Window Size |
Ctrl + F6 | Next Workbook Window |
Alt + = | Auto Sum |
Ctrl + ' | Toglle Value/Formula Display |
Ctrl + Shift + A | Insert Argument Name into Formula |
Alt + Down Arrow | Dispaly Auto Complete List |
Ctrl + Shift + F3 | Create name by using names of row and column labels |
Ctrl + Shift + F6 | Previous Window |
Ctrl + Shift + F12 | |
Alt + Shift + F1 | New Worksheet |