Data in Excel is in the form of rows and columns. Excel is commonly used to record and analyze data, perform mathematical operations, and visualize structured data in charts and graphs. Finally, another important application of Excel is that it helps in automating tasks.
To perform the tasks mentioned above quickly, Excel has a set of shortcuts. Various operations can be achieved with a few simple keyboard strokes. Let’s dive deep into the Excel shortcuts that can help us work better on an Excel spreadsheet.
Need for Excel Shortcuts
Excel supports a plethora of keyboard shortcuts that help you work efficiently and increase productivity. Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions. Isn’t that easier and time-saving? Using Excel shortcuts drastically increases the speed, and thus reduces work-time.
Now the question is, if you have to memorize these shortcuts, the answer is no. However, it would be an advantage if you can remember a few of them. With regular practice, you will be able to remember most of the common Excel shortcuts.
Let’s now look at the Excel shortcuts cheat sheet, which you should know when working on Microsoft Excel. In this article, we have categorized 35 Excel shortcuts based on their operations. First, we will look at the workbook shortcut keys.
Workbook Shortcut Keys
In this section, we will understand the basics of operating a workbook. We will learn how to create a new workbook, open an existing workbook, and save a spreadsheet so that you don’t lose any data or calculations that you have done.
We will then go through how you can toggle between several different sheets in a workbook.
|1. To create a new workbook||Ctrl + N|
|2. To open an existing workbook||Ctrl + O|
|3. To save a workbook/spreadsheet||Ctrl + S|
|4. To close the current workbook||Ctrl + W|
|5. To close Excel||Ctrl + F4|
|6. To move to the next sheet||Ctrl + PageDown|
|7. To move to the previous sheet||Ctrl + PageUp|
|8. To go to the Data tab||Alt + A|
|9. To go to the View tab||Alt + W|
|10. To go the Formula tab||Alt + M|
Those were the Excel shortcuts that can help you navigate through your spreadsheet. Once the workbook creation is done, the next key step is cell formatting.
Cell Formatting Shortcut Keys
A cell in Excel holds all the data that you are working on. Several different shortcuts can be applied to a cell, such as editing a cell, aligning cell contents, adding a border to a cell, adding an outline to all the selected cells, and many more.
Here is a sneak peek into these Excel shortcuts.
|11. To edit a cell||F2|
|12. To copy and paste cells||Ctrl + C, Ctrl + V|
|13. To italicize and make the font bold||Ctrl + I, Ctrl + B|
|14. To center align cell contents||Alt + H + A + C|
|15. To fill color||Alt + H + H|
|16. To add a border||Alt + H + B|
|17. To remove outline border||Ctrl + Shift + _|
|18. To add an outline to the select cells||Ctrl + Shift + &|
|19. To move to the next cell||Tab|
|20. To move to the previous cell||Shift + Tab|
|21. To select all the cells on the right||Ctrl + Shift + Right arrow|
|22. To select all the cells on the left||Ctrl + Shift + Left Arrow|
|23. To select the column from the selected cell to the end of the table||Ctrl + Shift + Down Arrow|
|24. To select all the cells above the selected cell||Ctrl + Shift + Up Arrow|
|25. To select all the cells below the selected cell||Ctrl + Shift + Down Arrow|
Row and Column Formatting Shortcut Keys
In this section, we’ll look at some critical row and column formatting shortcuts.
We will understand how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.
|26. To select the entire row||Shift + Space|
|27. To select the entire column||Ctrl + Space|
|28. To delete a column||Alt+H+D+C|
|29. To delete a row||Shift + Space, Ctrl + –|
|30. To hide selected row||Ctrl + 9|
|31. To unhide selected row||Ctrl + Shift + 9|
|32. To hide a selected column||Ctrl + 0|
|33. To unhide a selected column||Ctrl + Shift + 0|
|34. To group rows or columns||Alt + Shift + Right arrow|
|35. To ungroup rows or columns||Alt + Shift + Left arrow|
Excel shortcut keys will indeed help you build your reports and analysis faster and better. After reading this article, you would have understood the different types of Excel shortcuts related to the workbook, cell formatting, row and column formatting, and pivot tables.
To kick-start your mastery of Excel, enroll in Free Excel Class.
We hope you find this article useful and can easily master the shortcut keys discussed in this post by working on excel regularly. Do you have any questions related to this article? If yes, then please put it in the comments section below and our experts will get back to you at the earliest.
I love this, more grace
Thanks, we really appreciate you too!
Thank you for your work
You highly welcome to Academee Skill Training. Thanks for appreciating our effort!
This is really helpful to me…
We happy, the post was helpful to you. Keep learning and enjoying Academee Courses.
God bless academee
Big Amen, thanks alot.