Hide Resource Rows in Microsoft Project Task Usage View
Question details
Show task rows and task-level hours in Task Usage view without displaying resource assignment rows.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A user wants a task-level view of scheduled hours without using VBA.
- Observed behavior
- Task Usage view displays resource assignment rows beneath task rows.
Open the project and select View > Task Usage. Check that the timephased area displays the hours or Work values you want to review.
Filter out assignment rows in Task Usage view
Use a built-in task filter to hide resource assignment rows while retaining task rows and their hours.
In Task Usage view, open the Filter drop-down on the View tab and select More Filters.
In More Filters, select Task if prompted, then choose New and enter a name such as Tasks Only.
In the filter definition, select Assignment as the field name, Equals as the test, and No as the value. Save the filter.
Select the new filter in More Filters and click Apply. Task rows should remain visible while assignment rows are hidden.

Track Task Hours in WPS Spreadsheet
WPS Office is a free, lightweight alternative for everyday office work. Its familiar interface and Microsoft Office format compatibility make it easy to migrate spreadsheets and track task hours manually. It does not change Microsoft Project views or replace Project's assignment filter.

Frequently Asked Questions
Will filtering out resource rows delete the assignments?
No. The Assignment equals No filter only hides assignment rows in the current view; it does not remove the assignments from the project.
How do I show the resource rows again?
On the View tab, open the Filter drop-down and select No Filter.
Can I still see task-level hours after applying the filter?
Yes. Task rows remain visible, including their timephased hours or Work values when those details are displayed in Task Usage view.
Do I need VBA to hide assignment rows?
No. Create a task filter through View > Filter > More Filters and set Assignment to equal No.




