IBM Lotus Symphony
|
The Instant Filter function inserts a combo box on one or more data columns that lets you select the records (rows) to be displayed.
Select the columns you want to use Instant Filter on.
Choose Data - Filter - Instant Filter. The combo box arrows are visible in the first row of the range selected.
Run the filter by clicking the drop-down arrow in the column heading and choosing an item.
Only those rows whose contents meet the filter criteria are displayed. The other rows are filtered. You can see if rows have been filtered from the discontinuous row numbers. The column that has been used for the filter is identified by a different color for the arrow button.
You can instantly sort the data by selecting -Sort Ascending- or -Sort Descending- in the Instant Filter combo box. The -Sort Ascending- or -Sort Descending- operation has effect on all the data in the column, but only the filtered data is displayed.
When you select a filter option in another column of a filtered data range, the other combo box list only the filtered data.
To display all records again, select the -(All)- entry in the Instant Filter combo box. If you choose -(Standard Filter...)-, the Standard Filter dialog appears, allowing you to set up a standard filter. Choose -(Top 10)- to display the highest 10 values only.
To stop using Instant Filter, reselect all cells selected in step 1 and once again choose Data - Filter - Instant Filter.
![]() |
To assign different instant filters to different sheets, you must first define a range on each sheet. |
![]() |
The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the SUBTOTAL function if only the cells visible after the application of a filter are to be taken into account. |