Excel Hot Keys Flashcards
(52 cards)
1
Q
New file
A
Ctrl + N
2
Q
Open file
A
Ctrl + O
3
Q
Save file
A
Ctrl + S
4
Q
Close file
A
Ctrl + F4
5
Q
Save as
A
F12
6
Q
Exit Excel
A
Alt + F4
7
Q
A
Ctrl + P
8
Q
Edit active cell
A
F2
9
Q
Cancel cell editing
A
Escape Key
10
Q
Cut
A
Ctrl + X
11
Q
Copy
A
Ctrl + C
12
Q
Paste
A
Ctrl + V
13
Q
Copy right
A
Ctrl + R
14
Q
Copy down
A
Ctrl + D
15
Q
Create cell comment
A
Shift +F2
16
Q
Format cells
A
Ctrl + 1
17
Q
Format currency
A
Ctrl + Shift + 4
18
Q
Format as date
A
Ctrl + Shift + 3
19
Q
Format as percentage
A
Ctrl + Shift + 5
20
Q
Format as number
A
Ctrl + Shift + 1
21
Q
Bold
A
Ctrl + B
22
Q
Italicize
A
Ctrl + I
23
Q
Underline
A
Ctrl + U
24
Q
Strikethrough
A
Ctrl + 5
25
Add cell borders
Ctrl + Shift + 7
26
Remove all borders
Ctrl + Shift + - ( minus)
27
Select entire worksheet
Ctrl + A
28
Select group area
Ctrl + Shift + 8
29
Select column
Ctrl + Space
30
Select row
Ctrl + Spacebar
31
Select Manually
Hold Shift + Left, Right, Up, Down Arrow Key
32
Up one screen
Page Up
33
Down one screen
Page Down
34
Move to next worksheet
Ctrl + Page Down
35
Move to previous worksheet
Ctrl + Page Up
36
Go to first cell in worksheet area
Ctrl + Home
37
Go to last cell in worksheet area
Ctrl + End
38
Go to formula source
Ctrl + {
39
Go to a cell
F5
40
Find text
Ctrl + F
41
Replace text
Ctrl + H
42
Undo last action
Ctrl + Z
43
Redo last action
Ctrl + Y
44
Create a chart
F11
45
Spell check
F7
46
Show all formulas
Ctrl + ~
47
Insert columns/rows
Ctrl + Shift + + (plus sign)
48
Insert a new worksheet
Ctrl + F11
49
Move between open workbooks
Ctrl + F6
50
Autosum
Alt + = (equals sign)
51
Merge Cells
Sequence: Ctrl + 1 , A , Alt +M
52
Autofit Column Width
Alt, H, O, I
