MS Excel 50 Short cut keys : Check here !

Safalta expert Published by: Saksham Chauhan Updated Fri, 16 Sep 2022 01:18 AM IST

Highlights

Check MS Excel 50 Short cut keys Here At Safalta.com

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.

Free Demo Classes

Register here for Free Demo Classes

Please fill the name
Please enter only 10 digit mobile number
Please select course
Please fill the email
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

 

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.

What is the shortcut for copy ?

Ctrl + C

What is the shortcut to open an existing workbook?

 

Ctrl + O

How to select the entire row?

Shift + Space

How To apply the percent format?

Ctrl + Shift + %

Free E Books