Misc. Shortcuts Flashcards

1
Q

Find

A

Ctrl + F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Find and Replace

A

Ctrl + H

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Find Previous Match

A

Ctrl + Shift + F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Find Next Match

A

Shift + F4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Insert Chart

A

Alt + F1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Insert Chart In New Worksheet

A

F11

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Toggle Auto Filter

A

Ctrl + Shift + L

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Activate Filter

A

Alt + Down Arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Create Table

A

Ctrl + T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Open Visual Basic Editor

A

Alt + F11

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Open Macros

A

Alt + F8

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Insert Row

A

Ctrl + +

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Insert Column

A

Ctrl + +

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Delete Row

A

Ctrl + -

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Delete column

A

Ctrl + -

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
Q

Select Entire Row

A

Shift + Space

26
Q

Select Entire Column

A

Ctrl + Space

27
Q

Select Entire Worksheet

A

Ctrl + A

28
Q

Toggle Add to Select Mode

A

Shift + F8