Filtered data displays only the rows that meet criteria (or "Conditions you specify to limit which records
are included in the result set of a query or filter") that you specify and hides rows that you do not want
displayed. After you filter data, you can copy, find, edit, format, chart, and print the subset of filtered data
without rearranging or moving it.
You can also filter by more than one column.
Filters are additive, which means that each additional filter is based on the current filter and further reduces
the subset of data.
Use to filter through only those records of a database that meet specific criteria, such as asking the tool to
retrieve only those records that begin with the letter "S". (use
How to filter
Select Data > Sort & Filter > Filter from the ribbon.
The filter will be applied to the column headings
(which define the data in the rows below the heading row.
Using the Drop Down filter menu, select the entry that you wish to filter for (the result will hide all by the
rows that include the filter term). It will either look down the column and filter for the argument-attribute
it finds, or will allow you to create a custom filter for argument-attributes you define.
The same is true in Excel for Mac
You can also create Custom filters (to do Boolean searches, for example). A dialog box will appear.
If the argument-attributes in the column are text, the filter will be a text filter. If they are numerical,
the filter will be a number filter.
Use the drop down menus (or type in) the filter you want.
Use filters to arrange data for charting or printing
Once you have filtered, you can create a chart based only on the displayed data. When you print, only the
displayed rows will appear in the printed version (because the other rows are hidden). Should you choose to do
additional formatting after having filtered, formatting commands will only affect the visible cells.