Excel Shortcuts You Should Know

Safalta Expert Published by: Saksham Chauhan Updated Fri, 26 Aug 2022 01:12 AM IST

Highlights

You will be able to recall the majority of the standard Excel shortcuts with repeated practise. However, it would help if you could recall a couple of them. Excel shortcuts significantly speed up work and cut down on workload.

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
Something went wrong!
Download App & Start Learning
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.

Source: Safalta.com

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.
 

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

Free Demo Classes

Register here for Free Demo Classes

Trending Courses

Professional Certification Programme in Digital Marketing (Batch-11)
Professional Certification Programme in Digital Marketing (Batch-11)

Now at just ₹ 49999 ₹ 9999950% off

Advanced Certification in Digital Marketing Online Programme (Batch-29)
Advanced Certification in Digital Marketing Online Programme (Batch-29)

Now at just ₹ 24999 ₹ 3599931% off

Advanced Certification in Digital Marketing Classroom Programme (Batch-3)
Advanced Certification in Digital Marketing Classroom Programme (Batch-3)

Now at just ₹ 29999 ₹ 9999970% off

Basic Digital Marketing Course (Batch-24): 50 Hours Live+ Recorded Classes!
Basic Digital Marketing Course (Batch-24): 50 Hours Live+ Recorded Classes!

Now at just ₹ 1499 ₹ 999985% off