Microsoft KB Archive/176860

= Too Many Blank Cells Are Returned When Using AutoFilter =

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:


 * 1) Press F5.
 * 2) 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".
 * 3) 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.

