Excel Shortcuts Flashcards
(49 cards)
1
Q
Paste
A
Ctrl+V
2
Q
Paste special
A
Ctrl Alt V
3
Q
Copy special
A
Ctrl+C
4
Q
Cut
A
Ctrl+X
5
Q
Copy the format right in a range
A
Ctrl+R
6
Q
Copy the format down in a range
A
Ctrl+D
7
Q
Make absolute reference
A
F4
8
Q
Sum rows
A
Alt+=
9
Q
Insert or Modify comment
A
Shift+F2
10
Q
Undo last action
A
Ctrl+Z
11
Q
Redo last action
A
Ctrl+Y
12
Q
Save
A
Ctrl+S
13
Q
Find
A
Ctrl+F
14
Q
Select and show cell A1
A
Ctrl+Home
15
Q
Select last used cell
A
Ctrl+End
16
Q
Select range
A
Shift+Arrow
17
Q
Replace
A
Ctrl+H
18
Q
Select columns
A
Ctrl+Space
19
Q
Select rows
A
Shift+Space
20
Q
Select all surrounding cells
A
Ctrl+A
21
Q
Format cells dialogue
A
Ctrl+1 (control tab to move between tabs)
22
Q
General number format
A
Ctrl+shift+~
23
Q
Accounting Format
A
Ctrl+shift+!
24
Q
Currency format
A
Ctrl+ shift +$
25
Italic
Ctrl+I
26
Underline
Ctrl+U
27
Bold
Ctrl+B
28
Percentage format
Ctrl+Shift+%
29
Insert time
Ctrl+:
30
Delete cell/range/row/column
Ctrl+-
31
Insert table
Ctrl+T
32
Insert cell/range/row/column
Ctrl+Shift++
33
Insert date
Ctrl+;
34
Move to right sheet
Ctrl+Page Down
35
Move to left sheet
Ctrl+Page Up
36
Open contextual menu (right-click)
Shift+F10
37
Move to edge of data region
Ctrl+Arrow
38
Open 'Go To' dialog
Ctrl+G
39
Spellcheck
F7
40
Show cell content and edit cell
F2
41
Hide or show ribbon
Ctrl+F1 (or double click something on ribbon)
42
Lock computer
Window+L
43
Show desktop
Window+D
44
Open this list of keyboard shortcuts
Ctrl+Alt+Q
45
Type in new line within same cell
Alt+Enter
46
Show shortcuts on ribbon
Alt+H
47
Highlight precendents (input cells)
Ctrl+[
48
Highlight antecendents (dependent cells)
Ctrl+]
49
Toggle filter on/off
Ctrl+Shift+L
