Shortcut Keys Flashcards
1
Q
Calculate
A
[F9]
2
Q
Calculate Sheet
A
[Shift][F9]
3
Q
Enter Current Date
A
[Ctrl][;]
4
Q
Enter a space / Select item or checkbox
A
[Space]
5
Q
Redo/Repeat
A
[Ctrl][Y]
6
Q
Undo
A
[Ctrl][Z]
7
Q
Copies formula into selected cells
A
[Ctrl][Enter]
8
Q
Copy
A
[Ctrl][C]
9
Q
Cut
A
[Ctrl][X]
10
Q
Paste
A
[Ctrl][V]
11
Q
Paste Values
A
[Ctrl][Alt][V]
12
Q
Enter a new line in the cell
A
[Alt][Enter]
13
Q
Repeat last Action / toggle through Absolute and relative reference
A
[F4]
14
Q
Toggles Edit / Enter Mode
A
[F2]
15
Q
Close
A
[Ctrl][F4]
16
Q
Save
A
[Ctrl][S]
17
Q
Save as
A
[F12]
18
Q
A
[Ctrl][P]
19
Q
Opens the format dialog box
A
[Ctrl][1]
20
Q
Wrap Text
A
[Shift][Ctrl][W]
21
Q
Bold
A
[Ctrl][B]
22
Q
Italics
A
[Ctrl][I]
23
Q
Underline
A
[Ctrl][U]
24
Q
Increase decimals
A
[Ctrl][,]
25
Auto Sum
[Alt][=]
26
Paste name
[F3]
27
Open the context menu
[Shift][F10]
28
Open Goto dialog box
[F5]
29
Move up one cell or item
[up]
30
Select visible cells
[Alt][;]
31
Next pane or area
[F6]
32
Enter a formula into a cell or moves to the next cell
[Enter]
33
Escape out of edit mode etc.
[Esc]
34
Help
[F1]
35
Delete cell content
[DEL]
