Microsoft Office Tutorials and References
In Depth Information
1. Display a resource view (such as Resource Sheet view) to filter for
resources or a task view (such as Gantt Chart view) to filter for tasks.
2. Click the Filter list on the Formatting toolbar and then choose a
The Filter list is a drop-down list; when no filter is applied, All Tasks or
All Resources appear in the list. If you choose a filter that requires input,
you’ll see a dialog box such as the one in Figure 10-1. Otherwise, the
filter is applied immediately and removes from view any resources or
tasks that don’t match your criteria.
3. If a dialog box is displayed, fill in the information and then click OK.
The filter is applied.
To redisplay all tasks or resources, click Filter on the Formatting toolbar
and then click either All Resources or All Tasks (depending on whether a
Resource or Task filter is currently applied).
Putting AutoFilters to work
You can also use the AutoFilter button on the Formatting toolbar to turn on
an AutoFilter feature. When you click the AutoFilter button, arrows appear at
the head of columns in the currently displayed sheet. Click the arrow for the
Task Name column (for example), and the name of every task in your project
is listed in alphabetical order. Click a task name, and all tasks but that task
and any parent tasks for it are removed from view. You can also choose a
Custom setting from each of these menus (as shown in Figure 10-2) to
customize AutoFilter with certain criteria.
Follow these steps to activate and use AutoFilter:
1. Display the view that contains the fields (columns) you want to filter.
2. Click the AutoFilter button.
Arrows appear at the top of each column.
3. Click the arrow on the column that you want to filter.