How to filter data in Excel?


Filter is useful to get specific data from large database. Filter can be useful to narrow down the data in worksheet and allow to view only the specific records which you require.

Filter Data:

1. In order to use filter correctly, your worksheet should include a header row, which is used to identify the name of each column.

Select data which you want to filter.

Go to Home-> Sort & Filter. Select Filter. You can also use shortcut Ctrl+Shift+L.

2. A dropdown arrow will be appear in each header column. Click the dropdown arrow for the column you want to filter.

For Example, to filter data with name, click on dropdown arrow in Name column.

In filter menu, to quickly uncheck all data, clear the check box of "Select All" and then select the checkbox for the required name. Here we filter data with name Ankita.

Result: Filtered data with Ankita. Observe that filtered column dropdown arrow is changed little bit.

To Clear a Filter: To clear filter, select the dropdown from filtered column and select "Clear Filter from (Column Name)"

The filter will be cleared and all data will be displayed.


Number Filters:

Number filters are useful to filter data with specific range.

For example, we want to filter data in which Total is "Greater than 1000 and less than 1500".

1. To do this, click on dropdown in Total column, select Number Filters and the select Between…

2. In Custom Autofilter, provide value 1000 and 1500 as OK.

Result: Data is filtered in which Total values are between 1000 and 1500.

Explore More, It's Amazing…

How to sort data in Excel worksheet?


941 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>