Outlining data makes your data easier to view. In this example we will total rows of related data and collapse a group of columns. We will be using the “Company” data column.
See screenshot below on the steps.
- You first need to sort the “Company” column.
- Go to the DATA tab in the OUTLINE group and select the SUBTOTAL icon.
- Select the COMPANY column
- Use the COUNT function
- Check the COMPANY checkbox and click OK.
After you have done this, here is the result: