View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daniel R Daniel R is offline
external usenet poster
 
Posts: 6
Default auto hiding rows under category heading unless cursor clicks on to

How do I make it so that rows of data under the heading row will "scroll" up
and "disappear" unless the cursor clicks on the cell the heading is in, much
like a drop down box, but with the whole row. Cells within the "disappearing
rows" are editable, and I want them to stay displayed if any data in them is
changed....