G
Guest
Excel 2002 SP3
User has four rows of data and the first two are general numbers. Many of
these numbers have several leading zeros. When we do a subtotal, there are
four levels. The problem is the first two rows, which are correctly
subtotaled in most respects. However, they will not collapse down until
level 2. All the other rows below (about 125 of them) collapse down at level
3, which leaves those first two rows of data with all four columns of data
revealed. The subsequent rows only show the "cell name" TOTAL in bold and
the dollar value.
I cannot find any way to get these first two rows of data to collapse down.
I'm not sure I have this explained very well. 2+ hours of frustration with
this document is showing I'm afraid.
We can say that the first two rows show all four columns of data while the
rest only show the 1st and 4th column. We cannot find a way to collapse
these first two rows.
User has four rows of data and the first two are general numbers. Many of
these numbers have several leading zeros. When we do a subtotal, there are
four levels. The problem is the first two rows, which are correctly
subtotaled in most respects. However, they will not collapse down until
level 2. All the other rows below (about 125 of them) collapse down at level
3, which leaves those first two rows of data with all four columns of data
revealed. The subsequent rows only show the "cell name" TOTAL in bold and
the dollar value.
I cannot find any way to get these first two rows of data to collapse down.
I'm not sure I have this explained very well. 2+ hours of frustration with
this document is showing I'm afraid.
We can say that the first two rows show all four columns of data while the
rest only show the 1st and 4th column. We cannot find a way to collapse
these first two rows.