How to ungroup and remove subtotals in HRPro Excel Report

Some of the reports in HRPro utilize Excel’s grouping and subtotal functions to generate subtotals.

However, if you wish to ungroup and remove the subtotals, you can:

Clear Outline

1. Select Grouped Data: Click on any cell within the grouped rows or columns.

2. Navigate to the Data Tab: Go to the top of the Excel window and click on the “Data” tab.

3. Click “Clear Outline”: In the “Outline” section, click the “Clear Outline” button. 

Removing Subtotals

1. Select the Data Range: Highlight the range of cells that contains the subtotals.

2. Go to the Data Tab: Click on the “Data” tab at the top of the Excel window.

3. Click on Subtotal: In the “Outline” group, click on the “Subtotal” button.

4. Remove All: In the Subtotal dialog box, click on the “Remove All” button.

This will remove all the subtotals from your data.

The result