Keyboard shortcuts are really important as they can really make your life easier. In this post, we will look at the important shortcuts that can increase your productivity and efficiency while using excel software. Microsoft Excel is most commonly used software in the industry. I think Microsoft Excel is the most flexible software in the market. It is not required to remember all Microsoft Excel shortcuts and it is very difficult to remember all of them. Most commonly used excel shortcuts keyboard are discussed below. Now, let’s look at the shortcuts used in Microsoft Excel.
Shortcut | Function |
F1 | Help |
F2 | Edit |
F3 | Paste Name |
F4 | Repeat Last Action |
F5 | Go To |
F6 | Next Pane |
F7 | Spell Check |
F9 | Recalculate All Workbooks |
F10 | Activate Menu bar |
F11 | New Chart |
F12 | Save As |
Ctrl + A | Select All |
Ctrl + B | Bold |
Ctrl + C | Copy |
Ctrl + D | Fill Down |
Ctrl + F | Find |
Ctrl + G | Go to |
Ctrl + H | Replace |
Ctrl + I | Italic |
Ctrl + K | Insert Hyperlink |
Ctrl + ; | Insert current date |
Ctrl + Shift + : | Insert current time |
Ctrl + ‘ | Copy Formula from Cell above |
Ctrl + Shift + “ | Copy value from cell above |
Ctrl + Shift + ~ | General format |
Ctrl + Shift + ! | Comma Format |
Ctrl + Shift + @ | Time Format |
Ctrl + Shift + # | Date Format |
Ctrl + Shift + $ | Currency Format |
Ctrl + Shift + % | Percentage format |
Ctrl + Shift + & | Border around selected cell |
Shift + F1 | What is ths? |
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 |
Alt + = | AutoSum |
Ctrl + ‘ | Toggle value/ Formula display |
Ctrl + Shift + A | Insert Argument Names into formula |
Alt + Down arrow | Display Auto complete List |
Ctrl + F3 | Define Name |
Ctrl + F4 | Close |
Ctrl + F5 | XL, Restore Window size |
Ctrl + F6 | Next workbook window |
Ctrl + Shift + ^ | Exponential Format |
Ctrl + Shift + & | Place outline Border Around Selected cells |
Ctrl + Shift + _ | Remove Outline Border |
Ctrl + + | Insert |
Ctrl + – | Delete |
Ctrl + Shift + F3 | Create Name by using names of row and column labels |
Ctrl + Shift + F6 | Previous window |
Ctrl + Shift + F12 | |
Ctrl + Shift + F1 | New worksheet |
Microsoft Excel shortcuts discussed above will help you become master in Microsoft Excel software. If you think that we missed something, please do let us know in the comments.