FIA Quiz 1 Flashcards
1
Q
Trace Precedents
A
Ctrl + [
2
Q
Trace Dependents
A
Ctrl + ]
3
Q
Format Painter
A
Alt + H + FP
4
Q
Bottom Border
A
ALT HBO
5
Q
Top Border
A
ALT HBP
6
Q
Left Border
A
ALT HBL
7
Q
Right Border
A
ALT HBR
8
Q
No Borders
A
ALT HBN
9
Q
All Borders
A
ALT HBA
10
Q
Outside Border (thin)
A
ALT HBS
11
Q
Thick outside border
A
ALT HBT
12
Q
Top & bottom border
A
ALT HBD
13
Q
Bottom Double border
A
ALT HBB
14
Q
Thick bottom border
A
ALT HBH
15
Q
Top and thick bottom border
A
ALT HBD
16
Q
Top and double bottom border
A
ALT HBU
17
Q
Select color to fill cell
A
ALT H H choose colors with arrows
18
Q
Clear color from cel
A
ALT H H N
19
Q
Set font color to black
A
ALT H FC Enter
20
Q
Select font color
A
ALT H FC choose colors with arrows
21
Q
Align text in top of cell
A
ALT H A T
22
Q
Align text in middle of cell
A
alt H A M
23
Q
Align text in bottom of cell
A
alt H A B
24
Q
Left align text
A
alt H A L
25
Center align text
alt H A C
26
Right align text
alt H A R
27
Increase indent
alt H 6
28
Decrease indent
alt H 5
29
Wrap text
alt H W
30
Merge and center
alt H M C
31
Merge across
alt H M A
32
Merge cells
alt H M M
33
Unmerge cells
alt H M U
34
Set row height (to specific #)
alt H O H
35
Autofit row height
alt H O A
36
Set column width (to specific number)
alt H O W
37
Autofit column width
alt H O I
38
Default column width
alt H O D
39
select entire row
shift + space
40
select entire column
control + space
41
add column or row (once selected)
control + shift + "+/= button"
42
delete column or row (once selected)
control + "-/_ button"
