Hey all,

> Food $8.83
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.

rodchar wrote:
>
> Hey all,
>
> > Food $8.83
> 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

--

Dave Peterson

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rodchar" <(E-Mail Removed)> wrote in message
news:BE864542-1092-4314-B03C-(E-Mail Removed)...
> Hey all,
>
>> Food $8.83
> 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

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

"rodchar" wrote:

> Hey all,
>
> > Food $8.83
> 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

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

On Sep 10, 7:46 pm, rodchar <rodc...@discussions.microsoft.com> wrote:
> Hey all,
>
> > Food $8.83
>
> 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