Auto Filter

Auto filters are a nice way to only show a portion of data that meet a certain criteria. It has the same effect as manually hiding selected rows. Let's say you had a table with 3 columns, sales rep name, region, and sales dollars. If you insert auto filters by selecting Autofilter from the Data/filter menu, Excel will create drop down boxes on each header. Thus, you could click the region header, and a drop down would allow you to specify which region to show. It would hide all rows that are not in the selected region. Additionally, if you wanted to total the sales dollars for all sales reps shown, you could use the "subtotal()" function as discussed above and the function will only include rows that are shown. The "sum()" function would include all rows, both hidden and unhidden, in the total.

Watch Auto-Filter Video

Auto Filter