Software Search, Categories and Specials

 OzGrid.com HOME

Filter Assistant for Microsoft Excel $24.95 Payment Problems?

Buy individually or as part of the Analysis Collection for Microsoft Excel and save! Over 70%by buying 27time saving add-ins and 3downloadable books!

The Filter Assistantfor Microsoft Excel makes filtering data easy! And, it eliminates many of the annoying features of Excel's data filter feature. With the Filter Assistant�, all you do to filter data is to select the cells containing the values you want filtered and just click on the button on the Filter Assistant� toolbar. Instantly, your data is filtered so that only those matching rows are displayed!

You can filter multiple columns at a time.  Just click on the first cell whose value will be used as a filter.  Then, hold the Control key down and click on other cells in other columns.  When you then click on the Filter Assistant toolbar button, all the columns are filtered based on the cells you selected!

One of the nice features of the Filter Assistant is that the screen does not "jump" when you filter it.

Another very useful feature is the "Un-filter" capability of the Filter Assistant�.  If you select a cell in filtered column and click on the Filter Assistant� button, the column will be un-filtered.  And, if you select a cell in the top row of an un-filtered column and click the button, this turns off data filtering.