Excel Flashcards
1
Q
Select All
A
Ctrl+A
2
Q
Bold
A
Ctrl+B
3
Q
Copy
A
Ctrl+C
4
Q
Fill Down
A
Ctrl+D
5
Q
Find
A
Ctrl+F
6
Q
Goto
A
Ctrl+G
7
Q
Replace
A
Ctrl+H
8
Q
Italic
A
Ctrl+I
9
Q
New Workbook
A
Ctrl+N
10
Q
Open
A
Ctrl+O
11
Q
A
Ctrl+P
12
Q
Fill Right
A
Ctrl+R
13
Q
Save
A
Ctrl+S
14
Q
Underline
A
Ctrl+U
15
Q
Paste
A
Ctrl+V
16
Q
Cut
A
Ctrl+X
17
Q
Repeat
A
Ctrl+Y
18
Q
Undo
A
Ctrl+Z
19
Q
Help
A
F1
20
Q
Edit
A
F2
21
Q
Paste Name
A
F3
22
Q
Repeat last action
A
F4
23
Q
While typing a formula, switch between absolute/relative refs
A
F4
24
Q
Goto
A
F5
25
Next Pane
F6
26
Spell check
F7
27
Extend mode
F8
28
Recalculate all workbooks
F9
29
Activate Menubar
F10
30
New Chart
F11
31
Save As
F12
32
Insert Current Time
Ctrl+:
33
Insert Current Date
Ctrl+;
34
Copy Value from Cell Above
Ctrl+"
35
Copy Formula from Cell Above
Ctrl+’
36
What’s This?
Shift+F1
37
Edit cell comment
Shift+F2
38
Paste function into formula
Shift+F3
39
Find Next
Shift+F4
40
Find
Shift+F5
41
Previous Pane
Shift+F6
42
Add to selection
Shift+F8
43
Calculate active worksheet
Shift+F9
44
Display shortcut menu
Shift+F10
45
New worksheet
Shift+F11
46
Save
Shift+F12
47
Define name
Ctrl+F3
48
Close
Ctrl+F4
49
XL, Restore window size
Ctrl+F5
50
Next workbook window
Ctrl+F6
51
Previous workbook window
Shift+Ctrl+F6
52
Move window
Ctrl+F7
53
Resize window
Ctrl+F8
54
Minimize workbook
Ctrl+F9
55
Maximize or restore window
Ctrl+F10
56
Inset 4.0 Macro sheet
Ctrl+F11
57
File Open
Ctrl+F12
58
Insert Chart
Alt+F1
59
Save As
Alt+F2
60
Exit
Alt+F4
61
Create name by using names of row and column labels
Ctrl+Shift+F3
62
Previous Window
Ctrl+Shift+F6
63
Print
Ctrl+Shift+F12
64
New worksheet
Alt+Shift+F1
65
Save
Alt+Shift+F2
66
AutoSum
Alt+=
67
Toggle Value/Formula display
Ctrl+`
68
Insert argument names into formula
Ctrl+Shift+A
69
Format Style dialog box
Alt+’
70
General format
Ctrl+Shift+~
71
Comma format
Ctrl+Shift+!
72
Time format
Ctrl+Shift+@
73
Date format
Ctrl+Shift+#
74
Currency format
Ctrl+Shift+$
75
Percent format
Ctrl+Shift+%
76
Exponential format
Ctrl+Shift+^
77
Place outline border around selected cells
Ctrl+Shift+&
78
Remove outline border
Ctrl+Shift+_
79
Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report.
Ctrl+Shift+*
80
Insert
Ctrl++
81
Delete
Ctrl+-
82
Format cells dialog box
Ctrl+1
83
Bold
Ctrl+2
84
Italic
Ctrl+3
85
Underline
Ctrl+4
86
Strikethrough
Ctrl+5
87
Show/Hide objects
Ctrl+6
88
Show/Hide Standard toolbar
Ctrl+7
89
Toggle Outline symbols
Ctrl+8
90
Hide rows
Ctrl+9
91
Hide columns
Ctrl+0
92
Unhide rows
Ctrl+Shift+(
93
Unhide columns
Ctrl+Shift+)
94
Activate the menu
Alt or F10
95
Font Drop Down List
Shift+Ctrl+F
96
Point size Drop Down List
Shift+Ctrl+P
97
Select the array containing the active cell.
CTRL+/
98
Select all cells that contain comments.
CTRL+SHIFT+O
99
In a selected row, select the cells that don’t match the formula or static value in the active cell.
CTRL+\
100
In a selected column, select the cells that don’t match the formula or static value in the active cell.
CTRL+SHIFT+|
101
Select all cells directly referenced by formulas in the selection.
CTRL+[
102
Select all cells directly or indirectly referenced by formulas in the selection.
CTRL+SHIFT+{
103
Select cells that contain formulas that directly reference the active cell.
CTRL+]
104
Select cells that contain formulas that directly or indirectly reference the active cell.
CTRL+SHIFT+}
105
Select the visible cells in the current selection.
ALT+;
106
With multiple cells selected, select only the active cell.
SHIFT+BACKSPACE
107
Selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a
CTRL+SHIFT+SPACEBAR
108
Action
Shortcut key
109
Select All
Ctrl+A
110
Bold
Ctrl+B
111
Copy
Ctrl+C
112
Fill Down
Ctrl+D
113
Find
Ctrl+F
114
Goto
Ctrl+G
115
Replace
Ctrl+H
116
Italic
Ctrl+I
117
New Workbook
Ctrl+N
118
Open
Ctrl+O
119
Print
Ctrl+P
120
Fill Right
Ctrl+R
121
Save
Ctrl+S
122
Underline
Ctrl+U
123
Paste
Ctrl+V
124
Cut
Ctrl+X
125
Repeat
Ctrl+Y
126
Undo
Ctrl+Z
127
Help
F1
128
Edit
F2
129
Paste Name
F3
130
Repeat last action
F4
131
While typing a formula, switch between absolute/relative refs
F4
132
Goto
F5
133
Next Pane
F6
134
Spell check
F7
135
Extend mode
F8
136
Recalculate all workbooks
F9
137
Activate Menubar
F10
138
New Chart
F11
139
Save As
F12
140
Insert Current Time
Ctrl+:
141
Insert Current Date
Ctrl+;
142
Copy Value from Cell Above
Ctrl+"
143
Copy Formula from Cell Above
Ctrl+'
144
What's This?
Shift+F1
145
Edit cell comment
Shift+F2
146
Paste function into formula
Shift+F3
147
Find Next
Shift+F4
148
Find
Shift+F5
149
Previous Pane
Shift+F6
150
Add to selection
Shift+F8
151
Calculate active worksheet
Shift+F9
152
Display shortcut menu
Shift+F10
153
New worksheet
Shift+F11
154
Save
Shift+F12
155
Define name
Ctrl+F3
156
Close
Ctrl+F4
157
XL, Restore window size
Ctrl+F5
158
Next workbook window
Ctrl+F6
159
Previous workbook window
Shift+Ctrl+F6
160
Move window
Ctrl+F7
161
Resize window
Ctrl+F8
162
Minimize workbook
Ctrl+F9
163
Maximize or restore window
Ctrl+F10
164
Inset 4.0 Macro sheet
Ctrl+F11
165
File Open
Ctrl+F12
166
Insert Chart
Alt+F1
167
Save As
Alt+F2
168
Exit
Alt+F4
169
Create name by using names of row and column labels
Ctrl+Shift+F3
170
Previous Window
Ctrl+Shift+F6
171
Print
Ctrl+Shift+F12
172
New worksheet
Alt+Shift+F1
173
Save
Alt+Shift+F2
174
AutoSum
Alt+=
175
Toggle Value/Formula display
Ctrl+`
176
Insert argument names into formula
Ctrl+Shift+A
177
Format Style dialog box
Alt+'
178
General format
Ctrl+Shift+~
179
Comma format
Ctrl+Shift+!
180
Time format
Ctrl+Shift+@
181
Date format
Ctrl+Shift+#
182
Currency format
Ctrl+Shift+$
183
Percent format
Ctrl+Shift+%
184
Exponential format
Ctrl+Shift+^
185
Place outline border around selected cells
Ctrl+Shift+&
186
Remove outline border
Ctrl+Shift+_
187
Select current region
Ctrl+Shift+*
188
Insert
Ctrl++
189
Delete
Ctrl+-
190
Format cells dialog box
Ctrl+1
191
Bold
Ctrl+2
192
Italic
Ctrl+3
193
Underline
Ctrl+4
194
Strikethrough
Ctrl+5
195
Show/Hide objects
Ctrl+6
196
Show/Hide Standard toolbar
Ctrl+7
197
Toggle Outline symbols
Ctrl+8
198
Hide rows
Ctrl+9
199
Hide columns
Ctrl+0
200
Unhide rows
Ctrl+Shift+(
201
Unhide columns
Ctrl+Shift+)
202
Activate the menu
Alt or F10
203
Font Drop Down List
Shift+Ctrl+F
204
Point size Drop Down List
Shift+Ctrl+P
205
Delete current Workbook
Alt+e then L
206
Rename Current worksheet
Alt+o then h r
207
Move curren worksheet
Alt+e then m
