Lesson 10 : Excel Filter :

Lesson 10 : Filter Data :

 A filter only displays data that meet a certain criteria, those criteria may be color or  values or name

First how we can filter?

Select the columns or range of cells you want to filter, Click ‘sort &filter

Then click  ‘Filter’

After we click filter we notice  that there is a box  with an arrow in top right of selected columns

Click the arrow on the column you want to filter 

The figure shows us the methods of filter ,

* Filter by color : to filter cells according to its color

* We re-size the sheet to clarify filter process

*Text / number filter:

This enable us to filter text or number according to preset criteria Ex : equal to , greater than , less than ...etc to the end of previewed list , at the end of this list we have ’ Custom filter ‘ which is like ‘custom sort ‘ it enables you to filter data between two conditions .

*Data list : the last method is to filter data by selecting or deselecting data from the list which contains all entered data in unrepeated preview