From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Expand/collapse or sort displayed results when using the SUBTOTAL command

Expand/collapse or sort displayed results when using the SUBTOTAL command - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Expand/collapse or sort displayed results when using the SUBTOTAL command

“

- [Instructor] A valuable analytical tool in Excel 2 is called subtotal and it's got one major limitation. 3 On this worksheet that we're seeing here 4 it's about 700 rows or so, and it is sorted by department 5 and within that by status. 6 We'd like to insert a new row 7 every time there's a department change. 8 For example, right in row 7 here 9 after we've come to the end of ADC 10 and show some totals for the numerical fields. 11 Got about 20, 25 departments here. 12 Doing that manually is unthinkable. 13 Now this is a valuable tool, 14 but like way of comparison 15 the next worksheet over the same data 16 has been converted into a table. 17 And if you wanted to use subtotal here, 18 when you go to the data tab off to the right, 19 you'll see that it is not selectable. 20 And the reason it is is because this is a table. 21 Now you can't always tell a table by appearance, 22 but usually when you see banded rows…

Contents