Data Filtering in Excel 2010

Data Filtering in Excel 2010

How to use the filtering data in Ms Excel 2010/2007

Filtering data in Excel refer to displaying only the rows that meet certain conditions.

For example : If you want to see data where Name is VINAFONE, then you can set filter to do this.

·                  Choose Data Tab-à Filter

·                  Click the drop-down arrow in the Area Row header and remove the check mark from “select all”

·                  Then select the check mark for “VINAFONE”.

USING MULTIPLE FILTERS

You can filter the record by multiple conditions . Suppose after Nam is VINAFONE is filtered, you want to filter where Order ID is “002” . You click drop-down and select “ 002”