Skip to Main Content
Office 2013 All-In-One Absolute Beginner’s Guide
book

Office 2013 All-In-One Absolute Beginner’s Guide

by Patrice-Anne Rutledge
August 2013
Beginner content levelBeginner
704 pages
18h 22m
English
Que
Content preview from Office 2013 All-In-One Absolute Beginner’s Guide

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg
Office 2013: The Missing Manual

Office 2013: The Missing Manual

Nancy Conner, Matthew MacDonald

Publisher Resources

ISBN: 9780133391541Purchase book