Others

Hide Resource Rows in Microsoft Project Task Usage View

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

Question details

Show task rows and task-level hours in Task Usage view without displaying resource assignment rows.

Hide Resource Rows in Microsoft Project Task Usage View
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.
Before you start

Open the project and select View > Task Usage. Check that the timephased area displays the hours or Work values you want to review.

Solution 1Recommended

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.

1
Open the filter list

In Task Usage view, open the Filter drop-down on the View tab and select More Filters.

2
Create a task filter

In More Filters, select Task if prompted, then choose New and enter a name such as Tasks Only.

3
Set the filter condition

In the filter definition, select Assignment as the field name, Equals as the test, and No as the value. Save the filter.

4
Apply the filter

Select the new filter in More Filters and click Apply. Task rows should remain visible while assignment rows are hidden.

Filter out assignment rows in Task Usage view
The assignments remain in the project: Filtering changes what is displayed; it does not delete resource assignments. Select No Filter from the View tab's Filter drop-down to show them again.
Free Microsoft Office alternative

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.

Organize task names and hours in a spreadsheet.Open and edit Microsoft Excel XLSX files for sharing task reports.Use a familiar interface for everyday document and spreadsheet work.Move existing Office files into a lightweight, free office suite.
microsoft office alternative - wps office

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.