From Wikipedia, the free encyclopedia
Tables on the right are autocollapse
.
Collapse column B only
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Collapse column B only
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Collapse row 2 only
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Collapse row 2 only
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Do not collapse row 3
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Do not collapse row 3
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Collapse column B and row 2, cell B2 is double-collapsible
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Collapse column B and row 2, cell B2 is double-collapsible
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Do not collapse first column
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Do not collapse first column
|
Col A |
Col B |
Col C
|
Row 1
|
Data A1 |
Data B1 |
Data C1
|
Row 2
|
Data A2 |
Data B2 |
Data C2
|
Row 3
|
Data A3 |
Data B3 |
Data C3
|
Example 1a
|
Male |
Female |
All
|
Left-handed
|
10 |
15 |
25
|
Right-handed
|
35 |
40 |
75
|
Sum
|
45 |
55 |
100
|
Example 1b
|
Male |
Female |
All
|
Left-handed
|
22% |
27% |
25%
|
Right-handed
|
78% |
73% |
75%
|
Subjects
|
45% |
55% |
100%
|