MS Excel 50 Short cut keys : Check here !

Microsoft Excel is widely used around the world to store and analyse data. Despite a profusion of new data analytics tools on the market, Excel remains the preferred tool for working with data. Because of its different built-in capabilities, you'll find that organising your data is made easier for you. Excel's shortcut keys make it quick and easy to use your data. We'll go over the various Excel shortcuts in this article. Using these keyboard shortcuts expedites and effectively completes tasks.
Download these FREE Ebooks:
1. Introduction to Digital Marketing
2. Website Planning and Creation

Also check,
MS Excel 50 Short cut keys : Check here !

Table of content

Workbook Shortcut Keys
Cell Formatting Shortcut Keys
Row and Column Formatting Shortcut Keys
 

Workbook Shortcut Keys

The table below consists of workbook shortcut keys

 

Description	Excel Shortcuts
1. to design a fresh 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

 

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

Cell Formatting Shortcut Keys

The table below consists of Cell Formatting Shortcut Keys
 

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

 

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

 

Row and Column Formatting Shortcut Keys

The table below consists of Row and Column Formatting Shortcut Keys 
 

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

Yes, using Excel shortcut keys will speed up and improve the creation of your reports and analyses. You should now be familiar with the various Excel keyboard shortcuts for the workbook, cell formatting, row and column formatting, and pivot tables.

italicize and make the font bold

Ctrl + I, Ctrl + B