O'Reilly logo

My Excel 2016 by Tracy Syrstad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

13. Inserting Subtotals and Grouping Data

Image

This chapter shows you how data can be summarized and grouped together using Excel’s Subtotal and grouping tools. Topics include the following:

Manually entering subtotal rows using the SUBTOTAL function

Automatically summarizing data using the Subtotal tool

Copying just the subtotals to a new sheet

Grouping information so you can quickly show or hide data

The ability to group and subtotal data allows you to summarize a long sheet of data into fewer rows. The individual records are still there, so you can unhide them if you need to investigate a subtotal in detail.

Using the SUBTOTAL Function ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required