A
Abe
In Excel 2007 how do I subtotal and outline automatically like I used to do
in 2003?
in 2003?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Abe
Do I need to state this question differently?
B
Bob I
Click on the Data tab, look at the "Outline" panel.
A
Abe
In 2003, when I subtotaled, Excel automatically outlined so that if I
collapsed the outline, I see only the rows with the subtotals. How do I do
this in 2007? It seems that 2007 removed a useful tool or at the very least
made it difficult to accomplish.
collapsed the outline, I see only the rows with the subtotals. How do I do
this in 2007? It seems that 2007 removed a useful tool or at the very least
made it difficult to accomplish.
A
Abe
I apologize. It seems to do what I want in some cases and not in others. My
original list is 400 rows x 7 columns. I can do the subtotal with this but I
am not getting the automatic outline. I took a subset of this list (60 rows x
7 columns) and this time it works! What am I doing wrong with my original
list?
original list is 400 rows x 7 columns. I can do the subtotal with this but I
am not getting the automatic outline. I took a subset of this list (60 rows x
7 columns) and this time it works! What am I doing wrong with my original
list?
B
Bob I
Sorry, I don't play with it enough to tell you that. maybe you have a
error in the listing?
error in the listing?
A
Abe
Thanks for trying to help.
Bob I said:Sorry, I don't play with it enough to tell you that. maybe you have a
error in the listing?
B
Bob I
You're welcome, hope you discover what causes your issue.