Most probably, when it is your first time to work with Microsoft Excel, you will concentrate on just completing your task instead of learning how to do the task more effectively for a faster completion of your job. However, once you’re prepared to learn regarding the keyboard shortcuts that are used in Microsoft Excel, this article will provide you the most significant and beneficial Excel keyboard shortcuts that are presently available.
Using the Excel keyboard shortcuts offers you these two benefits:
Keeping your hands on the keyboard is more convenient. It is faster to move your hand from keyboard into the mouse to the keyboard.
Your muscles will not be stressed out too much with less movement of your hands.
This article has categorized the Excel shortcuts into connected areas. Through this way, it will be easier for you to learn a collection of keyboard shortcuts one by one, rather than learning all shortcuts at once.
Note: You have to remember that those keyboard shortcuts with a plus sign ( e.g. Ctrl + O ), means that you need to hold the Ctrl key, then press the “O”, while not releasing the Ctrl key.
Excel Keyboard Shortcuts: Files
This small collection of keyboard shortcuts is probably the most important and basic among the Excel shortcuts. These shortcuts can be used to open, close and save the Excel workbooks.
- Ctrl + N: This shortcut will allow you create a new Excel workbook.
- Ctrl + S: Its function is to save the Excel workbook.
- Ctrl + O: It functions by opening an Excel workbook that exists.
Excel Keyboard Shortcuts: Editing
The following are the most common Excel keyboard shortcuts that you can use in editing the Excel workbook. The most preferred shortcut within this group is probably the Ctrl + Z.
- Ctrl + Z: This shortcut will allow you to undo the last change that you have made in your workbook. It can be used repeatedly to remove the changes many times.
- Ctrl + Y: Its function is to redo the last undo. However, it can only be used if you’ve just utilized the Undo command.
- Ctrl + C: It allows you to copy a selected item of range of items in your Workbook. Then after copying, you can paste it by using the paste keyboard shortcut.
- Ctrl + V: Its function is paste the item or range of items that you have selected in your workbook.
- Ctrl + X: It cuts your selected item or range of items in your workbook then you can place it in any region of your workbook by using the paste keyboard shortcut. Cut and copy are different from each other. Cut functions by deleting your selected item or range of items, while copy does not.
- Delete: It deletes your selected item or range of items. You can utilize this keyboard shortcut when you want to delete more than one cell at once.
- Backspace: This can be used if you want to edit an item in a cell. However, it can only be used in deleting an item, not a range of items.
Excel Keyboard Shortcuts: Menu
These keyboard shortcuts enable you to activate the different menus on menu bar even without using the mouse. But you have to note that the combination key of these keyboard shortcuts is the Alt key.
- Alt + H: Provides access to Help menu.
- Alt + W: Provides access to Window menu.
- Alt + D: Provides access to Data menu.
- Alt + T: Provides access to Tools menu.
- Alt + I: Provides access to Insert menu.
- Alt + V: Provides access to View menu.
- Alt + E: Provides access to Edit menu.
- Alt + F: Provides access to File menu.
After utilizing these keyboard shortcuts, you could utilize arrow keys to select from the menu options and press “Enter” to choose an option.
Excel Keyboard Shortcuts: Selecting
This collection of shortcuts is very helpful for a quick selection of items within the Excel workbook in different ways.
Ctrl + Spacebar: This shortcut allows you to select the existing column.
Shift + Spacebar: Its function is to select the existing row.
Ctrl + A: It is known as the “Select All” keyboard shortcut. It allows you to select all the items in your worksheet.
These are just some of the keyboard shortcuts available in Microsoft Excel. You can go for further reading to learn more about them.