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
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.