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??
|