For most people, when it is your first time to work with Microsoft Excel, you will concentrate on just completing your task rather than learning how to work efficiently for a faster completion of your task. That can usually be said for any software application. However, when you are ready to learn about the keyboard shortcuts that are used in Microsoft Excel, this free Excel help article will provide you the most significant and beneficial Excel keyboard shortcuts that are presently available. The result, you are a better Excel consultant, you save time, and time is money. And that is one of the things we can help you to do: We help businesses use Microsoft Excel more efficiently.
Said another way, How do Businesses
Using the Excel keyboard shortcuts offers you these two benefits:
- Keeping your hands on the keyboard is more convenient. It is quicker to move your hand from keyboard to mouse, to keyboard.
- Your muscles will not be stressed out too much with less movement of your hands.
This article has categorized the Microsoft Excel keyboard shortcuts into related areas. Through this way, it will be easier for you to learn a group of keyboard shortcuts at a time, rather than learning all shortcuts at once.
Note: You have to remember that those keyboard shortcuts with a plus sign ( i.e. Ctrl + O ), means that you need to hold the first key, in this case the Ctrl key, then press the second key, which is O, while not releasing the first key.
Excel Keyboard Shortcuts: Files
This small group of Excel keyboard shortcuts is probably the most important and fundamental among the Excell shortcuts. These shortcuts can be used to open, close and save your Excel workbooks.
- Ctrl + N: This shortcut will allow you create a new Excel workbook.
- Ctrl + S: Its function is to save your Excel workbook.
- Ctrl + O: It functions by opening an existing Excel workbook.
Excel Keyboard Shortcuts: Editing
The following are the most common MS Excel keyboard shortcuts that you can use in editing your Microsoft Excel worksheet. The most favorite shortcut in 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 again and again.
- Ctrl + Y: Its function is to redo your last undo. However, it can only be used if you have 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 allow you to activate the different menus on the menu bar 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 the Help menu.
- Alt + W: Provides access to the Window menu.
- Alt + D: Provides access to the Data menu.
- Alt + T: Provides access to the Tools menu.
- Alt + I: Provides access to the Insert menu.
- Alt + V: Provides access to the View menu.
- Alt + E: Provides access to the edit menu.
- Alt + F: Provides access to the File menu.
After utilizing these keyboard shortcuts, you can use the arrow keys to select from the menu options and press the enter key to select a choice.
Excel Keyboard Shortcuts: Selecting
These shortcuts are very helpful for a quick selection of items in your Excel workbook in different ways.
- Ctrl + Spacebar: This shortcut allows you to select the current column.
- Shift + Spacebar: Its function is to select the current 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, or read more of our free Excel help articles written for Excel consultants and business users alike.