Microsoft Office Tutorials and References
In Depth Information
3. If your data includes column headings, make
sure the My Data Has Headers option is
checked. Excel does not include header rows
in the sort process. If the data doesn’t include
column headings, deselect the option.
Check the Formatting
If Excel incorrectly sorts a cell that contains a
value, make sure the cell is formatted as a
number and not as text.
4. From the Sort By drop-down menu, select
the column by which you want to sort (see
Working with the Sort
Okay, now for the more powerful way of sorting
Excel data. The Excel Sort command not only
supplies several ways you can sort your data, it provides
options for sorting your data horizontally or even
whether or not to sort by capitalization. The
following steps show you how to use the Sort command:
If you do not have header rows, Excel
displays Column A, Column B, and so forth.
5. From the Sort On drop-down menu, choose
Select or click in the list of data you want to
6. From the Order drop-down menu, select how
you want to sort the data:
Single Column Sort
To sort text values, choose A to Z or Z
Select only a single column of data if you
want to sort that column independently of
the rest of the data.
To sort numeric data, choose Smallest
to Largest or Largest to Smallest.
To sort by dates, choose Oldest to
Newest or Newest to Oldest.
2. Choose Data>Sort & Filter>Sort. The Sort
dialog box opens (see Figure 11-24).
Click the Options button if you want to make
the sorting case-sensitive so that non-capital-
ized words appear before capitalized words.
The Sort dialog box.