Excel Shortcuts Flashcards

1
Q

Edit active cell

A

F2

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

Go to

A

F5

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

Spelling for selected range

A

F7

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

Create chart

A

F11

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

Insert new worksheet

A

Alt Shift F1

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

Insert function

A

Shift F3

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

Find

A

Shift F5

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

Enter current time

A

Ctrl Shift Colon

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

Enter current date

A

Ctrl semicolon

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

Select all

A

Ctrl A

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

Bold

A

Ctrl B

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

Italicize

A

Ctrl I

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

Insert hyperlink

A

Ctrl K

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

Underline

A

Ctrl U

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

Strike-through

A

Ctrl 5

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

Print

A

Ctrl P

17
Q

Undo

A

Ctrl Z

18
Q

Minimize workbook

A

Ctrl F9

19
Q

Maximize workbook

A

Ctrl F10

20
Q

Switch to next workbook

A

Ctrl F6

21
Q

Previous sheet

A

Ctrl PageUp

22
Q

Next sheet

A

Ctrl PageDown

23
Q

Next tab

A

Ctrl Tab

24
Q

Insert value of cell above

A

Ctrl Apostrophe

25
Q

Apply number format

A

Ctrl Shift !

26
Q

Apply currency format

A

Ctrl Shift $

27
Q

Apply date format

A

Ctrl Shift #

28
Q

Apply percentage format

A

Ctrl Shift %

29
Q

Apply exponential format

A

Ctrl Shift ^

30
Q

Apply time format

A

Ctrl Shift @

31
Q

Move to the edge of the current data region in a worksheet

A

Ctrl arrow

32
Q

Select column

A

Ctrl space

33
Q

Select row

A

Shift space