Collapsing Cell or Row

[kalove@msn.com]

How would I do the following? Example: I have cell with the work Nutter I then have other rows with subcategory of Nutter 1, Nutter 2. I would be able to add data to the collapsable subcategory row. Is this a pivot table. Begginner

 

[RichardS]

Not sure exactly what you're after, but have a look at Sub-Total in the help file.

Richard

 

[kalove@msn.com]

No. A subtotal is not what I am after. It is actually a row of cells below a heading. I would be able to hide this row of cells (collapse) then open the row of cells when I want to edit them or read them.

 

[Jim North]

You will need to set the row height to 0 to hide them, and restore the the height to unhide them.