Microsoft Office Tutorials and References
In Depth Information
Perform simple
SORTS AND FILTERS
Sorting and filtering your lists offers different views
of your data. When you sort, you rearrange your
data in ascending or descending order.
The meaning of these terms depends on the kind of
data you have. Customer data arranged by the date
in ascending order shows the earliest record first;
descending order shows the latest record first. When
you sort by customer name, the names appear in
ascending (A to Z) or descending (Z to A) order.
When you sort numeric data in ascending order, the
numbers sort from the lowest number to the highest.
In descending order, numbers sort from the highest
to the lowest. When you sort a list, you can easily
find data, group data, and present it meaningfully to
others.
Filtering works like a sieve through which you pass
your data, displaying only data that meets your
criteria. In a customer survey, for example, you can
choose to view only customers who live in a certain
state or city or are of a certain age or gender.
2
S ORT A L IST
1
3
Click in a cell in a list.
2
Click the Data tab.
1
3
Click a sort direction.
Click A to Z to sort from lowest
to highest — ascending order.
Click Z to A to sort from highest
to lowest — descending order.
l Excel sorts your list.
F ILTER A L IST
1
2
3
Click in a cell in your list.
2
Click the Data tab.
1
3
Click Filter.
86
 
Search JabSto ::




Custom Search