How to filter data in Excel

Your Excel spreadsheet has a lot of data, so it's easy to process and search the data in your table. Filter data by conditions, the criteria you give, you will shorten the search time and the data processing will also be significantly faster.

How to filter data in Excel Picture 1

The following article will guide how to filter data in an Excel table:

When you create a table in Excel, on the column headings in the table will automatically add filter controls.

How to filter data in Excel Picture 2

Filter fast

Step 1: You choose the triangle icon in the column header to filter data.

How to filter data in Excel Picture 3

Step 2: In the dialog box that appears, uncheck the box before Select All . Next you want to filter the data by which item in the column you tick the square before that data. Then click OK .

How to filter data in Excel Picture 4

The result will filter all the data as you choose, and the title of the filtered column will appear as a filter icon.

How to filter data in Excel Picture 5

To remove the filter, select the filter icon at the top of the column header and select -> Clear Filter From "column heading".

How to filter data in Excel Picture 6

Filter by specific text or number

Step 1: Select the triangle icon in the cell where you want to filter the data.

Step 2: If the data column contains text to filter, you select Text Filters , if the data column contains numbers to filter, select Number Filters . Then select Custom Filter .

How to filter data in Excel Picture 7

Step 3: In the dialog box Custom AutoFilter , you enter the filter condition if there are 2 filter conditions you enter both conditions into the data cells. Choose the relationship between And and Or conditions to match the filter condition. Then click OK .

Example: Filter data provided that Total Wage is greater than or equal to 5600.

How to filter data in Excel Picture 8

Results after filtering:

How to filter data in Excel Picture 9

Filter items by color

If during the process of entering data in the table, you marked the data cells with different colors. You can filter data by the following colors:

Step 1: Select the filter icon in the header cell of the color-formatted column.

Step 2: Select Filter by Color then select the color you want to filter.

How to filter data in Excel Picture 10

Results after you filter by color:

How to filter data in Excel Picture 11

Also in Excel 2013 you can create slicers to filter your table data.

Step 1: You select any cell in the table, select the Design tab of Table Tools -> Insert Slicer .

How to filter data in Excel Picture 12

Step 2: Next in the dialog box Insert Slicers you select the columns to filter data and click OK .

How to filter data in Excel Picture 13

Step 3: The dialog box containing the column you selected above appears, you select the data in the dialog boxes (if you select multiple columns to filter). Hold down Ctrl to select multiple data in a column. Thus the data in the table will quickly be filtered according to your requests.

How to filter data in Excel Picture 14

With the ways of filtering data in the above Excel table, managing the data in your tables will no longer be complicated. Good luck!