Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Applying a Data Filter

When working with a large data table, it is sometimes useful to filter the table so that you can only see or work with a specific set of records. For instance, let’s say you only want to see the sales reps in Region 2. When you want to work with a subset of records, you can use Excel’s Filter. The Filter function allows you to see only those records that meet the criteria you select.

start.jpg

circle_1.jpg Click on the Filter command on the Data tab.

circle_2.jpg You will immediately see filter drop-downs inside each of your header columns. Click on the drop-down selector for the column you want to filter.

circle_3.jpg Click the (Select All) option to clear all the check boxes, then click the check box next to the value by which you want to filter.

circle_4.jpg Click the OK button to apply the filter. Observe the funnel icon on the filtered column, indicating a filtered state.

end.jpg
  • + Share This
  • 🔖 Save To Your Account