Keyboard Shortcuts Flashcards
1
Q
Expand or Collapse Ribbon
A
Ctrl + F1
2
Q
Go to Search Bar
A
Alt + Q
3
Q
Open File Menu
A
Alt + F
4
Q
Go to Home Tab
A
Alt + H
5
Q
Go to Insert Tab
A
Alt + N
6
Q
Go to Page Layout Tab
A
Alt + P
7
Q
Go to Formula Tab
A
Alt + M
8
Q
Go to Data Tab
A
Alt + A
9
Q
Go to Review Tab
A
Alt + R
10
Q
Go to View Tab
A
Alt + W
11
Q
Go to Help Tab
A
Alt + Y1
12
Q
Open “Format Cells” Dialog Box
A
Ctrl + 1
13
Q
Apply/Unapply Bold
A
Ctrl + B
14
Q
Apply/Unapply Italics
A
Ctrl + I
15
Q
Apply/Unapply Underline
A
Ctrl + U
16
Q
Apply/Unapply Strikethrough
A
Ctrl + 5
17
Q
Apply Currency Format
A
Ctrl + Shift + $
18
Q
Apply Percentage Format
A
Ctrl + Shift + %
19
Q
Apply Date Format
A
Ctrl + Shift + #
20
Q
Apply Time Format
A
Ctrl + Shift + @
21
Q
Apply Number Format
A
Ctrl + Shift + !
22
Q
Apply General Format
A
Ctrl + Shift + ~
23
Q
Center Align Cell Contents
A
Alt + H + A + C
24
Q
Left Align Cell Contents
A
Alt + H + A + L
25
Right Align Cell Contents
Alt + H + A + R
26
Autosum All Selected Cells
Alt + =
27
Add Function Arguments
Ctrl + Shift + A
28
Toggle Formula Bar
Ctrl + Shift + :
29
Toggle Cell Formulas and Values
Ctrl + `
30
Copy Selected Cells
Ctrl + C
31
Paste Clipboard Contents
Ctrl + V
32
Display "Paste Special"
Ctrl + Alt + V
33
Cut Selection
Ctrl + X
34
Undo Previous Action
Ctrl + Z
35
Redo Previous Action
Ctrl + Y
36
Display Find Dialog
Ctrl + F
37
Display Replace Dialog
Ctrl + H
38
Display Go To Dialog
Ctrl + G
39
Insert or Edit Comment
Shift + F2
40
Insert New Line in Cell
Alt + Enter
41
Edit Contents of Active Cell
F2
42
Enter the Same Data in Multiple Cells
Ctrl + Enter
43
Insert Current Date Into Cell
Ctrl + ;
44
Insert Current Time Into Cell
Ctrl + Shift + :
45
Open Context Menu
Shift + F10
46
Copy a Formula From Cell Above to Cell
Ctrl + '
47
Open Insert Hyperlink Dialog Box
Ctrl + K
48
Open Validation List on a Cell
Alt + Down Arrow
49
Open a Workbook
Ctrl + O
50
Create a New Workbook
Ctrl + N
51
Save a Workbook
Ctrl + S
52
Save "as"
F12
53
Print a Workbook
Ctrl + P
54
Open Print Preview
Ctrl + F2
55
Navigate Forward Between Workbooks
Ctrl + Tab
56
Navigate Back Between Workbooks
Ctrl + Shift + Tab
57
Close a Workbook
Ctrl + W
58
Move One Cell to the Right
Right Arrow or Tab
59
Move One Cell to the Left
Left Arrow or Shift + Tab
60
Move One Cell Up
Up Arrow
61
Move One Cell Down
Down Arrow
62
Move One Screen Right
Alt + PgDn
63
Move one Screen Left
Alt + PgUp
64
Move One Screen Up
PgUp
65
Move One Screen Down
PgDn
66
Move to Right Edge of Data Range
Ctrl + Right Arrow
67
Move to Left Edge of Data Range
Ctrl + Left Arrow
68
Move to Top Edge of Data Range
Ctrl + Up Arrow
69
Move to Bottom Edge of Data Range
Ctrl + Down Arrow
70
Navigate to Beginning of Row
Home
71
Move to End Cell
Ctrl + End
72
Insert New Worksheet
Shift + F11
73
Go to Next Worksheet
Ctrl + PgDn
74
Go to Previous Worksheet
Ctrl + PgUp
75
Select Entire Worksheet
Ctrl + A
76
Select Entire Row
Shift + Space
77
Select Entire Column
Ctrl + Space
78
Cancel Selection
Esc
79
Extend Selection to the Right
Shift + Right Arrow
80
Extend Selection to the Left
Shift + Left Arrow
81
Extend Selection Down
Shift + Down Arrow
82
Extend Selection Up
Shift + Up Arrow
83
Extend Selection to the Last Right Cell
Ctrl + Shift + Right Arrow
84
Extend Selection to the Last Left Cell
Ctrl + Shift + Left Arrow
85
Extend Selection to the Last Bottom Cell
Ctrl + Shift + Down Arrow
86
Extend Selection to the Last Upper Cell
Ctrl + Shift + Up Arrow
87
Show Active Cell In Selection
Ctrl + Back Space
88
Fill Down Cop to Selected Range
Ctrl + D
89
Delete Rows or Columns
Ctrl + -
90
Insert Rows or Columns
Ctrl + Shift + +
91
Select All Objects On Worksheet
Ctrl + Shift + Space
92
Hide Selected Columns
Ctrl + 0
93
Hide Selected Rows
Ctrl + 9
