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 |
Similar Posts
- How to import Spring Boot project in Eclipse/STS IDE
- IntelliJ IDEA – System.out.println shortcut
- How to customize command prompt in Windows 7?
- Customizing Swagger 2 RESTful API Documentation
- IntelliJ IDEA- Import/Open multiple project in single Window
- How to Remove php, html Extension from URL using htaccess
- How to delete duplicate rows in Excel
- Maven- No compiler is provided in this environment. Perhaps you are running on a JRE rather than a JDK?
- How to remove vertical line from editor pane in IntelliJ IDEA
- Shortcut key to evaluate expression/variable in IntelliJ IDEA