View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default can i do this in excel

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