Microsoft Office Tutorials and References
In Depth Information
Sorting a Table
Sorting a Table
Sort Order
Excel uses the following
order of priority: numbers
from smallest to largest
positive, (space), special
characters, text, (blanks).
For example, the sort
order is: 0 1 2 3 4 5 6 7 8
9 (space) ! “ # $ % & ( ) *
, . / : ; ? @ [ \ ] ^ _ ` { | } ~ +
< = > A B C D E F G H I J K
L M N O P Q R S T U V W
X Y Z (blanks).
The data in a table is easier to work with and more meaningful if the records are arranged
sequentially based on one or more fi elds. Arranging records in a specifi c sequence is called
sorting . Data is in ascending sequence if it is in order from lowest to highest, earli-
est to most recent, or alphabetically from A to Z. For example, the records in the Silver
Photography Accessories Sales Rep table were entered in no particular order. Data is in
descending sequence if it is sorted from highest to lowest, most recent to earliest, or
alphabetically from Z to A. The fi eld or fi elds you select to sort the records are called
sort keys .
You can sort data in a table using one of the following techniques:
1. Select a cell in the fi eld on which to sort, click the Sort & Filter button on the
Home tab on the Ribbon, and then click one of the sorting options on the Sort &
Filter menu.
2. With the table active, click the column heading arrow in the column on which to
sort and then click one of the sorting options in the table.
3. Use the Sort button on the Data tab on the Ribbon.
4. Right-click anywhere in a table and then point to Sort on the shortcut menu to
display the Sort submenu.
To Sort a Table in Ascending Sequence by Name Using the Sort & Filter Button
The following example shows how to sort the table in ascending sequence by name using the Sort & Filter
button on the Home tab on the Ribbon.
1
If necessary, click the Home tab on
the Ribbon.
Sort &
Filter
button
Select cell A9, click the Sort &
Filter button on the Ribbon, and
then point to the Sort A to Z com-
mand on the Sort & Filter menu
(Figure 5–35).
Sort A to Z
command
What if the column I choose
includes numeric or date data?
If the column you choose includes
numeric data, then the Sort &
Filter menu would show the
Sort Smallest to Largest and Sort
Largest to Smallest commands
instead of the Sort A to Z and
Sort Z to A commands. If the col-
umn you choose includes date
data, then the Sort & Filter menu
would show the Sort Oldest to
Newest and Sort Newest to Oldest
commands instead of the Sort A
to Z and Sort Z to A commands.
Sort &
Filter
menu
cell selected
in column
on which
to sort
Figure 5–35
 
 
Search JabSto ::




Custom Search