How to Filter by Item in Microsoft Project
Managing a large project schedule can be challenging, especially when hundreds or thousands of tasks are displayed at the same time. Microsoft Project provides powerful filtering tools that allow you to focus only on the activities you need to review.
Filtering helps project managers, engineers, planners, and contractors quickly identify specific tasks, resources, milestones, delays, or work packages without affecting the original schedule.
Why Use Filters?
Filters help you:
Focus on specific activities.
Review critical project information quickly.
Track delays and unfinished work.
Analyze resource assignments.
Improve schedule reporting and presentations.
Instead of scrolling through hundreds of activities, filters allow you to display only the information that matters.
Method 1: Using Built-In Filters
Microsoft Project includes several ready-to-use filters.
Steps
Open your project schedule.
Go to View tab.
Locate the Filter dropdown.
Select a predefined filter.
Common Built-In Filters
| Filter | Purpose |
|---|---|
| Critical | Show critical path activities |
| Milestones | Show milestone tasks only |
| Completed Tasks | Show finished activities |
| Incomplete Tasks | Show unfinished activities |
| Late Tasks | Show delayed activities |
| Using Resource | Show tasks assigned to a specific resource |
Method 2: AutoFilter (Excel-Style Filtering)
AutoFilter works similarly to Microsoft Excel.
Steps
Go to View tab.
Select Filter.
Enable AutoFilter.
Small filter arrows will appear in each column header.
You can then filter by:
Task Name
WBS
Resource Name
Duration
Start Date
Finish Date
Status
Example
| Task Name | Resource |
|---|---|
| Foundation | Team A |
| Column | Team B |
| Slab | Team A |
Filter by:
Resource = Team A
Result:
| Task Name | Resource |
|---|---|
| Foundation | Team A |
| Slab | Team A |
This allows you to isolate specific teams, subcontractors, or departments instantly.
Method 3: Creating a Custom Filter
Custom filters provide greater flexibility.
Steps
Go to View → Filter → More Filters.
Click New.
Define your filtering criteria.
Example
Show activities longer than 10 days:
| Field Name | Test | Value |
|---|---|---|
| Duration | Greater Than | 10d |
Result:
Only tasks exceeding 10 days will be displayed.
Method 4: Filtering by WBS
Work Breakdown Structure (WBS) filtering is extremely useful for construction projects.
Example WBS
1.0 Site Preparation
1.1 Survey
1.2 Clearing
2.0 Foundation
2.1 Excavation
2.2 Footing
3.0 Structure
3.1 Columns
3.2 Beams
Filter
| Field | Test | Value |
|---|---|---|
| WBS | Contains | 2 |
Result
2.0 Foundation
2.1 Excavation
2.2 Footing
This allows planners to focus on one work package at a time.
Method 5: Filtering by Resource
Resource filters help track team workloads and responsibilities.
Steps
Go to View → Filter.
Select Using Resource.
Choose a resource.
Examples:
Site Engineer
Architect
Foreman
MEP Team
Structural Team
Subcontractor
Microsoft Project will display only the tasks assigned to the selected resource.
Method 6: Highlight Instead of Hiding
Sometimes you want to keep all tasks visible while emphasizing specific activities.
Steps
Go to View.
Select Highlight.
Choose a filter.
Examples:
Critical Tasks
Milestones
Late Tasks
Custom Filter
The matching activities are highlighted while all other tasks remain visible.
Recommended Filters for Construction Projects
For general contractors and construction planners, the following filters are especially useful:
Critical Tasks
Identify activities that directly affect the project completion date.
Milestones
Track key approval points, inspections, and handovers.
Late Tasks
Monitor schedule delays before they impact project delivery.
Resource Filter
Review work assigned to each team or subcontractor.
WBS Filter
Focus on a specific floor, zone, building, or work package.
AutoFilter
Quickly sort and filter:
Building
Zone
Floor
Trade
Subcontractor
Activity Type
Status
Key Takeaway
Filtering is one of the most powerful tools in Microsoft Project. Instead of viewing the entire schedule, filters allow project managers and engineers to focus on the right information at the right time. By using built-in filters, AutoFilter, WBS filters, and resource filters, you can analyze your schedule more efficiently, improve reporting, and make better project decisions.