Excel Subtotal groupings
 

I am using 1997-2003 version of Excel

When using the subtotal on a spreadsheet and when the subtotals are shown,
the spreadsheet does not list the groupings on it. The groupings are 1 which
shows all the information, 2 which shows just the subtotal and grand total,
then 3 just shows the grand total. This has shown up on other company PC's
that I have used in the past.

Would appreciate any help that can be offered.

Excel Subtotal groupings
 

Maybe you're not showing the outlining symbols:

In xl2003 menus:
tools|Options|view|check "Outline Symbols"



Quana wrote:

I am using 1997-2003 version of Excel

When using the subtotal on a spreadsheet and when the subtotals are shown,
the spreadsheet does not list the groupings on it. The groupings are 1 which
shows all the information, 2 which shows just the subtotal and grand total,
then 3 just shows the grand total. This has shown up on other company PC's
that I have used in the past.

Would appreciate any help that can be offered.

--

Dave Peterson