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.

 

 

 

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips