XL98: Data Sort Using Incorrect Guess Range (192380)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q192380 SYMPTOMS
In Microsoft Excel, when you select a single cell in a list and click Sort
on the Data menu, an incorrect range of data may be selected.
CAUSE
This problem occurs when the data in the second row of the first column in
the list is typed entirely in capital letters and the data in the third row
of the first column in the list is not typed entirely in capital letters.
When you sort data by selecting a single cell in a list and clicking Sort
on the Data menu, Microsoft Excel detects the column labels in the list,
excludes them from the data that is sorted, selects the data to be sorted,
and then displays the Sort dialog box. However, if the data in the second
row of the first column in the list is typed entirely in capital letters
and the data in the third row of the first column in the list is not typed
entirely in capital letters, Microsoft Excel treats the first two rows as
column labels and does sort these rows.
Example
If you select a single cell in the following list
A1: peach
A2: APPLE
A3: orange
A4: banana
and click Sort on the Data menu, the items orange and banana are selected
as the data to be sorted. Microsoft Excel treats the items peach and APPLE
as column labels and excludes them.
WORKAROUND
To work around this behavior, select the entire list (including the column
labels) before you click Sort on the Data menu, and select Header Row
under "My list has" in the Sort dialog box.
REFERENCES
For more information about sorting, click Contents And Index on the Help
menu (or on the Balloon Help menu if you are using a version of the
Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
and then click Show Topics. Select the "Sort a list" topic, and
click Go To. If you are unable to find the information you need, ask the
Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB192380 |
|---|
|