Outlining Data

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. 

excelguy.co.za

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.

    excelguy.co.za

    After you have done this, here is the result:

    excelguy.co.za