Microsoft Office Tutorials and References
In Depth Information
Managing Large Amounts of Data
You can also sort your data horizontally. Choose
Data>Sort & Filter>Sort. Click the Options button
and choose Sort Left to Right then click OK. Define
your sort choices in the Sort dialog box and click OK.
6. In the Then By section, select the secondary
column you want to sort by if two or more
items are identical in the first Sort By option
(see Figure 11-25).
Sorting by Multiple Criteria
What about those times when, after sorting your
data, you have multiples of the same item. For
example, if you sort an employee list by last name
and you have three employees with the last name
Wilson. Well, you can apply a secondary sort, for
example on first name. Doing so would then list
Barbara Wilson, John Wilson, and then Stephen
Wilson. Just follow these steps:
Selecting a second sorting level.
Select or click in the list of data you want to
Select how you want to sort the second data
criteria. Repeat as needed. You can have up
to 256 sorting levels.
2. Choose Data>Sort & Filter>Sort. The Sort
dialog box opens.
Delete Sort Level
3. Select whether to include column headings
in the sort.
To delete an entry, select the sort entry and
choose Delete Level. You must keep at least
one sort entry in the list.
4. Set up the primary sort criteria as in the
8. Click OK. Excel performs the sort process.
Figure 11-26 illustrates data rows sorted first
by House Type and then by the number of
Excel sorts dates formatted with slashes such
as 11/22/68, as numeric data. Dates with the
day or month spelled out must be sorted
differently. See the section, “Sort by Day, Month,
or Custom List” later in this chapter.
5. Click the Add Level button.