This post is simple to help you master your MS Excel shortcuts. If you want to get the most out of your MS Excel, you need to know the shortcuts. The MS Excel Shortcut Keys post is an indispensable guide to shortcuts and keyboard shortcuts in MS Excel. It will show you how to use keyboard shortcuts to speed up your day-to-day work and give you more time to spend with your family and friends.
Excel is a powerful and popular spreadsheet software, but it can be tricky to find your way around all the shortcuts that are available to you. This article provides an overview of the most common shortcuts in Excel, with easy-to-follow instructions on how to access them and use them.
If you have a specific goal in mind, try to find a shortcut that accomplishes that goal. There are so many shortcuts in Excel that I don’t even know where to start! This is a list of shortcuts for Microsoft Excel 2007, 2010, 2013 and 2016.
We have made a list of shortcut keys of MS Excel.
| Shortcut keys | Action |
| Ctrl + A | Select all |
| Ctrl + B | Bold selection |
| Ctrl + C | Copy selected content |
| Ctrl + D | Fill Down |
| Ctrl + F | Find content |
| Ctrl + G | Go to |
| Ctrl + H | Replace content |
| Ctrl + I | Italic selection |
| Ctrl + K | Insert hyperlink |
| Ctrl + N | New worksheet |
| Ctrl + O | Open a workbook |
| Ctrl + P | Print a workbook |
| Ctrl + R | Fill right |
| Ctrl + S | Save a workbook |
| Ctrl + T | Create table |
| Ctrl + U | Underline selection |
| Ctrl + V | Paste selection |
| Ctrl + W | Close a workbook |
| Ctrl + X | Cut selection |
| Ctrl + Y | Redo last action |
| Ctrl + Z | Undo last action |
| Shortcut keys | Action |
| F1 | Help |
| F2 | Edit |
| F3 | Paste Name dialog box |
| F4 | Repeat the last action if possible |
| F5 | Go to |
| F6 | Task pane |
| F7 | Spell check |
| F8 | Extended Selection mode |
| F9 | Recalculates all worksheets |
| F10 | Turns key tips on or off |
| F11 | Create a new chart |
| F12 | Save as a workbook |
| Shortcut keys | Action |
| Ctrl + F1 | Hide and show the ribbon |
| Ctrl + F2 | Display to print preview aria |
| Ctrl + F3 | Define name, Name manager |
| Ctrl + F4 | Close the workbook |
| Ctrl + F5 | Restore down workbook |
| Ctrl + F6 | Switch between two excel windows |
| Ctrl + F7 | Move window |
| Ctrl + F8 | Resize window |
| Ctrl + F9 | Minimize a workbook |
| Ctrl + F10 | Maximize & restore a workbook |
| Ctrl + F11 | Add a micro sheet |
| Ctrl + F12 | Open a file open dialog box |
| Shortcut keys | Action |
| Ctrl+1 | Format cell dialog box |
| Ctrl+2 | Bold the selected cell |
| Ctrl+3 | Italic the selected cell |
| Ctrl+4 | Underline the selected cell |
| Ctrl+5 | Strikethrough formatting |
| Ctrl+6 | Show or hide objects |
| Ctrl+7 | Show or hide Standard toolbar |
| Ctrl+8 | Display or hide the outline symbols |
| Ctrl+9 | Hide the selected rows |
| Ctrl+0 | Hide the selected columns |
More shortcut keys will be updated