You people are utterly amazing. I use and recommend you all the time!”

Online Learner

Creating Opportunities For A Better Life.®

Excel 2010

Single page view print copy

Outlining Data

Challenge!

  1. Open an existing Excel 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.
1 2 3 4 5 6