View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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