From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

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

Use the Subtotal feature to create outlines

Use the Subtotal feature to create outlines

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Use the Subtotal feature to create outlines

- We're looking at the worksheet called Subtotal - Outline. We've got a list of data, over 700 rows here, and we'd like to have totals by each department. Doing this manually is going to take way too much time. Fortunately, Excel has a feature on the data tab, in the far right group called Outline, Subtotal. It allows us to automatically insert subtotals based on the way the data is sorted. Right now, you can probably see, data is sorted by department. So what we'd like to be able to do, for example, is put a new row here above row 7 and show a total for the ADC department, and then since everything will get bumped down, do the same thing for Admin Training, Audit Services, and so on and so on. Fortunately, we don't have to do the manual work here, but we must have the data sorted in a coherent order for this to work properly. If we didn't sort, or if we somehow tried to do this in Column A, we'd have a subtotal row all over the place. Let's click anywhere in the data, it has been…

Contents