You can select a cell range and then "filter" the data in it using a filter condition. PlanMaker will hide all rows that do not meet this condition.
To filter data, you can choose the ribbon tab Data | group Filter to access the following four commands:
▪The command AutoFilter 
offers you different options for filtering rows: If you select a cell range and then choose this command, an arrow will be displayed from now on above each column of this cell range. If you click on one of these arrows, a menu will open with all the cell contents of this column – and various conditions by which you can filter.
▪The command Special filter 
opens a dialog box in which you can formulate one or more filter conditions. After clicking on OK, the filter is enabled: All rows in the selected range that do not meet the filter condition are hidden.
▪The command Show all 
makes all hidden rows visible again, thus eliminating the effect of both the AutoFilter and the Special filter.
▪You can use the command Reapply AutoFilter 
to also update subsequently added values in the cell range of an active AutoFilter (not possible for Special filter).
Tip: You will also find these commands on the ribbon tab Home | group Contents | Sort and filter.
For more information on AutoFilter and Special filter, see the following pages.