Course Name: Introduction to IT Lab
Topic: MS-Excel (Filter)
L EC T UR ER: E N G. I S R AA A LQATOW
DEPARTMENT OF I NFORMATION TECHNOLOGY
OBJECTIVES
Use AutoFilter or built-in comparison operators like "greater than" and
“top 10” in Excel to show the data you want and hide the rest.
Once you filter data in a range of cells or table, you can either reapply a
filter to get up-to-date results, or clear a filter to redisplay all of the data.
Filter Data
Use filters to temporarily hide some of the
data in a table, so you can focus on the
data you want to see.
Filter a range of data
1- Select any cell within the range.
2- Select Data > Filter.
3- Select the column header arrow.
Filter a range of data
4- Select Text Filters or Number Filters, and then select a comparison,
like Between.
You can search about an
item in your sheet using
the Windows search
command i.e. using (*,?)
Filter a range of data
5- Custom Filter -> Enter the filter criteria and select OK.
Filter data in a table
When you put your data in a table, filter controls are automatically
added to the table headers.
Filter data in a table
1- Select the column header arrow for the column you want to
filter.
2- Uncheck (Select All) and select the boxes you
want to show.
3-Click OK.
The column header arrow changes to
Filter icon. Select this icon to change or
clear the filter.
