Excel Shortcuts Flashcards
1
Q
Copy
A
Ctrl+C
2
Q
Paste
A
Ctrl+V
3
Q
Undo
A
Ctrl+Z
4
Q
Redo
A
Ctrl+Y
5
Q
Open
A
Ctrl+O
6
Q
New
A
Ctrl+N
7
Q
A
Ctrl+P
8
Q
Save
A
Ctrl+S
9
Q
Save As
A
F12
10
Q
Go to next workbook
A
Ctrl + Tab
11
Q
Close File
A
Ctrl+F4
12
Q
Show ribbon accelerator keys
A
Alt
13
Q
Show/hide ribbon
A
Ctrl+F1
14
Q
Move from cell to cell
A
Arrows
15
Q
Go to end of contiguous range
A
Ctrl+Arrows
16
Q
Move one screen up
A
PgUp
17
Q
Move one screen down
A
PgDn
18
Q
Move on screen left
A
Alt+PgUp
19
Q
Move one screen right
A
Alt+PgDn
20
Q
Go to cell A1
A
Ctrl+Home
21
Q
Go to beginning of row
A
Home
22
Q
Go to last cell in a worksheet
A
Ctrl+End
23
Q
Open the Go To dialog box
A
F5
24
Q
Open format cells dialog
A
Ctrl+1
25
Bold
Ctrl+B
26
Italic
Ctrl+I
27
Underline
Ctrl+U
28
Number Format
Ctrl+Up+!
29
Percent Format
Ctrl+Up+%
30
Date Format
Ctrl+Up+#
31
Increase Font Size
Alt H FG
32
Decrease Font Size
Alt H FK
33
Insert/edit comment
up + F2
34
Increase decimal
Alt H 0
35
Decrease decimal
Alt H 9
36
Increase indent
Alt H 6
37
decrease indent
Alt H 5
38
Clear cell data
delete
39
Clear cell formats
Alt H E F
40
Clear Cell comments
Alt H E M
41
Clear All
Alt H E A
42
Outline Border
Ctrl+Up+&
43
Remove Border
Ctrl+Up+-
44
Left Border
ALT H B L
45
Right Border
Alt H B R
46
Top Border
Alt H B T
47
Bottom Border
Alt H B O
48
Paste special formats
Ctrl+Alt+ V T
49
Paste special values
Ctrl+Alt+ V V
50
Paste special formulas
Ctrl+Alt+ V F
51
Paste Special Comments
Ctrl+Alt+ V C
52
Select a cell range
Up+ Arrows
53
Highlight a contiguous range
Ctrl+Up+ Arrows
54
Extend selection up a screen
PgUp
55
Extend selection down a screen
PgDn
56
Extend selection left a screen
Alt+Up+PgUp
57
Extend a selection right a screen
Alt+Up+PgDn
58
Select All
Ctrl+A
59
Fill down from cell above
Ctrl+D
60
Fill right from cell left
Ctrl+R
61
Find and replace
Ctrl+F
62
Show all constants
F5 Alt+S O
63
Highlight cells with comments
F5 Alt S C
64
Edit the active cell
F2
65
While editing cell, allow use of arrow keys to create reference
F2
66
Confirm change and leave cell
Enter
67
Cancel cell entry and leave cell
Esc
68
Insert line break within cell
Alt+Enter
69
Highlight within a cell
Up+ arrow
70
Highlight contiguous items
Ctr+Up+arrow
71
Jump to beginning of cell
home
72
jump to end of cell
end
73
delete character to left
backspace
74
delete character to right
delete
75
accept AutoComplete suggestion
tab
76
Reference a cell from another worksheet
ctrl+PgUpArrows
77
Start a formula
=
78
Insert autosum formula
Alt+=
79
Recalculate all worksheets
F9
80
Anchor cells
F4
81
Open Insert Formula dialog
Up+F3
82
Eneter array formula
Up+Ctrl+Enter
83
Inspect cell values
F9
84
Switch to formula view
Ctrl+~
85
Select direct precedents
Ctrl+[
86
select direct dependents
Ctrl+]
87
Trace immediate precedents
Alt M P
88
Trade immediate precedents
Alt M D
89
Remove tracing arrows
Alt M A A
90
Go to last cell
F5+Enter
91
Calculate all open workbooks
F9
92
Open Excel options dialog box
ALT F O
93
Accessing data validation
Alt A V V
94
Get inside a drop-down list
Alt Up or Down
95
Insert data table
Alt A W T
96
Open sort dialog
Alt A S S
97
Autofilter selection
Alt A T
98
Insert pivot table
Alt N V
99
Insert a chart
Alt N R
100
Zoom
Alt W Q
101
Name a cell or cell range
Ctrl + F3
102
Select a column
Ctrl+Space
103
Select row
Up+Space
104
Delete rows/columns
Ctrl+ -
105
Add rows/columns
Ctrl+Up++
106
Set column width
Alt H O W
107
Autofit column width
Alt H O I
108
Fit to specific row height
ALT H O H
109
Group rows/columns
Alt + Up + right arrow
110
Ungroup rows/columns
Alt + Up + left arrow
111
Jump to next worksheet
Ctrl+PgDn
112
Jump to previous worksheet
Ctrl+PgUp
113
Change worksheet name
ALT H O R
114
Rearrange tab order
Alt H O M
115
Freeze pane
Alt W F F
116
Split screen
Alt W S
117
Toggle from tab, ribbon, task pane, status bar
F6
118
Close help
Ctrl+Space+C
119
Move to next control
Tab
120
Move from tab to tab
Ctrl+Tab
121
Move to previous contorl
Up+Tab
122
Move within a list
Arrows
123
Activate control
Alt+Underlined Ltr
124
Toggle checkboxes
Spacebar
125
Close a dialog
Esc
126
Apply change
Enter
