How To: Filter Tasks in MS Project

Ever wonder how to reduce your Microsoft Project file from thousands of tasks down to a manageable few hundred, without deleting any?  Have you tried filtering?  This post discusses the steps to filter tasks in Microsoft Project.

Filtering is the act of reducing the number of visible tasks so that you only see what you are interested in.  All the tasks will still exist in the MPP file, but you will only see tasks that correspond to your filter criteria.  Follow these steps to filter tasks in Microsoft Project.

Create some tasks to filter by:

  1. Enter three tasks
  2. Set the durations to 10 hours, 20 hours, and 0 hours
  3. The results should look like the image below

 

 

 

Set up a new filter to show long tasks only:

  1. Choose Project, Filtered, More Filters…
  2. Click New
  3. Enter the name “Long tasks” (without the quotes)
  4. Click ‘Show in menu’
  5. Click in the ‘Field Name’ column, and choose ‘Duration
  6. Click in the ‘Test’ column and choose ‘is greater than’
  7. Click in the ‘Values(s)’ column and enter 10
  8. Click OK to save the new filter
  9. Nothing should change in your view

 

Activate your task filter:

  1. Choose Project, Filtered, Long Tasks (the new filter you created)
  2. Your view should now look like this image (hiding all the short tasks)
  3. Choose Project, Filtered, All Tasks to remove the filtering and show all tasks

 

 

 

–ray