A method of data hiding by using the combination function of Excel

a method of data hiding by using the combination function of Excel

One, the effect demonstration:

Original table:

Set up a combination

Point "-" Hide revenue details

Point number 1 Hide all details (point 2 shows all levels 2 detail)

Second, set up the method

Select the Revenue Detail section-data-create groups, fees, and other project settings with operating income.

Click on the toolbar small arrow, open the Group Settings window, remove the first option check.

Can it be done in a single lump?

Yes, if there is a sum formula in the first row that references the line of detail. Data-Create groups-automatically create an outline. You can complete all the combinations at once.