Microsoft Office Tutorials and References
In Depth Information
Sorting Project details
Click the AutoFilter arrow in the Cost column heading, and in the menu that appears,
click Sort Largest to Smallest .
TIP If you do not see the AutoFilter arrows in the column headings, try this: on the
View tab, in the Data group, in the Filter box, click Display AutoFilter.
The Resource Sheet view is sorted by the Cost column in descending order.
You can quickly sort a table by clicking on the AutoFilter arrow.
This arrangement is fine for viewing resource costs for the entire plan, but perhaps
you’d like to see this data organized by resource group. To see this, you’ll apply a
two-level sort order.
On the View tab, in the Data group, click Sort , and then click Sort By .
The Sort dialog box appears. In it, you can apply up to three nested levels of sort
Under Sort By , click Group on the drop-down list, and next to that, click Ascending .
TIP When selecting items from a list like this, you can often begin typing the name
of the item you want, and when its full name appears, select it.
Group here refers to the Resource Group field, which, for the new children’s book
plan, contains values like Design and Editorial ; these are the groups with which most
of the resources in the plan are associated. These values were previously added to the
plan for you.
Under Then By (in the center of the dialog box), click Cost on the drop-down list, and
next to that, click Descending .