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
|