Excel Shortcuts Flashcards
1
Q
Edit active cell
A
F2
2
Q
Go to
A
F5
3
Q
Spelling for selected range
A
F7
4
Q
Create chart
A
F11
5
Q
Insert new worksheet
A
Alt Shift F1
6
Q
Insert function
A
Shift F3
7
Q
Find
A
Shift F5
8
Q
Enter current time
A
Ctrl Shift Colon
9
Q
Enter current date
A
Ctrl semicolon
10
Q
Select all
A
Ctrl A
11
Q
Bold
A
Ctrl B
12
Q
Italicize
A
Ctrl I
13
Q
Insert hyperlink
A
Ctrl K
14
Q
Underline
A
Ctrl U
15
Q
Strike-through
A
Ctrl 5
16
Q
A
Ctrl P
17
Q
Undo
A
Ctrl Z
18
Q
Minimize workbook
A
Ctrl F9
19
Q
Maximize workbook
A
Ctrl F10
20
Q
Switch to next workbook
A
Ctrl F6
21
Q
Previous sheet
A
Ctrl PageUp
22
Q
Next sheet
A
Ctrl PageDown
23
Q
Next tab
A
Ctrl Tab
24
Q
Insert value of cell above
A
Ctrl Apostrophe
25
Apply number format
Ctrl Shift !
26
Apply currency format
Ctrl Shift $
27
Apply date format
Ctrl Shift #
28
Apply percentage format
Ctrl Shift %
29
Apply exponential format
Ctrl Shift ^
30
Apply time format
Ctrl Shift @
31
Move to the edge of the current data region in a worksheet
Ctrl arrow
32
Select column
Ctrl space
33
Select row
Shift space
