Excel AutoFilter

[Gail]

Is there a limit to the number of rows or unique values that AutoFilter can
display in its dropdown menus?

Gail

 

[Frank Kabel]

Hi
see:
http://www.contextures.com/xlautofilter02.html#Limits

 

[Ron de Bruin]

hi Gail

See
http://www.contextures.com/xlautofilter02.html#Limits

If you want to Filter on one column see
http://www.rondebruin.nl/easyfilter.htm