But see http://www.contextures.com/xlautofilter02.html for a workround.
--
David Biddulph

"Mike H" wrote in message
...
Hi,

It' limited to 1000 prior to Excel 2007.

Mike

"Gerin" wrote:

I have a huge spreadsheet.
I started the Auto Filter. In the drop down for one of the rows it will
not
show me the content even though the filter is set for "ALL" on each
column -
any idea why?