You can select a range of cells and filter this data based on a filtering condition. PlanMaker will hide all rows that do not match the condition.
There are four commands for filtering data available on the ribbon tab Data | group Filter:
▪The command AutoFilter 
offers you different options to filter rows: When you select a cell range and choose this command, from now on, an arrow will appear on top of each column in this cell range. Clicking on one of these arrows opens a menu where you can easily choose between the values contained in the corresponding column – and other predefined filter conditions.
▪The command Special filter 
opens a dialog box where you can formulate one or more filter conditions. After clicking OK, the filter activates and hides all rows in the selected cell range that do not match the chosen filter conditions.
▪The command Show all 
makes all hidden rows visible again, rendering the effect of the Special filter as well as the AutoFilter inactive.
▪The command Reapply filter 
allows you to update also subsequently added values in the cell range of an active AutoFilter (not possible for Special filter).
| Tip: You will also find the commands on the ribbon tab Home | group Contents | Sort and filter. |
The following pages provide detailed information on these commands.