Outlining Data

Use outlines in Excel to help organize your data into groups and summarize data for easier analysis.


  1. Open an existing Excel 2010 workbook. If you want, you can use this example.
  2. Outline your worksheet using the Subtotal command. If you are using the example, outline by T-shirt size.
  3. Display the first level of groups in your outline.
  4. Display the highest level to view your entire worksheet again.
  5. Create your own group of rows or columns, then hide the group from view.
  6. Ungroup any range of data.
  7. Remove subtotaling from your worksheet.