Filter - Filtering Like Excel

Filtering Like Excel

Sample

	OrderID	Customer	Employee	Quantity	RequiredDate	ShippedDate	ShipCity	ShipAddress
1	10248	Vins et alcools Chevalier	Sales Manager	27	09/01/1994	08/16/1994	Reims	59 rue de l'Abbaye
2	10249	Toms Spezialitäten	Sales Representative	49	09/16/1994	08/10/1994	Münster	Luisenstr. 48
3	10250	Hanari Carnes	Sales Representative	60	09/05/1994	08/12/1994	Rio de Janeiro	Rua do Paço, 67
4	10251	Victuailles en stock	Sales Representative	41	09/05/1994	08/15/1994	Lyon	2, rue du Commerce
5	10252	Suprêmes délices	Sales Representative	105	09/06/1994	08/11/1994	Charleroi	Boulevard Tirou, 255
6	10253	Hanari Carnes	Sales Representative	102	08/24/1994	08/16/1994	Rio de Janeiro	Rua do Paço, 67
7	10254	Chop-suey Chinese	Sales Manager	57	09/08/1994	08/23/1994	Bern	Hauptstr. 31
8	10255	Richter Supermarkt	Sales Representative	110	09/09/1994	08/15/1994	Genève	Starenweg 5
9	10256	Wellington Importadora	Sales Representative	27	09/12/1994	08/17/1994	Resende	Rua do Mercado, 12
10	10257	HILARIÓN-Abastos	Sales Representative	46	09/13/1994	08/22/1994	San Cristóbal	Carrera 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.

Documentation