O'Reilly logo

Office 2013 All-In-One Absolute Beginner’s Guide by Patrice-Anne Rutledge

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

23. Creating Subtotals and Grouping Data

This chapter shows you how you can summarize and group together data using Excel’s Subtotal and grouping tools. The ability to group and subtotal data enables you to summarize a long sheet of data to fewer rows. The individual records are still there so that you can unhide them if you need to investigate a subtotal in detail.

Creating Subtotals

The easiest way to create subtotals in Excel is using the SUBTOTAL function. If you need more power or flexibility, Excel also offers a Subtotal tool. After creating your totals, you can format and sort them based on your specific requirements.

Using the SUBTOTAL Function

The SUBTOTAL ...

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