Read about the top excel shortcut keys that will make your work very easy and absolutely hassle-free in no time.
Microsoft is used extensively throughout the world and helps many in handling their data and getting great insights and reports. Big as well as small companies make use of this program to manage their data and run successfully.
Microsoft Excel offers several amazing features that make data analysis and management very easy. No matter how big a sheet is, Excel can do calculations and analysis in mere minutes. The program also offers many shortcuts to the many features which are of great use. Let us look at some of the top excel shortcut keys that can make your life very easy.
Excel Shortcut Keys
Workbook Shortcut Keys
Let us learn how to create a new workbook, open an existing workbook, and save a spreadsheet all with shortcuts.
|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 to the Formula tab||Alt + M|
Cell Formatting Shortcut Keys
A cell consists of all the data that you are working on. There are many shortcuts that you can make use of like adding borders, editing cells, adding outlines, etc. Let us look at some of the shortcuts that you can make use of in excel.
|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 the 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|
Here are the shortcuts on how to add comments, find values and replace along with many other functions.
|26. To add a comment to a cell||Shift + F2|
|27. To delete a cell comment||Shift + F10 + D|
|28. To display find and replace||Ctrl + H|
|29. To activate the filter||Ctrl + Shift + LAlt + Down Arrow|
|30. To insert the current date||Ctrl + ;|
|31. To insert current time||Ctrl + Shift + :|
|32. To insert a hyperlink||Ctrl + k|
|33. To apply the currency format||Ctrl + Shift + $|
|34. To apply the percent format||Ctrl + Shift + %|
|35. To go to the “Tell me what you want to do” box||Alt + Q|
Row and Column Formatting Shortcut Keys
Let us now learn how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.
|36. To select the entire row||Shift + Space|
|37. To select the entire column||Ctrl + Space|
|38. To delete a column||Alt+H+D+C|
|39. To delete a row||Shift + Space, Ctrl + –|
|40. To hide selected row||Ctrl + 9|
|41. To unhide selected row||Ctrl + Shift + 9|
|42. To hide a selected column||Ctrl + 0|
|43. To unhide a selected column||Ctrl + Shift + 0|
|44. To group rows or columns||Alt + Shift + Right arrow|
|45. To ungroup rows or columns||Alt + Shift + Left arrow|
Maximize Your Online Business Potential for just ₹79/month on Lio. Annual plans start at just ₹799.
How Lio can Help You?
Lio is a great platform that can help entrepreneurs, homemakers, students, businessmen, managers, shop owners and many others. This mobile application helps to organize business data and present them in an eye-catching manner.
Lio is a great platform for small business owners and can track a wholesome record of employee information for better employee management, customer data, etc. You can handle those data with ease.
If you want to be a professional, then you must save your time, you need to learn to arrange all the business strategies in one place. In that case, Lio can be your partner.
Entrepreneurs can also allow multiple authorized users of their office to access the information from various locations within minutes.
Lio is definitely for the win and using it for your business is only going to make your journey smooth and easy to track.
Step 1: Select the Language you want to work on. Lio on Android
Step 2: Create your account using your Phone Number or Email Id.
Verify the OTP and you are good to go.
Step 3: Select a template in which you want to add your data.
Add your Data with our Free Cloud Storage.
Step 4: All Done? Share and Collaborate with your contacts.