Too Many Blank Cells Are Returned When Using AutoFilter (176860)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
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.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbbug kbpending KB176860 |
|---|
|