Share this Page URL

Hour 22. Working with Your Database > Using Advanced AutoFilter Functions - Pg. 374

Working with Your Database 374 Collapsing and Expanding a Subtotaled Database You might want to hide some of the subtotal information in your database. You can do so by col- lapsing the subtotals. To collapse a subtotaled database, click the minus sign (­) button on the left side of the worksheet. Figure 22.4 shows two collapsed subtotals in the database. A plus sign (+) button appears in each subtotal row you collapsed. Figure 22.4. Collapsed subtotals in the database. To display the hidden subtotals in your database, you can expand the subtotals by clicking each plus sign button on the left side of your worksheet. Excel displays the subtotals you expanded. Excel displays a minus sign button in each subtotal row you expanded. Removing Subtotals What if you no longer want the subtotals in your database? You can easily dispose of them by removing them from the worksheet. To do so, click any cell in the database, and choose Data, Subtotal. In the Subtotal dialog box, click the Remove All button. The dialog box closes and Excel removes the subtotals from your database. Go ahead and remove the subtotals from your database. Using Advanced AutoFilter Functions In Hour 21, you learn about filtering data with Excel's nifty AutoFilter feature. This session takes that discussion one step further and talks about using advanced AutoFilter functions, such as extracting filtered data, and using the Top 10 AutoFilter and Custom AutoFilter options. After you filter your records to display specific data in your database, you can extract that data by copying it to another worksheet or workbook. It's simple to do--just use the Copy and Paste tools to place the filtered data somewhere else.