Hi,

This is also what pivot table often do and they are much more powerful and
flexible than the Data, Subtotal command once you learn them. For example to
expand and collapse the data under a particular category just double click
the category row and all the detail is shown or hidden.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"office wreck!" wrote:

I need to expand and collapse ROWS, I want main info seen and rows below it
collapsed so I can expand as needed, How do i do that?? i keep trying but
it's not working out very well!