Here are 20 useful Microsoft Excel keyboard shortcut keys to speed up your work. Regardless of which Microsoft Excel version you have, these shortcut keys work flawlessly in any of them.
Basically, you’ll be looking at general keyboard shortcut keys in Excel for manipulating a workbook. How to open, save, close, switch between open workbooks and some other functions.
See also how to copy a list of file names and paste as text in Excel.
20 useful Excel keyboard shortcut keys
| Key | Function |
| Ctrl+Tab | Switch between an open workbook |
| Ctrl+0 | Hides the current column |
| Ctrl+9 | Hides the current row |
| Ctrl+F6 | Switches between open workbooks |
| Ctrl+N | Create new workbook |
| Ctrl+O | Open an existing workbook |
| Ctrl+S | Save a workbook |
| F12 | Open the Save as dialog book |
| Shift+F11 | Insert a new worksheet |
| Ctrl+Z | Undo an action |
| Ctrl+Y | Redo an action |
| Ctrl+F | Search in a spreadsheet, or use Find and Replace |
| Ctrl+F1 | Show or hide the ribbon |
| Ctrl+F4 | Close Excel |
| F2 | Edit currently selected cell |
| Shift+F2 | Add or edit a cell comment |
| Ctrl+C | Copy the content of a cell |
| Ctrl+X | Cut the content of a cell |
| Ctrl+V | Paste the content of a cell |
| Delete | Remove the content of a cell |
Do you have to remember all these shortcut keys? Not necessarily, if you seldom use it, you’ll forget. However, the more you use them, then they will be easier to remember.
If you need a full list of Microsoft Excel keyboard shortcut keys, you can access Help section by pressing F1. You can search for “keyboard shortcut” or any topic you’d like to learn.