Filters and special filters let you ensure that only certain
rows (records) of a data range are visible.
- The Instant Filter
function quickly restricts the display
to data ranges with identical entries in a data field.
- In the Filter window, you can also
define ranges which contain the values in particular data fields.
You can use the standard filter to connect up to three conditions
with either a logical AND or a logical OR operator.
- The Special filter exceeds the three condition limitation
and allows up to a total of eight filter conditions. With special
filters you enter the conditions directly into the sheet
- If you select rows for filters and
then want to delete these, before deleting you must first click all
the rows visible after the filter individually while pressing the
Ctrl key. This action ensures that only these rows are selected and
then deleted.