Article ID: 176860
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 98 for Macintosh
This article was previously published under Q176860
SYMPTOMS
When you use the AutoFilter command to view the number of blank cells in a
column of data, the number of blank cells that are returned may be
different from what you expect.
CAUSE
This problem may occur if you select an area other than your list when you
apply the AutoFilter. For example, the problem occurs if you select an
entire column and then apply the AutoFilter.
WORKAROUND
To work around this behavior, select only the range that includes the
list, and then apply the AutoFilter. To select the range, follow these
steps:
- Press F5.
- In the Reference box, type the cell address of the top left corner of
the range, followed by a colon and the cell address of the bottom right
corner of the range.
For example, if the range is from cell A1 through cell E100, type
"A1:E100".
- Click OK.
After you select the range, point to Filter on the Data menu, and then
click AutoFilter.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
REFERENCES
For more information about filtering data, click the Index tab in
Microsoft Excel Help, type the following text
filters, overview
and then double-click the selected text to go to the "Display a subset of
rows in a list by using filters" topic.
Additional query words: XL5 XL7 XL97 Unexpected number extra blanks wrong XL
Keywords: kbbug kbpending KB176860