Filter Ranges in Microsoft Excel

Filter Ranges in Microsoft Excel

 

 
You can analyse table data faster by filtering the data. Filtering a table means that you configure a field so that you only view the table records that you want to work with.

 

One way to do this is to use the AutoFilter feature, which presents you with a list of check boxes for each unique value in a field. You filter the data by activating the check boxes for the records you want to see.