• Excel Video Tutorials

Data Filtering in Excel 2010


Advertisements

Filters in MS Excel

Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.)

Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this. Follow the below mentioned steps to do this.

  • Place a cursor on the Header Row.

  • Choose Data Tab » Filter to set filter.

Set a filter
  • Click the drop-down arrow in the Area Row Header and remove the check mark from Select All, which unselects everything.

  • Then select the check mark for Size 36 which will filter the data and displays data of Shoe Size 36.

  • Some of the row numbers are missing; these rows contain the filtered (hidden) data.

  • There is drop-down arrow in the Area column now shows a different graphic — an icon that indicates the column is filtered.

Filterd Output

Using Multiple Filters

You can filter the records by multiple conditions i.e. by multiple column values. Suppose after size 36 is filtered, you need to have the filter where color is equal to Coffee. After setting filter for Shoe Size, choose Color column and then set filter for color.

Multiple Filters

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements