Misc. Shortcuts Flashcards
1
Q
Find
A
Ctrl + F
2
Q
Find and Replace
A
Ctrl + H
3
Q
Find Previous Match
A
Ctrl + Shift + F4
4
Q
Find Next Match
A
Shift + F4
5
Q
Insert Chart
A
Alt + F1
6
Q
Insert Chart In New Worksheet
A
F11
7
Q
Toggle Auto Filter
A
Ctrl + Shift + L
8
Q
Activate Filter
A
Alt + Down Arrow
9
Q
Create Table
A
Ctrl + T
10
Q
Open Visual Basic Editor
A
Alt + F11
11
Q
Open Macros
A
Alt + F8
12
Q
Insert Row
A
Ctrl + +
13
Q
Insert Column
A
Ctrl + +
14
Q
Delete Row
A
Ctrl + -
15
Q
Delete column
A
Ctrl + -
16
Q
Delete Cell
A
Ctrl + -
17
Q
Hide Column
A
Ctrl + 0
18
Q
Hide Row
A
Ctrl + 9
19
Q
Unhide Row
A
Ctrl + Shift + 9
20
Q
Unhide Column
A
Ctrl + Shift + 0
21
Q
Display Insert Dialog Box
A
Ctrl + +
22
Q
Display Delete Dialog Box
A
Ctrl + -
23
Q
Group Rows and Columns
A
Alt + Shift + Right Arrow
24
Q
Ungroup Rows and Columns
A
Alt + Shift + Left Arrow
25
Select Entire Row
Shift + Space
26
Select Entire Column
Ctrl + Space
27
Select Entire Worksheet
Ctrl + A
28
Toggle Add to Select Mode
Shift + F8
