View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Excel Auto Filter will not show all items in the drop down - why?

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?