Excel Shortcuts (PC) Flashcards

The fastest way to learn Excel shortcuts, provided by our partners at HotKeyExcel.com

1
Q

Undo

A

Ctrl + Z

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

Redo

A

Ctrl + Y

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

Save

A

Ctrl + S

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

Save as

A

F12

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

Close Excel File

A

Ctrl + F4

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

Create New Excel File

A

Ctrl + N

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

Displaying Control Menu

A

Alt + Spacebar

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

Close Excel Application

A

Alt + F4

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

Move Between Sheets Clockwise

A

Ctrl + PageDown

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

Move Between Open Excel Files

A

Ctrl + Tab

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

Cut

A

Ctrl + X

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

What is the best online tool with which you can practice your Excel shortcuts in real simulated Excel scenarios?

A

HotKey Excellence

Check out the website at HotKeyExcel.com

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

Copy

A

Ctrl + C

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

Paste

A

Ctrl + V

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

Uncopy

A

Esc

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

Fill Down

A

Ctrl + D

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

Paste Once

A

Enter

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

Fill Right

A

Ctrl + R

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

Show Formula

A

F2

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

Paste Special

A

Ctrl + Alt + V

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

Fill Formula After Showing Formula

A

Ctrl + Enter

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

Hide/Unhide Toolbar

A

Ctrl + F1

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

Go to Cell A1

A

Ctrl + Home

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

Move one cell up

A

Up Arrow

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

Move one cell left

A

Left Arrow

26
Q

Move one cell down

A

Down Arrow

27
Q

Move one cell right

A

Right Arrow

28
Q

Go to the Linked Cell

A

Ctrl + [

29
Q

Deselect to Original Cell

A

Shift + Backspace

30
Q

Open “Go To” Dialog Window

A

F5

31
Q

Open “Name Manager” Window

A

Ctrl + F3

32
Q

Zoom In

A

Ctrl + Alt + “+”

33
Q

Zoom Out

A

Ctrl + Alt + “-“

34
Q

Highlight Row

A

Shift + Spacebar

35
Q

Highlight Column

A

Ctrl + Spacebar

36
Q

Delete Column/Row

A

Ctrl + “-“

37
Q

Insert Column/Row

A

Ctrl + “+”

38
Q

Highlight Cells Up

A

Shift + Up Arrow

39
Q

Highlight Cells Down

A

Shift + Down Arrow

40
Q

Highlight Cells to the Left

A

Shift + Left Arrow

41
Q

Highlight Cells to the Right

A

Shift + Right Arrow

42
Q

Bold Text

A

Ctrl + B

43
Q

Cross Text

A

Ctrl + 5

44
Q

Itilize Text

A

Ctrl + I

45
Q

Underline Text

A

Ctrl + U

46
Q

Format as Percent

A

Ctrl + Shift + %

47
Q

Format as General

A

Ctrl + Shift + ~

48
Q

Format as Currency

A

Ctrl + Shift + $

49
Q

Find and Replace Window

A

Ctrl + H

50
Q

Open “Format Cells” Window

A

Ctrl + 1

51
Q

Right Clicking Menu

A

Shift + F10

52
Q

AutoSum

A

Alt + =

53
Q

Insert Comment

A

Ctrl + F2

54
Q

Delete Comment

A

Esc, Delete

55
Q

Show All Formulas

A

Ctrl + ~

56
Q

Toggle between Edit and Enter mode in cell

A

F2

57
Q

Repeat Previous Action

A

F4

58
Q

Close Comment

A

Esc, Esc

59
Q

Expand/Collapse Formula Bar

A

Ctrl + Shift + U

60
Q

Open “Insert Function” Window

A

Shift + F3

61
Q

Create New Sheet

A

Shift + F11