Filtering Like Excel

110248Vins et alcools ChevalierSales Manager2709/01/199408/16/1994Reims59 rue de l'Abbaye
210249Toms SpezialitätenSales Representative4909/16/199408/10/1994MünsterLuisenstr. 48
310250Hanari CarnesSales Representative6009/05/199408/12/1994Rio de JaneiroRua do Paço, 67
410251Victuailles en stockSales Representative4109/05/199408/15/1994Lyon2, rue du Commerce
510252Suprêmes délicesSales Representative10509/06/199408/11/1994CharleroiBoulevard Tirou, 255
610253Hanari CarnesSales Representative10208/24/199408/16/1994Rio de JaneiroRua do Paço, 67
710254Chop-suey ChineseSales Manager5709/08/199408/23/1994BernHauptstr. 31
810255Richter SupermarktSales Representative11009/09/199408/15/1994GenèveStarenweg 5
910256Wellington ImportadoraSales Representative2709/12/199408/17/1994ResendeRua do Mercado, 12
1010257HILARIÓN-AbastosSales Representative4609/13/199408/22/1994San CristóbalCarrera 22 con Ave. Carlos Soublette #8-35

Filtered data displays only the rows that meet criteria 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.