Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

More Filters

Shows commands to filter your data.

To access this command...

Choose Data - More Filters.

Office automatically recognizes predefined database ranges.

The following filtering options are available:

Standard filter

Allows you to set the filtering options.

Advanced filter

Defines an advanced filter.

Reset Filter

Removes the filter from the selected cell range. To enable this command, click inside the cell area where the filter was applied.

Hide AutoFilter

Hides the AutoFilter buttons in the selected cell range.