Excel1 Flashcards
1
Q
Alt+ =
A
Sum function
2
Q
Alt + H + D + C
A
Delete column
3
Q
Alt + W + F + R
A
Freeze top row
4
Q
Alt + H + D + C
A
Delete column
5
Q
Ctrl + Shift + “+”
A
Add rows
6
Q
Alt + M
A
Formula show them
7
Q
Alt + M + V
A
Evaluate Formula
8
Q
Ctrl + “-“
A
Delete rows
9
Q
AH + H + B + H
A
Thick bottom border
10
Q
Alt + H + B + A
A
All border
11
Q
Shift + F11
A
Insert new sheet
12
Q
Alt + H + FD + S + Y + Enter
A
Go to visible cells only
13
Q
Alt + E + L + Enter
A
Delete sheet
14
Q
Windows + T
A
Go to tool bar
15
Q
Windows + ^
A
Expand window
16
Q
Alt + w + VG
A
Clear grid lines
17
Q
Alt + H + FD
A
Find and replace
18
Q
Alt + A + SS
A
Bring up sort dialogue box
19
Q
Alt + H + B + O
A
Bottom border
20
Q
Alt + =
A
Sum function
21
Q
F3
A
Paste names
22
Q
Alt + R + S
A
Spell check
23
Q
Ctrl + ‘
A
Formulas numbers
24
Q
Ctrl + ;
A
Date
25
F12
Save as dialogue box
26
Ctrl + F4
Close workbook
27
Alt + JY + P + T
Show pivot table in tabular form
28
Ctrl + W
Close workbook
29
Alt + H + H
Fill
30
Alt + H + FC
Font color
31
F5
Go to
32
Alt + + E + S + A + Enter
Pastes formatting and content
33
Alt + E + S + F + Enter
Paste only formulas
34
Alt + E + S + V + Enter
Paste only values
35
Alt + E + S + T + Enter
Pastes only formatting
36
Alt + H
Home
37
Alt + A
Data
38
Alt + W
View
39
Alt + P
Page layout
40
Alt + R
Review
41
Alt + W + I
Page break preview
42
Alt + W + L
Normal page
43
Alt + H + E + A
Clear all
44
Ctrl + [
Show cell directly referenced in formula
45
F2
Go inside cell
46
Esc + FN
Change function key
47
Alt + A + C
Clear filters
48
Alt + W + F + R
Freeze top row
49
Alt + A + T
Toggle filters
50
Alt + W + F + R
Freeze top row
51
Alt + H + D + C
Delete column
