View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CheekyChappie CheekyChappie is offline
external usenet poster
 
Posts: 2
Default expanding results

I have a list of data which sums up to make the total. What I want to do is
hide the detail, but show it if someone clicks on the total.

For example, I have Product 1, product 2 and product 3 listed with their
sales next to them.

The top row is TOTAL SALES and has their combined total. I want to be able
to hide the product detail, but click on the TOTAL SALES cell to expand and
then contract the data - can this be done?