can i do this in excel

R

rodchar

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
 
D

Dave Peterson

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.
 
R

RagDyer

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.
 
F

FSt1

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
 
I

iliace

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