Keyboard Shortcuts Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Expand or Collapse Ribbon

A

Ctrl + F1

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

Go to Search Bar

A

Alt + Q

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

Open File Menu

A

Alt + F

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

Go to Home Tab

A

Alt + H

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

Go to Insert Tab

A

Alt + N

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

Go to Page Layout Tab

A

Alt + P

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

Go to Formula Tab

A

Alt + M

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

Go to Data Tab

A

Alt + A

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

Go to Review Tab

A

Alt + R

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

Go to View Tab

A

Alt + W

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

Go to Help Tab

A

Alt + Y1

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

Open “Format Cells” Dialog Box

A

Ctrl + 1

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

Apply/Unapply Bold

A

Ctrl + B

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

Apply/Unapply Italics

A

Ctrl + I

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

Apply/Unapply Underline

A

Ctrl + U

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

Apply/Unapply Strikethrough

A

Ctrl + 5

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

Apply Currency Format

A

Ctrl + Shift + $

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

Apply Percentage Format

A

Ctrl + Shift + %

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

Apply Date Format

A

Ctrl + Shift + #

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

Apply Time Format

A

Ctrl + Shift + @

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

Apply Number Format

A

Ctrl + Shift + !

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

Apply General Format

A

Ctrl + Shift + ~

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

Center Align Cell Contents

A

Alt + H + A + C

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

Left Align Cell Contents

A

Alt + H + A + L

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

Right Align Cell Contents

A

Alt + H + A + R

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

Autosum All Selected Cells

A

Alt + =

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

Add Function Arguments

A

Ctrl + Shift + A

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

Toggle Formula Bar

A

Ctrl + Shift + :

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

Toggle Cell Formulas and Values

A

Ctrl + `

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

Copy Selected Cells

A

Ctrl + C

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

Paste Clipboard Contents

A

Ctrl + V

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

Display “Paste Special”

A

Ctrl + Alt + V

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

Cut Selection

A

Ctrl + X

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

Undo Previous Action

A

Ctrl + Z

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

Redo Previous Action

A

Ctrl + Y

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

Display Find Dialog

A

Ctrl + F

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

Display Replace Dialog

A

Ctrl + H

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

Display Go To Dialog

A

Ctrl + G

39
Q

Insert or Edit Comment

A

Shift + F2

40
Q

Insert New Line in Cell

A

Alt + Enter

41
Q

Edit Contents of Active Cell

A

F2

42
Q

Enter the Same Data in Multiple Cells

A

Ctrl + Enter

43
Q

Insert Current Date Into Cell

A

Ctrl + ;

44
Q

Insert Current Time Into Cell

A

Ctrl + Shift + :

45
Q

Open Context Menu

A

Shift + F10

46
Q

Copy a Formula From Cell Above to Cell

A

Ctrl + ‘

47
Q

Open Insert Hyperlink Dialog Box

A

Ctrl + K

48
Q

Open Validation List on a Cell

A

Alt + Down Arrow

49
Q

Open a Workbook

A

Ctrl + O

50
Q

Create a New Workbook

A

Ctrl + N

51
Q

Save a Workbook

A

Ctrl + S

52
Q

Save “as”

A

F12

53
Q

Print a Workbook

A

Ctrl + P

54
Q

Open Print Preview

A

Ctrl + F2

55
Q

Navigate Forward Between Workbooks

A

Ctrl + Tab

56
Q

Navigate Back Between Workbooks

A

Ctrl + Shift + Tab

57
Q

Close a Workbook

A

Ctrl + W

58
Q

Move One Cell to the Right

A

Right Arrow or Tab

59
Q

Move One Cell to the Left

A

Left Arrow or Shift + Tab

60
Q

Move One Cell Up

A

Up Arrow

61
Q

Move One Cell Down

A

Down Arrow

62
Q

Move One Screen Right

A

Alt + PgDn

63
Q

Move one Screen Left

A

Alt + PgUp

64
Q

Move One Screen Up

A

PgUp

65
Q

Move One Screen Down

A

PgDn

66
Q

Move to Right Edge of Data Range

A

Ctrl + Right Arrow

67
Q

Move to Left Edge of Data Range

A

Ctrl + Left Arrow

68
Q

Move to Top Edge of Data Range

A

Ctrl + Up Arrow

69
Q

Move to Bottom Edge of Data Range

A

Ctrl + Down Arrow

70
Q

Navigate to Beginning of Row

A

Home

71
Q

Move to End Cell

A

Ctrl + End

72
Q

Insert New Worksheet

A

Shift + F11

73
Q

Go to Next Worksheet

A

Ctrl + PgDn

74
Q

Go to Previous Worksheet

A

Ctrl + PgUp

75
Q

Select Entire Worksheet

A

Ctrl + A

76
Q

Select Entire Row

A

Shift + Space

77
Q

Select Entire Column

A

Ctrl + Space

78
Q

Cancel Selection

A

Esc

79
Q

Extend Selection to the Right

A

Shift + Right Arrow

80
Q

Extend Selection to the Left

A

Shift + Left Arrow

81
Q

Extend Selection Down

A

Shift + Down Arrow

82
Q

Extend Selection Up

A

Shift + Up Arrow

83
Q

Extend Selection to the Last Right Cell

A

Ctrl + Shift + Right Arrow

84
Q

Extend Selection to the Last Left Cell

A

Ctrl + Shift + Left Arrow

85
Q

Extend Selection to the Last Bottom Cell

A

Ctrl + Shift + Down Arrow

86
Q

Extend Selection to the Last Upper Cell

A

Ctrl + Shift + Up Arrow

87
Q

Show Active Cell In Selection

A

Ctrl + Back Space

88
Q

Fill Down Cop to Selected Range

A

Ctrl + D

89
Q

Delete Rows or Columns

A

Ctrl + -

90
Q

Insert Rows or Columns

A

Ctrl + Shift + +

91
Q

Select All Objects On Worksheet

A

Ctrl + Shift + Space

92
Q

Hide Selected Columns

A

Ctrl + 0

93
Q

Hide Selected Rows

A

Ctrl + 9