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
