XL98: Data Sort Using Incorrect Guess Range

• Microsoft Excel 98 Macintosh Edition

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

A1: peach
A2: APPLE
A3: orange
A4: banana

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

sorting

Additional query words: XL98

Keywords : kbdta xllist
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb