Excel Shortcuts (with modded excel) Flashcards
(79 cards)
1
Q
COPY
A
CRTL + C
2
Q
PASTE
A
CRTL + V
3
Q
UNDO
A
CRTL + Z
4
Q
REDO
A
CRTL + Y
5
Q
OPEN FILE
A
CRTL + O
6
Q
NEW FILE
A
CRTL + N
7
Q
A
CRTL + P
8
Q
SAVE
A
CRTL + S
9
Q
SAVE AS
A
F12
10
Q
GO TO NEW WORKBOOK (DIF TAB)
A
CRTL + TAB
11
Q
CLOSE FILE
A
CRTL + F4
12
Q
OPEN FORMAT CELLS DIALOG
A
CRTL + 1
13
Q
BOLD
A
CRTL + B
14
Q
ITALIC
A
CRTL + I
15
Q
UNDERLINE
A
CRTL + U
16
Q
NUMBER FORMAT
A
CRTL + SHIFT + 1
17
Q
PERCENT FORMAT
A
CRTL + SHIFT + 5
18
Q
DATE FORMAT
A
CRTL + SHIFT + 3
19
Q
INCREASE FONT SIZE
A
ALT H FG
20
Q
DECREASE FONT SIZE
A
ALT H FK
21
Q
INSERT/EDIT COMMENT
A
SHIFT + F2
22
Q
INCREASE DECIMAL
A
ALT H 0
23
Q
DECREASE DECIMAL
A
ALT H 9
24
Q
INCREASE INDENT
A
ALT H 6
25
DECREASE INDENT
ALT H 5
26
CLEAR CELL DATA
DELETE
27
CLEAR CELL FORMATS
ALT H E F
28
CLEAR ALL
ALT H E A
29
OUTLINE BORDER
CRTL + SHIFT + 7
30
REMOVE BORDER
CRTL +SHIFT + -
31
LEFT BORDER
ALT H B L
32
RIGHT BORDER
ALT H B R
33
TOP BORDER
ALT H B P
34
BOTTOM BORDER
ALT H B O
35
PASTE SPECIAL FORMATS
CRTL + ALT + V T
36
PASTE SPECIAL VALUES
CRTL + ALT + V V
37
PASTE SPECIAL FORMULAS
CRTL + ALT + V F
38
PASTE SPECIAL COMMENTS
CRTL + ALT + V C
39
SHOW RIBBON ACCELERATOR KEYS
ALT
40
SHOW/HIDE RIBBON
CRTL+F1
41
MOVE ONE SCREEN LEFT
ALT + PGUP
42
MOVE ONE SCREEN RIGHT
ALT+ PGDOWN
43
GOT TO CELL A1
CRTL + HOME
44
GO TO BEGINNING OF ROW
HOME
45
OPEN THE GO TO DIALOG BOX
F5
46
FIND AND REPLACE
CRTL + F
47
HIGHLIGHT CELLS WITH COMMENTS
F5 ALT S C
48
EDIT THE ACTIVE CELL
F2
49
WHILE EDITING CELL, ALLOW USE OF ARROW KEYS TO CREATE REFERENCE
F2
50
CONFIRM CHANGE AND LEAVE CELL
ENTER
51
CANCEL CELL ENTRY AND LEAVE CELL
ESC
52
INSERT LINE BREAK WITHIN CELL
ALT + ENTER
53
JUMP TO BEGINNING OF CELL
HOME
54
JUMP TO END OF CELL
END
55
REFERENCE A CELL FROM ANOTHER WORK SHEET
CRTL + PG(UP/DN) ARROWS
56
RECALCULATE ALL WORKSHEETS
F9
57
ANCHOR CELLS
F4
58
OPEN INSERT FORMULA DIALOG
SHIFT + F3
59
ENTER ARRAY FORMULA (IN EDIT MODE)
SHIFT+CRTL+ENTER
60
INSPECT CELL VALUES
F9
61
SWITCH TO FORMULA VIEW
CRTL + ~
62
GO TO LAST CELL
F5 + ENTER
63
SELECT COLUMN
CRTL + SPACE
64
SELECT ROW
SHIFT + SPACE
65
DELETE ROW(S)/COLUMN(S)
CRTL + -
66
ADD ROW(S)/COLUMN(S)
CRTL + SHIFT + +
67
SET COLUMN WIDTH
ALT H O W
68
AUTOFIT COLUMN WIDTH
ALT H O I
69
FIT TO SPECIFIC ROW HEIGHT
ALT H O H
70
GROUP ROWS/COLUMNS
ALT+SHIFT+ ->
71
UNGROUP ROWS/COLUMNS
ALT+SHIFT+
72
JUMP TO NEXT WORKSHEET
CRTL+PGDN
73
JUMP TO PREVIOUS WORKSHEET
CRTL+PGUP
74
CHANGE WORKSHEET NAME
ALT H O R
75
REARRANGE TAB ORDER
ALT H O M
76
FREEZE PANE
ALT W F F
77
SPLIT SCREEN
ALT W S
78
CLOSE HELP (AND OTHER PANES)
CRTL + SPACE
79
Add new worksheet
SHIFT + F11
