View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Abe[_2_] Abe[_2_] is offline
external usenet poster
 
Posts: 17
Default Subtotal and outlining

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.

"Bob I" wrote:

Click on the Data tab, look at the "Outline" panel.

Abe wrote:

Do I need to state this question differently?

"Abe" wrote:


In Excel 2007 how do I subtotal and outline automatically like I used to do
in 2003?