10. Subtotals and Grouping

In This Chapter

• Manually enter subtotal rows using the SUBTOTAL function.

• Automatically summarize data using the Subtotal tool.

• Copy just the subtotals to a new sheet.

• Group information so you can quickly show or hide data.

This chapter shows you how data can be summarized and grouped together using Excel’s Subtotal and grouping tools. The ability to group and subtotal data allows 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.

Using the SUBTOTAL Function

The SUBTOTAL function calculates a column of numbers based on the code used in the function. With the correct code, SUBTOTAL can calculate ...

Get Excel® 2013 Absolute Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.