Excel Flashcards
1
Q
Add Worksheet
A
ALT I W
2
Q
Delete Worksheet
A
ALT H D S
3
Q
Move Back and Forth between worksheets
A
CTRL page up or CTRL page down
4
Q
Move Around Workbook
A
ALT
5
Q
New Workbook
A
CTRL N
6
Q
Open a File
A
CTRL O
7
Q
Save a File
A
CTRL S
8
Q
Print a File
A
CTRL P
9
Q
Use after ALT to get inside an area
A
TAB
10
Q
Select
A
Spacebar
11
Q
Opens Options
A
ALT F T
12
Q
Sum Equation
A
ALT and “+/=”
13
Q
Opens Office Button Menu
A
ALT F
14
Q
Brings up Save as
A
ALT A
15
Q
Autofit column width
A
ALT H O I
16
Q
Manually adjust column width for multiple columns
A
ALT H O W
17
Q
Highlight a column
A
CTRL and Space
18
Q
Highlight a row
A
Shift and Space
19
Q
Manually adjust rows
A
ALT H O H
20
Q
Paste Special
A
ALT E S
21
Q
New Workbook
A
CTRL N
22
Q
Move between workbooks
A
CTRL Tab
23
Q
Change Zoom level
A
ALT V Z
24
Q
Select and move
A
Shift and arrows
25
Format Cell dialogue box
CTRL 1
26
Go in
TAB
27
Go out
Shift TAB
28
Goes right to it
ALT "underlined letter"
29
Toggle Checkboxes
spacebar
30
Highlight a specific range
CTRL SHIFT Arrow keys
31
Freeze Panes
Alt WFF
32
Split Panes
Alt + WS
33
Jump from pane to pane
F6
34
Goes Backwards
Shift + F6
35
Undo
Ctrl z
36
Redo
Ctrl y
37
Enter a cell
F2
38
Exit a cell
F2
39
Clear Things
Alt HE
40
Add comments
Shift F2
41
Right Fill
Ctrl R
42
Down fill
Ctrl D
43
New row
Alt I R
44
New Column
Alt I C
45
Delete Row
Alt HDR
46
Delete column
Alt HDC
47
Paste Special
Alt ES
48
Multiply
Alt ESM
49
Subtract
Alt ESS
50
Divide
Alt ESI
51
Transpose
Alt ESE
52
Number Format
Ctrl Shift !
53
Current Format
Ctrl Shift $
54
Percentage format
Ctrl shift %
55
Date format
Ctrl shift #
56
Remove all borders
Ctrl shift _
57
Name Manager
Ctrl F3
58
New cell name
Alt N
59
Anchor Cells
F4
60
Name Worksheet
Alt HOR
61
New Worksheet
Alt HIS
62
Delete worksheet
Alt EL
63
Grouping Columns
Ctrl Spacebar
Shift Alt right arrow create group
Alt AH Hide
Alt AJ Unhide
Shift Alt Left Arrow remove group
64
Grouping Rows
Same thing just Shift spacebar at the beginning
65
Grouping worksheets
Ctrl shift
Page up or down
66
Highlight precedent cells
Ctrl Left bracket
Alt MP
67
Highlight dependent cells
Ctrl right bracket
Alt MD
68
Clear Audit
Alt MAA
69
Highlight specifics
F5 go to
Alt special
70
Create own conditional format
Alt OD
71
Conditional Formatting
Alt HL
72
Create breaks if a lot of text
Alt enter
73
Find and replace
Ctrl F
74
Print
Ctrl P
75
Data Table
Alt DT
76
Data Validation
Alt DL
