How do I get the "subtotal" columns in XL in Office '07?

S

Steve

In older versions of XL (and sometimes in 2007), you could get those
"subtotal" trees or columns to the left of a spreadsheet. By clicking on the
+ and -, you could expand or contract the spreadsheet from detail level to
subtotal level.

How do you do that in 2007?
 
F

Fred Smith

It works for me when I use Data>Subtotal. Why happens when you try it?

Regards,
Fred.
 
S

Steve

Fred, Thanks for responding...

It sometimes works for me when I use that function as well. But sometimes
those "trees" don't appear, and I'm not sure why...

Thanks,

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use the subtotal function while a worksheet is protected? 0
Macro Pause to Select range then Subtotal 0
How do I add a break after each subtotal? 1
nested subtotal with sumproduct 0
How do I subtotal specific / random rows from a spreadsheet? 1
Excel 2007 5
Subtotal Sidebar query 2
how do I delete hidden rows or columns without doing it manually? 1

Top