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.

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.

--
Regards

Roger Govier


"Cary" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.