ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ShortcutUse
2
CTRL + Page UpNavigate to the next sheet
3
CTRL + Page Down
Navigate to the Previous sheet
4
F11Create Chart
5
CTRL + F3Name Manager:
6
CTRL + [Select Direct Precedents:
7
CTRL + ]Select Direct Dependents:
8
CTRL + Shift + [Select All Precedents:
9
CTRL + Shift + ]Select All Dependents:
10
CTRL + Shift + \Select Column Differences:
11
F2Active Cell
12
CTRL + '
Copy Formula Text From Above:
13
CTRL + Shift + 'Copy Cell Value From Above:
14
CTRL + EnterFill Selected Cells:
15
CTRL + DFill Down
16
CTRL + RFill right
17
CTRL + FFind Window:
18
Shift + F4Find Next Match:
19
CTRL + Shift + F4Find Previous:
20
F5 or (CTRL + G)Go To Window:
21
CTRL + .Select Corners:
22
CTRL + BackSpaceShow Active Cell:
23
Alt + ;Select Visible Cells Only:
24
Shift + Alt + Right Arrow
Group Rows And Columns:
25
Shift + Alt + Left Arrow
UnGroup Rows And Columns:
26
CTRL + -Filter Out Item from Pivot:
27
CTRL + ArrowsJump inside the Database
28
CTRL + 0Hide Columns
29
CTRL + 9Hide Rows
30
CTRL + Shift + 0Show Columns
31
CTRL + Shift + 9Show Rows
32
CTRL + Shift + LAuto Filter
33
Alt + EnterPage Break
34
CTRL + EFlash Fill
35
Alt + =Auto Sum
36
CTRL + 1Format Cells
37
CTRL + Shift + :Insert Time
38
CTRL + :Insert Date
39
SHIFT + F3Open or Insert Function
40
CTRL + SHIFT + #Convert Formatting to Date
41
CTRL + SHIFT + !Comma Style
42
CTRL + SHIFT + %Percentage Style
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100