Excel Shortcuts That You Must Know In 2022 PDF

Here is the list of more than 50 Excel shortcuts that will make you a pro in handling and analyzing data. Working in excel with these shortcuts will save your time and energy. Also, it becomes very easy and enjoyable to work when these excel shortcuts are known.

Excel Shortcuts A to Z

S.No	USE	SHORTCUT
1.	To make a new worksheet	Ctrl+N
2.	To open an existing workbook	Ctr+O
3.	Save a workbook	Ctrl+S
4.	Close the current workbook	Ctrl+W
5.	To close the excel	Ctrl+F4
6.	To move to the next worksheet	Ctrl+Page down
7.	To move to the previous worksheet	Ctrl+Page Up
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
11.	To select all	Ctrl+A
12.	To fill down	Ctrl+D
13.	To find	Ctrl+F
14.	Go-to	Ctrl+G
15.	To replace	Ctrl+H
16.	To print	Ctrl+P
17.	To save a workbook	Ctrl+S
18.	To make the selected text bold	Ctrl+B
19.	To make the selected text italics	Ctrl+I
20.	To underline the selected text	Ctrl+U
21.	To cut	Ctrl+X
22.	For Help	F1
23.	To edit	F2
24.	For spell check	F7
25.	To activate the menu bar	F10
26.	For save as	F12
27.	To copy the selected item	Ctrl+C
28.	To paste the selected item	Ctrl+V
29.	To fill color	Alt+H+H
30.	To add a border	Alt+H+B
31.	To remove an outline border	Ctrl+Shift+_
32.	To add an outline to the selected cell	Ctrl+Shift+&
33.	To move to the next cell	Tab
34.	To move to the previous cell	Shift+Tab
35.	To select all the cells on the right	Ctrl+Shift+Right arrow
36.	To select all the cells on the left	Ctrl+Shift+Left arrow
37.	To add a comment to a cell	Shift+F2
38.	To delete a cell comment	Shift+F10+D
39.	To display find and replace	Ctrl+H
40.	To activate the filter	Ctrl+Shift+L
41.	To insert the current time	Ctrl+Shift+;
42.	To insert the current date	Ctrl+;
43.	To insert hyperlink	Ctrl+K
44.	To apply the currency format	Ctrl+Shift+$
45.	To apply the percentage format	Ctrl+Shift+%
46.	To select the entire row	Shift+Space
47.	To select the entire column	Ctrl+Space
48.	To delete a column	Alt+H+D+C
49.	To delete a row	Shift+Space
50.	To hide the selected row	Ctrl+9
51.	To unhide the selected row	Ctrl+Shift+9
52.	To hide column	Ctrl+0
53.	To unhide column	Ctrl+Shift+0
54.	To group rows or columns	Alt+Shift+Right arrow
55.	To ungroup rows or columns	Alt+Shift+Left arrow
56.	To group pivot table items	Alt+Shift+Right arrow
57.	To ungroup pivot table items	Alt+Shift+Left arrow
58.	To hide pivot table items	Ctrl+-
59.	To create a pivot chart on the same sheet	Alt+F1
60.	To create a pivot chart on a new sheet	F11
61.	To paste the function into the formula	Shift+F3
62.	To calculate the active worksheet	Shift+F9
63.	To show or hide the standard toolbar	Ctrl+7
64.	To show or hide objects	Ctrl+6
65.	Strikethrough	Ctrl+5
66.	To Insert	Ctrl+Plus
67.	For exponential format	Ctrl+Shift+upward arrow
68.	For Autosum	Alt+=
69.	To open a file	Ctrl+F12
70.	To undo an action	Ctrl+Z
71.	To redo an action	Ctr+Y

Download Excel Shortcuts PDF

Here you can download all the excel shortcuts by clicking the below download button.

Read more: 80+ Canva Shortcuts