XL2000: Too Many Blank Cells Are Returned When You Use AutoFilter

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 than expected.

This behavior can occur if you select an area other than your list when you use the AutoFilter command. For example, the behavior occurs if you select an entire column and then apply AutoFilter.

To work around this issue, select only the range that includes the list, and then apply AutoFilter. To select the range, follow these steps:

1. Press F5.
2. In the Reference box, type the cell address of the upper-left corner of the range, followed by a colon, and the cell address of the lower-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.

For additional information about resetting last cell addresses, click the article number below to view the article in the Microsoft Knowledge Base:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

For more information about filtering data, click Microsoft Excel Help on the Help menu, type ways to find values in a list by using filters (overview) in the Office Assistant or the Answer Wizard, and then click Search to view the topic.