Data Filtering – Single and Multiple Filters in Excel

DATA FILTERING IN MICROSOFT EXCEL 2013

Data filtering is a fast and easy approach of sorting work with a portion of data so that you are able to display only the rows in your spreadsheet that meets your standard. This can involve rows that have specific numbers or text that are more than or less than a particular number that you have specific about. Filtering will hide these rows that do not meet your criteria temporarily; this put up with you to see only the information that you are interested in. All that you have to do to filter given data is to format the filtering and tag the items that you wish to visualize, everything else will be isolated.

If a spreadsheet is containing a lot of data, it will be difficult to find information fast.

Filters can be used to contract for the information in your spreadsheet, allowing you to be able to view only the information that is relevant to you.

To start Data Filtering:

We need to know how to apply data filtering in Ms-Excel in the example below, we will learn how to apply data filtering in Microsoft Excel.

  1. In order for filtering to work perfectly, your worksheet should have a Header row, which is used to know the title of each column. The worksheet below is arranged into different columns identified by the header cells in row 1

Data Filtering in Excel

  1. choose the data tab, then left click on the filter

Data Filtering in Excel

  1. A pull-down menu will appear in the header cell for each vertical section
  2. Click the pull-down menu for the column you wish to filter “column B” to view only certain types of equipment. Data Filtering in Excel
  3. The filtering option will appear
  4. Uncheck the box next to select all to immediately deselect all information

Data Filtering in Excel

  1. Check the box next to the data you desire to filter, click ok. Data Filtering in Excel
  2. The information will be filtered, hiding any content that does not fit the criteria. Data Filtering in Excel

Data Filtering can also be accessed in the sort & filter option

HOW TO APPLY MULTIPLE FILTERS

A Filter is cumulative, this implies that you can apply multiple filters to help find your result.

  1. Left click on the arrow for the column you wish to filter. Data Filtering in Excel
  2. The filter option will appear
  3. Check or uncheck any box depending on the data you wish to filter, then click ok.

Data Filtering in Excel

  1. Filtering will be applied. In the example below, the spreadsheet is now filtered to show only laptops and tablets that were cop-out in August Data Filtering in Excel

TO CLEAR A FILTER:

After filtering has been done, you might want to change or do away with the filtering. Clearing can also be done by following the steps below:

  1. Click the drop-down menu for the filter you wish to clear. In the example below, we will clear the filter in column D Data Filtering in Excel
  2. The filter menu will show up.
  3. Select “clear filter” from the filter menu. Data Filtering in Excel
  4. The filter will be removed from the column. The former hidden information will be visible.

Data Filtering in Excel

Filtering is a fast and easy approach of sorting work with a portion of data so that you are able to display only the rows in your spreadsheet that meets your standard. This can involve rows that have specific numbers or text that are more than or less than a particular number that you have specific about. Filtering will hide these rows that do not meet your criteria temporarily; this put up with you to see only the information that you are interested in. All that you have to do to filter given data is to format the filtering and tag the items that you wish to visualize, everything else will be isolated.

If a spreadsheet is containing a lot of data, it will be difficult to find information fast.

Filters can be used to contract for the information in your spreadsheet, allowing you to be able to view only the information that is relevant to you.

To start Data Filtering:

We need to know how to apply data filtering in Ms-Excel in the example below, we will learn how to apply data filtering in Microsoft Excel.

  1. In order for filtering to work perfectly, your worksheet should have a Header row, which is used to know the title of each column. The worksheet below is arranged into different columns identified by the header cells in row 1

Data Filtering in Excel

  1. choose the data tab, then left click on the filter

Data Filtering in Excel

  1. A pull-down menu will appear in the header cell for each vertical section
  2. Click the pull-down menu for the column you wish to filter “column B” to view only certain types of equipment. Data Filtering in Excel
  3. The filtering option will appear
  4. Uncheck the box next to select all to immediately deselect all information

Data Filtering in Excel

  1. Check the box next to the data you desire to filter, click ok. Data Filtering in Excel
  2. The information will be filtered, hiding any content that does not fit the criteria. Data Filtering in Excel

Data Filtering can also be accessed in the sort & filter option

HOW TO APPLY MULTIPLE FILTERS

A Filter is cumulative, this implies that you can apply multiple filters to help find your result.

  1. Left click on the arrow for the column you wish to filter. Data Filtering in Excel
  2. The filter option will appear
  3. Check or uncheck any box depending on the data you wish to filter, then click ok.

Data Filtering in Excel

  1. Filtering will be applied. In the example below, the spreadsheet is now filtered to show only laptops and tablets that were cop-out in August Data Filtering in Excel

TO CLEAR A FILTER:

After filtering has been done, you might want to change or do away with the filtering. Clearing can also be done by following the steps below:

  1. Click the drop-down menu for the filter you wish to clear. In the example below, we will clear the filter in column D Data Filtering in Excel
  2. The filter menu will show up.
  3. Select “clear filter” from the filter menu. Data Filtering in Excel
  4. The filter will be removed from the column. The former hidden information will be visible.

Data Filtering in Excel

Was this article helpful?

Related Articles

Leave a Reply