Autofilter in Excel 2007

[Cary]

I have a sheet of financial data to which I have applied the autofilter.
Clicking on the downarrow in each of the header fields produces a series
of options one of which is the filter. This filter box then lists the
discrete data for that particular field with an associated checkbox.

However, the one field I do want to filter in this manner - "Payees" -
displays a Text Filter box with only one choice: Select All. In Excel
2003 all the Payees would be appropriately listed for selection.

Que pasa? I want to use this approach to extract records pertaining to
selected payees.

 

[Roger Govier]

Hi

It works absolutely the same in XL2007 as XL2003.
Do you perhaps have a blank row under your heading before the start of
your data?
This would cause the behaviour you describe.