Autofilter trouble
 

I am trying to apply Autofilter to the headers in a table that has
already been created. But in the dropdown list there are only : All,
Top Ten, and Custom. Any clue as to why none of the items in the table
or blanks, non-blanks are not appearing in the dropdown??

Autofilter trouble
 

It sounds like you only selected the column headings and none of the data
below them.

Try selecting the entire data range (including the headings)
Or just one cell within the range (to let Excel figure out where it begins
and ends.)

Then engage the AutoFilter

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Matt" wrote:

I am trying to apply Autofilter to the headers in a table that has
already been created. But in the dropdown list there are only : All,
Top Ten, and Custom. Any clue as to why none of the items in the table
or blanks, non-blanks are not appearing in the dropdown??

Autofilter trouble
 

Sounds like you have an empty row after your headings, try selecting the
entire data area.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Matt" wrote:

I am trying to apply Autofilter to the headers in a table that has
already been created. But in the dropdown list there are only : All,
Top Ten, and Custom. Any clue as to why none of the items in the table
or blanks, non-blanks are not appearing in the dropdown??

Autofilter trouble
 

That did the trick! Thanks!

John Bundy wrote:
Sounds like you have an empty row after your headings, try selecting the
entire data area.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Matt" wrote:

I am trying to apply Autofilter to the headers in a table that has
already been created. But in the dropdown list there are only : All,
Top Ten, and Custom. Any clue as to why none of the items in the table
or blanks, non-blanks are not appearing in the dropdown??