Excel Shortcuts You Should Know

Numerous keyboard shortcuts that Excel provides can help you operate more quickly and productively. Significant operations may be carried out with just two or three keystrokes rather than by using the mouse to enter the toolbar. Isn't that quicker and easier? Excel shortcuts significantly speed up work and cut down on the workload. The answer to the issue of whether you need to learn these shortcuts is no. However, it would help if you could recall a couple of them. You will be able to recall the majority of the standard Excel shortcuts with repeated practice.  

Keys for Cell Formatting Shortcuts

In Excel, each piece of data you are dealing with is stored in a cell. A cell can be edited, its contents can be aligned, borders can be added, all the chosen cells can have an outline added, and many more shortcuts can be used. Here is a sneak preview of these shortcuts for Excel.

Free Demo Classes

Register here for Free Demo Classes

Select Course CUET Digital Marketing NDA Graphics Designing MS Excel (10 Hrs.) Interview Skill Course Entrepreneurship Programme Content Writing

 

Description	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

Let's look at some more and more sophisticated cell formatting Excel shortcuts in addition to the ones stated above that can be useful. We'll discover how to include a comment in a cell. When providing more information regarding cell content, comments are useful. We will also discover how to locate a value in the spreadsheet and swap it out for another one. After that, we'll examine how to activate a filter, add a hyperlink, input the current time and date, and insert them into a cell. Finally, we'll look at how to format the information in a cell.



 

Description	Excel Shortcuts
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 + L Alt + 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

Shortcut Keys for Workbooks

In this lesson, we'll learn the fundamentals of using a workbook. To prevent losing any data or computations you have made, we will cover how to create a new workbook, open an existing workbook, and save a spreadsheet. The process of switching between numerous distinct sheets in a workbook will next be covered.
 

Description	Excel 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

Shortcut Keys for Row and Column Formatting

We'll look at several important row and column formatting fast cuts in this section. We will comprehend how to remove columns and rows, conceal and reveal the chosen columns and rows, and group and ungroup columns and rows.
 

Description	Excel Shortcuts
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