can i do this in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all,
Food $8.83
Click to expand...
Restaurants $6.58
Grocery $2.25

Food is the major category and the following lines are sub-categories
(Restaurants and Grocery).
The sub-categories amounts will total on the Food line.

Is there a way to display this as the Food category being collapsable?

thanks,
rodchar
 
Maybe...

You may be able to use data|group and outline

You may be able to use data|subtotals if your data is sorted right.

Or maybe you could use data|filter to show just what you need.

I guess it depends.
 
Go to:
<Data> <Group & Outline> <Settings>
And *UNCHECK*
"Summary Rows Below Detail"

Now, when you group your rows, the summary (totals) row will be on top of
the group.
 
hi,
About the only way you might be able to do this is hide/unhide rows but you
haven't given enough info to make that recomedation. You could attach a small
macro to a command button on the sheet next to food or have the button's
caption say food. clicking the button once would unhide, clicking it again
would hide.
my thoughts.

regards
FSt1
 
Try a pivot table. You'd have to structure your data appropriately,
and the collapsibility will be implemented separately from data.
 
Back
Top