Microsoft Office Tutorials and References
In Depth Information
SORT
a PivotTable
Sorting enables you to see patterns in your data. You
can sort PivotTables by field labels or by data values.
When you sort by field labels, the corresponding data
values are sorted as well. The opposite is also true:
sorting the data values rearranges the field labels.
You can sort your PivotTable in either ascending or
descending order. You can also specify the sort
direction: top to bottom or left to right. This can get a
bit confusing, so the Sort By Value dialog box provides
an explanation of the results of your sort selection.
Did You Know?
You can click the down arrow next to
the field header to sort and filter your
PivotTable data. For more information
on sorting and filtering with field
headings, see Chapter 4.
2
S ORT F IELD L ABELS
1
4
Click any field in your
PivotTable.
l The PivotTable tools become
available.
1
3
2
Click the Options tab.
3
Click and drag to select the field
labels you want to sort.
4
Click the ascending or
descending button.
Excel sorts your field labels.
S ORT D ATA F IELDS
1
Click and drag to select the data
you want to sort.
2
Click Sort.
l The Sort By Value dialog box
appears.
2
3
Click a Sort option (
changes
to
).
4
Click a Sort direction
( changes to ).
l The Sort By Value dialog box
provides an explanation of what
will result from your sort
selection.
1
3
4
5
5
Click OK.
Excel sorts your data fields.
Chapter 5
121
Search JabSto ::




Custom Search