GCFLearnFree.org

This site covers more than I ever dreamed.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2013
  • Groups and Subtotals

Excel 2013

Single page view print copy

Groups and Subtotals

Challenge!

  1. Open an existing Excel workbook. If you want, you can use our Lesson 20 Practice Workbook.
  2. Try grouping a range of rows or columns together. If you are using the example, group columns D and E.
  3. Use the Show and Hide Detail buttons to hide and unhide the group.
  4. Try ungrouping the group. If you are using the example, ungroup columns D and E.
  5. Outline your worksheet using the Subtotal command. If you are using the example, outline by T-shirt size.
  6. Remove subtotaling from your worksheet.
previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.