Filter		Advanced Filter		Pivot Table		Group and Outline		Data Validation		Name Manager
Goal Seek		Freeze Panes		Split Screen		Conditional Formatting		Text to Columns

Apply Filter

We use filter when we need to extract specific records from a set of Data
Remember, Filter does not sort or delete the data , it only hides the rows that does not meet filter criteria

Custom Filter
Custom Auto Filter dialog box
To filter by two conditions, enter filtering conditions in both sets of boxes, and pick And for both conditions to be true, and Or for either of the conditions to be true.
Filter items by color , This feature is available on version greater than 2007

Clear Filter To clear the filter, simply click Clear in the Sort & Filter group.

  [Alt]+D+F+F or    [Ctrl]+[Shift]+L