AutoSelect May Detect a Double Header
Article ID: 135717
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 95a
- Microsoft Excel 5.0 for Macintosh
- Microsoft Excel 5.0a for Macintosh
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q135717
SYMPTOMS
When the first two rows of your database contain all text and you click
Sort or AutoFilter on the Data menu (commands that automatically select a
range of cells), the second row of text may be treated as the header row.
CAUSE
When two complete rows of text are at the beginning of the database and
the third row contains text and numbers or just numbers, the auto detect
features of Microsoft Excel may treat your second row of the database as
the header row. This behavior will occur if all of your fields for the
second row in your database contain text values. If just one field in this
second row contains a numeric value, then your first row of the database
will be treated as the header row.
WORKAROUND
If you want all of your rows to be included in the database, and if you
want the first row to be treated as the header row, then select all of the
cells in your database prior to using either the Sort or the AutoFilter
commands.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words: 5.00a 5.00c 7.00a 97 XL97 XL7 XL5 XL
Keywords: kbbug kbpending KB135717