Excel Shortcut Keys That Make Your Work Easier

E

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. 

DescriptionExcel Shortcuts 
1. To create a new workbookCtrl + N
2. To open an existing workbookCtrl + O
3. To save a workbook/spreadsheetCtrl + S
4. To close the current workbookCtrl + W
5. To close ExcelCtrl + F4
6. To move to the next sheetCtrl + PageDown
7. To move to the previous sheetCtrl + PageUp
8. To go to the Data tabAlt + A
9. To go to the View tabAlt + W
10. To go to the Formula tabAlt + 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.

DescriptionExcel Shortcuts 
11. To edit a cellF2
12. To copy and paste cellsCtrl + C, Ctrl + V
13. To italicize and make the font boldCtrl + I, Ctrl + B
14. To center align cell contentsAlt + H + A + C
15. To fill colorAlt + H + H
16. To add a borderAlt + H + B
17. To remove the outline borderCtrl + Shift + _
18. To add an outline to the select cellsCtrl + Shift + &
19. To move to the next cellTab
20. To move to the previous cellShift + Tab
21. To select all the cells on the rightCtrl + Shift + Right arrow
22. To select all the cells on the leftCtrl + Shift + Left Arrow
23. To select the column from the selected cell to the end of the tableCtrl + Shift + Down Arrow
24. To select all the cells above the selected cellCtrl + Shift + Up Arrow
25. To select all the cells below the selected cellCtrl + Shift + Down Arrow

Here are the shortcuts on how to add comments, find values and replace along with many other functions. 

DescriptionExcel Shortcuts 
26. To add a comment to a cellShift + F2
27. To delete a cell commentShift + F10 + D
28. To display find and replaceCtrl + H
29. To activate the filterCtrl + Shift + LAlt + Down Arrow
30. To insert the current dateCtrl + ;
31. To insert current timeCtrl + Shift + :
32. To insert a hyperlinkCtrl + k
33. To apply the currency formatCtrl + Shift + $
34. To apply the percent formatCtrl + Shift + %
35. To go to the “Tell me what you want to do” boxAlt + 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.

DescriptionExcel Shortcuts 
36. To select the entire rowShift + Space
37. To select the entire columnCtrl + Space
38. To delete a columnAlt+H+D+C
39. To delete a rowShift + Space, Ctrl + – 
40. To hide selected rowCtrl + 9
41. To unhide selected rowCtrl + Shift + 9
42. To hide a selected columnCtrl + 0
43. To unhide a selected columnCtrl + Shift + 0
44. To group rows or columnsAlt + Shift + Right arrow
45. To ungroup rows or columnsAlt + Shift + Left arrow

Enjoy Simpler Processes

With Lio. Have simpler ways of doing your work on the app while keeping a tab on all your documents and business processes. All thanks to the many features of the app.

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

Choose from 10 Different Language offered by Lio

Step 2: Create your account using your Phone Number or Email Id.

Create Account using your Phone Number or Email Id in Lio

Verify the OTP and you are good to go.

Step 3: Select a template in which you want to add your data.

Choose from 60+ Templates offered by Lio And Start Adding Your Data

Add your Data with our Free Cloud Storage.

Step 4: All Done? Share and Collaborate with your contacts.

Share you files with friends and colleagues
Download Lio App

About the author

Surabhi Guleria

Add comment

By Surabhi Guleria