You sure it is 500 and not 1000?

The AF dropdown list will show only 1000 unique items.

For workarounds see Debra Dalgleish's site.

http://www.contextures.on.ca/xlautofilter02.html#Limits


Gord Dibben MS Excel MVP

On Sat, 27 Sep 2008 14:37:01 -0700, Stuart E
wrote:

Hi I'm trying to place a data filter at the top of a column that can sort the
data within that column. The filter works but it doesn't cover the whole
column some of the info is not shown as an option to select when I try to use
the filter. It seems to be the data at the bottom of the sheet from approx
line 500 onwards