From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Inserting subtotals in a sorted list

Inserting subtotals in a sorted list

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Inserting subtotals in a sorted list

“

- We're looking at a worksheet called Subtotals in the workbook 12 - Data Management Features. As we scroll up and down here we can quickly see this list is sorted by Department. And you might not notice it's also sorted within that by Status. We might want to insert subtitles every time there's a change in the department. We've got lots of different departments represented in this list. Doing this manually would take quite a while. And since we've also got it sorted within that by Status we might even want to have a multi-layered set of subtitles here. We can do this efficiently with a feature called Subtotal. It's on the Data tab on the far right. You must sort the data ahead of time if you expect coherent results. So let's say this example here it's been done. Active cell can be anywhere within the data, we go to the Subtotal button, Data tab in the outline group. Every time there's a change in what department. Now often this might be Employee Name because it's the first column. If…

Contents