ExcelBanter - filter not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - filter not working (https://www.excelbanter.com/excel-discussion-misc-queries/262977-filter-not-working.html)

Kim

filter not working

I am using excel 2007 and my auto filter is not working. There is no drop
down box for "blanks" or any of the items except for "select all". Any ideas?

Teethless mama

filter not working

Select your range, then Auto Filter, don't let Excel guess your range.

"Kim" wrote:

I am using excel 2007 and my auto filter is not working. There is no drop
down box for "blanks" or any of the items except for "select all". Any ideas?

Kim

filter not working

Teethless mama - you are "the bomb". That worked. Thanks.

"Teethless mama" wrote:

Select your range, then Auto Filter, don't let Excel guess your range.

"Kim" wrote:

I am using excel 2007 and my auto filter is not working. There is no drop
down box for "blanks" or any of the items except for "select all". Any ideas?

All times are GMT +1. The time now is 05:40 PM.