Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i do this in excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i do this in excel
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" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i do this in excel
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
can i do this in excel
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|